db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mikael Sundberg" <Mikael.Sundb...@artificial-solutions.com>
Subject how to get data out from Clob?
Date Tue, 25 Nov 2008 11:56:34 GMT
We are having some trouble with retrieving data from big Clob fields.
The data is about 40-50MB and it takes forever to retrieve it.  

Tried a lot of different methods, getString, getClob, getAsciiStream.
They all take forever (hours).

When checking whats running in derby we find

CALL SYSIBM.CLOBGETSUBSTRING(?, ?, ?)

A lot of times. 

How should I retrieve large CLob fields fastest?

 


Mime
View raw message