Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3496

CallableStatement with output parameter leaves cursor open after execution

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.4.1.3
    • 10.3.3.0, 10.4.1.3
    • JDBC
    • None

    Description

      When executing a CallableStatement which has an output parameter, the language result set is left open and makes subsequent calls to Connection.setTransactionIsolation() fail with "ERROR X0X03: Invalid transaction state - held cursor requires same isolation level".

      Attachments

        1. derby-3496.diff
          1 kB
          Dyre Tjeldvoll
        2. junit-repro.diff
          1.0 kB
          Knut Anders Hatlen

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-3427 setting transaction isolation level to read committed raise ERROR X0X03: Invalid transaction state - held cursor requires same isolation level

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              dyret Dyre Tjeldvoll
              knutanders Knut Anders Hatlen
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: