blob 16K problem?

Thread View: borland.public.interbase.interclient

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by R_McConkey Wed, 15 Feb 2006 14:20

#14

Author: R_McConkey
Date: Wed, 15 Feb 2006 14:20

36 lines
2229 bytes

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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads