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
autocommit.
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.
--
Kristian
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<[email protected]> 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.
