db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <Kristian.Waa...@Sun.COM>
Subject Re: How to read blobs?
Date Fri, 06 Mar 2009 07:47:27 GMT
epdv wrote:
> Thank You for the answer - but I've also got problems with 
> autocommit(false): Recordset not open. How can I get the InputStream 
> then, and can I access the opened InputStream independently from the 
> blob, i.e. can I read the stream still after freeing the blob?

You can operate on the Blob until you commit or rollback if you turn off 
As soon as you call Blob.free(), the Blob object, or any objects 
obtained from it (like an InputStream), cannot be used any more. This 
holds regardless of whether you have committed/aborted or not.

The problem you see with the result set, must be something else.


> Kind regards
> Peter Nabbefeld
> Donald McLean schrieb:
>> You cannot use blobs with autocommit(true). It just doesn't work.
>> Donald
>> On Thu, Mar 5, 2009 at 8:38 AM, epdv<peter.nabbefeld@gmx.de>  wrote:
>>> Hello!
>>> I want to read blobs in a loop (more exact: the length of the blobs). 
>>> I'm
>>> using a connection with autocommit(true) and a prepared statement 
>>> with sth.
>>> like "select mydata, myblob where mykey=?".
>> -------------------------------------------------------------
>> Family photographs are a critical legacy for
>> ourselves and our descendants. Protect that
>> legacy with a digital backup and recovery plan.

View raw message