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

Closing a resultset after retrieving a large > 32K value with Network Server does not release locks

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.0.2.0, 10.0.2.1, 10.0.2.2, 10.1.1.0
    • 10.1.1.0
    • Network Server
    • None

    Description

      Closing a resultset after retriving BLOB or CLOB data > 32K, does not release locks properly. Network Server uses getClob, getBlob to retrieve the data even if the application uses getCharacteStream, etc, so holds locks to the end of the transaction.

      To reproduce run attached repro
      java LargeDataLocks derbynetclient

      To see the difference with embedded
      java LargeDataLocks derby

      Attachments

        1. LargeDataLocks.java
          10 kB
          Katherine Marsden
        2. derby255.diff
          64 kB
          Katherine Marsden
        3. DERBY-255_irc_6_2_2005
          3 kB
          Katherine Marsden

        Issue Links

          Activity

            People

              kmarsden Katherine Marsden
              kmarsden Katherine Marsden
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: