Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
MIME-version: 1.0
Content-transfer-encoding: 7BIT
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Date: Fri, 06 Mar 2009 08:47:27 +0100
From: Kristian Waagan <Kristian.Waagan@Sun.COM>
Subject: Re: How to read blobs?
In-reply-to: <goqhhs$p13$1@ger.gmane.org>
Sender: Kristian.Waagan@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <49B0D50F.7060608@Sun.COM>
References: <gookk6$ua1$1@ger.gmane.org>
 <5627810d0903050937v1fb851doe4be24dcb16b75c7@mail.gmail.com>
 <goqhhs$p13$1@ger.gmane.org>
User-Agent: Thunderbird 2.0.0.18 (X11/20090203)

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<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.
>>
> 
>