Blob retrieval truncation?

Article View: borland.public.jbuilder.database

Article #288

Back to borland.public.jbuilder.database Previous Next

#288

From: R_McConkey
Date: Thu, 09 Feb 2006 14:32

28 lines
2146 bytes

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 retreive 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.

Technical Details

Message-ID: <1139495521.710936.114890@g43g2000cwa.googlegroups.com>

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

Show Full Headers

Complete Article Headers

X-Google-Thread: 1073da,a28d25e90f96a71f,start
X-Google-Attributes: gid1073da,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!g43g2000cwa.googlegroups.com!not-for-mail
From: "R_McConkey" <r_mcconkey@hotmail.com>
Newsgroups: borland.public.jbuilder.database
Subject: Blob retrieval truncation?
Date: 9 Feb 2006 06:32:01 -0800
Organization: http://groups.google.com
Lines: 29
Message-ID: <1139495521.710936.114890@g43g2000cwa.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 1139495526 25523 127.0.0.1 (9 Feb 2006 14:32:06 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 9 Feb 2006 14:32:06 +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: g43g2000cwa.googlegroups.com; posting-host=12.161.103.194;
   posting-account=vwIE2QwAAADGimoDpszFxiH_rxuQicQK