Skip to Content.
Sympa Menu

freetds - Re: LONGVARCHAR in freetds JDBC max size is 4096?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Bob Kline <bkline AT rksystems.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: LONGVARCHAR in freetds JDBC max size is 4096?
  • Date: Tue, 8 May 2001 13:26:49 -0400 (EDT)


On Tue, 8 May 2001, Spectron Caribe, Inc. wrote:

> Well, I checked the source and I found this function in
> Connection_base.java:
>
> protected String sqlStatementToInitialize()
> {
> return serverType==Tds.SYBASE ? "set quoted_identifier on set textsize
> 50000" : "";
> }
>
> It seems to me that it is unconditionally overriding the default
> when it is a connection to a Sybase server. If there is a worry
> about system resources I think it should be only set as a parameter
> in the URL like:
>
> jdbc:freetds:sqlserver://SERVERNAME/DATABASENAME?textsize=50000
>
> I don't think things would be broken by adding the parameter to the
> connection URL. The driver would call the 'set textsize' ONLY IF the
> parameter exists. If it doesn't it will be the same driver we have
> now. It seems simple enough.
>
> Faw
>
> PS: Why is this fixed only on a Sybase connection if MS SQL has the
> same problem?

I have no idea. Perhaps Craig can shed some light on this distinction.

--
Bob Kline
mailto:bkline AT rksystems.com
http://www.rksystems.com





Archive powered by MHonArc 2.6.24.

Top of Page