FreeTDS Development Group

["Spectron Caribe, Inc." <spectron AT coqui.net>]

Here is a fix for the MS-SQL textsize bug. The only changes are in
Connection_base.java:

1. Added new variable to the class, textsize.
2. Changes to Connection_base(Properties props_) and
sqlStatementToInitialize()

Now you can set the size of the text in the URL, e.g.

jdbc:freetds:sqlserver://server/database;textsize=10000

if it is not in the url it will use the default of 50000 for both Sybase and
MS-SQL.

Faw

----- Original Message -----
From: "Greg Chakmakian" <gregchak AT mac.com>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Sent: Monday, September 24, 2001 9:55 PM
Subject: [freetds] Re: Text field problem


> I've been away from this discussion for a while.  I've read the
> documentation on setting the textsize to around 5000 or something like
> that.  My question is where exactly do I put this line of code?  Do I
> need to compile the driver, is there something that I can set when I
> initialize the driver?
>
> thanks for  your help,
>
> greg
>
>
>
> On Monday, September 10, 2001, at 11:49 PM, James K. Lowden wrote:
>
> > Bob Kline wrote:
> >>
> >> 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?
> >
> > Harrumph!  Well, yes, ok, maybe, sure.
> >
> > I did try to address it in the User Guide, under "Text Fields".  And
> > MS's documentation states that 4096 is the default TEXTSIZE value.
> >
> > http://www.freetds.org/userguide/x556.htm#AEN558
> >
> > But maybe you're right, Bob.  Maybe in the FAQ under "Problems Running"
> > there should be a subsection (called "RTFM"?) explaining a few things
> > like this that people bump into from time to time.  It is one of the
> > goofier parts of T-SQL.
> >
> > --jkl
> >
> > ---
> > You are currently subscribed to freetds as: [gregchak AT mac.com]
> > To unsubscribe, forward this message to leave-
> > freetds-136070S AT franklin.oit.unc.edu
>
> ---
> You are currently subscribed to freetds as: [spectron AT caribe.net]
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>

Attachment: Connection_base.java
Description: Binary data