This condition is very frequently caused when the user has autocommit set to true. BLOBs and CLOBs can only be used inside a transaction (i.e. autocommit set to false). Don't forget to commit the transaction after you have finished with the BLOB/CLOB.
On Tue, Dec 29, 2009 at 5:15 PM, geoffrey hendrey <[email protected]> wrote: > On Derby 10.4.1.3 I see the following error. "ERROR XJ073: The data in this > BLOB or CLOB is no longer available. The BLOB/CLOB's transaction may be > committed, or its connection is closed." Are there any known issues around > this? It occurs intermittently, and I've never seen in happen twice in a > row. I don't think I'm prematurely closing the connection. I found a Jira > issue around this, but it seemed like the discussion concluded it was user > error. Thought I would ping the list to see if there are any known bugs on > this. -- Family photographs are a critical legacy for ourselves and our descendants. Protect that legacy with a digital backup and recovery plan. Join the photo preservation advocacy Facebook group: http://www.facebook.com/home.php?ref=logo#/group.php?gid=148274709288
