db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Noll <dan...@nuix.com>
Subject Re: cannot invoke other java.sql.Clob
Date Tue, 22 Jul 2008 03:51:30 GMT
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.


Daniel Noll

View raw message