Skip to Content.
Sympa Menu

freetds - Re: Text field problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Spectron Caribe, Inc." <spectron AT caribe.net>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Text field problem
  • Date: Mon, 10 Sep 2001 15:38:09 -0400


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')
>





Archive powered by MHonArc 2.6.24.

Top of Page