Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

blob 16K problem?

1 view
Skip to first unread message

R_McConkey

unread,
Feb 15, 2006, 9:20:08 AM2/15/06
to
Cross posted from:borland.public.jbuilder.database

JBuilder X. Jdk1.4 Interbase 7.5.0.26 Interclient driver

I have a blob file in a table defined as:

"EXSUBFILE" BLOB SUB_TYPE TEXT SEGMENT SIZE 1024,


I can place whatever I want in the blob file, no problems.
I have a 30K (or so) bunch of text in there. IBConsole sees it, I can
open it in IBConsole, cut and paste it all I want. So it is in the
database whole and complete.


When I try to retrieve it, the fun starts. I get the first 16K of text.

System.out.println(rs.getString("EXSUBFILE")); // this gives the
first 16K of text


submissionFile.setXmissionFile( new StringBuffer(
resultSetXFile.getString("EXSUBFILE"))); // this also gives the first
16K


trying a System.out.println(rs.getBlob("EXSUBFILE")); returns:
interbase.interclient.DriverNotCapableException: [interclient]
Unsupported feature: Using a JDBC method which is not yet supported.


How can I return the full and complete text from this blob?


Any suggestions or direction regarding this problem would be most
helpful and thanks in advance

0 new messages