Text field problem
Spectron Caribe, Inc.
spectron at caribe.net
Mon Sep 10 15:38:09 EDT 2001
That's not a solution. The source should be fixed instead of going around
it. Go and check the source code, in Connection_base.java there is a
function called sqlStatementInitialize() that looks like this (this is from
memory, so it might be wrong):
protected String sqlStatementToInitialize(){
if(serverType==Tds.SYBASE){
return("set quoted_identifier on set textsize 50000");
}else{
return("");
}
}
Just change it to:
protected String sqlStatementToInitialize(){
return("set quoted_identifier on set textsize 50000");
}
If you want something better let the user set the text size in a parameter
in the connection url (that's what I did) if there is no parameter, use the
50000 ad default.
Faw
----- Original Message -----
From: "Bob Kline" <bkline at rksystems.com>
To: "TDS Development Group" <freetds at franklin.oit.unc.edu>
Sent: Monday, September 10, 2001 3:28 PM
Subject: [freetds] Re: Text field problem
> On Mon, 10 Sep 2001, Greg Chakmakian wrote:
>
> > I did some searching through the archives and found some info, but
> > no specifics on this problem I'm having. What happens is that
> > whenever I try to get data out of a text field in a database then I
> > only get back around 4 KB. I am using IIS 5 with Tomcat and am
> > hitting a sql server 7 database. It brings back the same amount
> > every time: ~4096 bytes. Has anyone else had problems along these
> > lines? Any help would be greatly appreciated.
>
> Please look again. This question comes up regularly. Try, for example,
> searching on "SET TEXTSIZE".
>
> Any chance this could be added to the FAQ document?
>
> --
> Bob Kline
> mailto:bkline at rksystems.com
> http://www.rksystems.com
>
>
> ---
> You are currently subscribed to freetds as: [spectron at caribe.net]
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>
More information about the FreeTDS
mailing list