freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
Re: LONGVARCHAR in freetds JDBC max size is 4096?
, (continued)
- Re: LONGVARCHAR in freetds JDBC max size is 4096?, Bob Kline, 05/04/2001
- Re: LONGVARCHAR in freetds JDBC max size is 4096?, Brian Bruns, 05/04/2001
- Re: LONGVARCHAR in freetds JDBC max size is 4096?, Spectron Caribe, Inc., 05/07/2001
- Re: LONGVARCHAR in freetds JDBC max size is 4096?, Spectron Caribe, Inc., 05/07/2001
- Re: LONGVARCHAR in freetds JDBC max size is 4096?, Spectron Caribe, Inc., 05/07/2001
- Re: LONGVARCHAR in freetds JDBC max size is 4096?, Lowden, James K, 05/07/2001
- Re: LONGVARCHAR in freetds JDBC max size is 4096?, Spectron Caribe, Inc., 05/07/2001
- Re: LONGVARCHAR in freetds JDBC max size is 4096?, Lowden, James K, 05/07/2001
- Re: LONGVARCHAR in freetds JDBC max size is 4096?, Bob Kline, 05/08/2001
- Re: LONGVARCHAR in freetds JDBC max size is 4096?, Spectron Caribe, Inc., 05/08/2001
- Re: LONGVARCHAR in freetds JDBC max size is 4096?, Bob Kline, 05/08/2001
- Re: LONGVARCHAR in freetds JDBC max size is 4096?, Spectron Caribe, Inc., 05/08/2001
Archive powered by MHonArc 2.6.24.