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?