Hi
I am using Hibernate 3.2, Oracle 10g XE and
latest version (10.2.0.2) of thin jdbc driver (ojdbc14.jar). I would like to read from a CLOB using a stream, but it seems impossible. I can read from a CLOB using a Reader, it reads all 18kb of data I have stored there. But all streams return -1, if I try to read them and available() returns 0.
Code:
Report report = (Report) session.load(Report.class,reportName);
Clob reportXml = report.getReport();
Blob reportCompiled = report.getJasper();
SerializableClob sclob=(SerializableClob) reportXml;
CLOB oclob = (CLOB) sclob.getWrappedClob();
try
{
log.warn(sclob.getAsciiStream().available()); // 0
log.warn(oclob.getAsciiStream().available()); // 0
log.warn(oclob.getAsciiStream(0).available()); // 0
log.warn(oclob.asciiStreamValue().available()); // 0
log.warn(oclob.binaryStreamValue().available()); // 0
log.warn(oclob.getStream().available()); // 86
} catch(Exception ex) {}
Login
FAQ
Search