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: domain of gcaddu-derby-user@m.gmane.org
 designates 80.91.229.2 as permitted sender)
To: derby-user@db.apache.org
From: epdv <peter.nabbefeld@gmx.de>
Subject: Re: How to read blobs?
Date: Fri, 06 Mar 2009 11:24:38 +0100
Lines: 29
Message-ID: <goqtl6$sip$1@ger.gmane.org>
References: <gookk6$ua1$1@ger.gmane.org>
 <5627810d0903050937v1fb851doe4be24dcb16b75c7@mail.gmail.com>
 <goqhhs$p13$1@ger.gmane.org> <49B0D50F.7060608@Sun.COM>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de;
 rv:1.9.1b3pre) Gecko/20081202 SeaMonkey/2.0a2
In-Reply-To: <49B0D50F.7060608@Sun.COM>
Sender: news <news@ger.gmane.org>

Kristian Waagan schrieb:
> 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.
>

If I understand correctly, I'll need to open one connection per opened 
(not yet closed) stream then. How can I open a pooled connection then, 
without using J2EE (can only find docs for j2ee ... :-( )?

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

I'll look at this later, as cannot use my current code, thus problems 
might disappear just while doing my changes, as a "side-effect" ;-)


Kind regards

Peter