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


-- 
Daniel Noll

Mime
View raw message