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 03:45:02 GMT
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.

Donald

Mime
View raw message