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
