db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Donald McLean" <dmclea...@gmail.com>
Subject Re: cannot invoke other java.sql.Clob
Date Tue, 22 Jul 2008 04:04:29 GMT
I've seen cases like this where autocommit didn't seem to want to STAY
off. Try turning it off just before the select - just to be completely
sure. What could it hurt?


On Mon, Jul 21, 2008 at 11:51 PM, Daniel Noll <daniel@nuix.com> wrote:
> Donald McLean wrote:
>> With clobs and blobs this error is almost always caused by autocommit.
>> When autocommit is on, the select is committed before you get a chance
>> to retrieve the value of the clob or blob column. Obviously then, if
>> you are going to select a clob or blob column, you have to turn it off
>> first.
>> Sometimes this is inconvenient, but can't be avoided.
> We don't have autocommit turned on either.  Or rather, we explicitly turn it
> off after getting the connection.

View raw message