LONGVARCHAR in freetds JDBC max size is 4096?
Bob Kline
bkline at rksystems.com
Tue May 8 08:11:29 EDT 2001
On Mon, 7 May 2001, Spectron Caribe, Inc. wrote:
> I'm using all the defaults my connection url is:
>
> jdbc:freetds:sqlserver://SERVERNAME/DATABASENAME
As pointed out by other messages in this thread, the problem you are
experiencing is caused by a default setting in SQL Server. It would
indeed be nice, as you suggest, to be able to write portable client code
which ignores this problem. Solving the problem by having the driver
unconditionally override the default buffer size may run the risk,
however, of breaking some existing applications by exhausting system
resources. It may be preferable to have a property set in the
environment which will trigger the SET statement, allowing the code to
be written portably with as little risk as possible for existing
applications.
--
Bob Kline
mailto:bkline at rksystems.com
http://www.rksystems.com
More information about the FreeTDS
mailing list