blob 16K problem?

Article View: borland.public.interbase.interclient

Article #14

Back to borland.public.interbase.interclient Previous Next

#14

From: 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

Technical Details

Message-ID: <1140013208.364944.307110@g47g2000cwa.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!g47g2000cwa.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: f54da,15fe428e11914eb,start
X-Google-Attributes: gidf54da,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!g47g2000cwa.googlegroups.com!not-for-mail
From: "R_McConkey" <r_mcconkey@hotmail.com>
Newsgroups: borland.public.interbase.interclient
Subject: blob 16K problem?
Date: 15 Feb 2006 06:20:08 -0800
Organization: http://groups.google.com
Lines: 37
Message-ID: <1140013208.364944.307110@g47g2000cwa.googlegroups.com>
NNTP-Posting-Host: 12.161.103.194
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1140013213 3642 127.0.0.1 (15 Feb 2006 14:20:13 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 15 Feb 2006 14:20:13 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 CORA-ISA
Complaints-To: groups-abuse@google.com
Injection-Info: g47g2000cwa.googlegroups.com; posting-host=12.161.103.194;
   posting-account=vwIE2QwAAADGimoDpszFxiH_rxuQicQK