db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Øystein Grøvlen <Oystein.Grov...@Sun.COM>
Subject Re: Iterating through large result set in network mode causes OutOfMemoryException
Date Mon, 11 Feb 2008 16:19:25 GMT
Briggs wrote:
> Well, unfortunately, freeing the Blob didn't work, the app still runs
> out of memory.

The app?  Your first posting indicated that the server ran out of memory.

> 
> Also, the occasional commit is also causing a problem.  I end up
> eventually getting this:
> 
> java.sql.SQLException: The data in this BLOB or CLOB is no longer
> available.  The BLOB/CLOB's transaction may be committed, or its
> connection is closed.

A Blob/Clob object is not valid after the transaction it was created in 
has committed.

-- 
Øystein

Mime
View raw message