Skip to Content.
Sympa Menu

freetds - Re: Text field problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Greg Chakmakian" <gregchak AT mac.com>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Text field problem
  • Date: Mon, 10 Sep 2001 16:47:30 -0400


What's the syntax for adding that in the connection URL?



-----Original Message-----
From: bounce-freetds-136070 AT franklin.oit.unc.edu
[mailto:bounce-freetds-136070 AT franklin.oit.unc.edu] On Behalf Of
Spectron Caribe, Inc.
Sent: Monday, September 10, 2001 3:38 PM
To: TDS Development Group
Subject: [freetds] Re: Text field problem

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


---
You are currently subscribed to freetds as: [gregchak AT mac.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')





Archive powered by MHonArc 2.6.24.

Top of Page