FreeTDS Development Group

["Eric Mountain" <e.mountain AT dev.amadeus.net>]

Alternatively, apply the following patch and recompile your driver

[NB I have multiple "case" entries and a default 'return ""' because I have
started modifying the driver so it can talk to UniAccess on Unisys 2200
mainframes, so I have actually defined Tds.UACS as well. Not that anyone
would be interested. ;-) ]

:E

----------------------------------------------------------------------------
----------------------------
diff --recursive -c -x class freetds_jdbc/Connection.java
freetds_jdbc_exp/Connection.java
*** freetds_jdbc/Connection.java Thu Feb 18 23:06:58 1999
--- freetds_jdbc_exp/Connection.java Fri Jun 18 10:36:32 1999
***************
*** 181,187 ****

     protected String sqlStatementToInitialize()
     {
!       return serverType==Tds.SYBASE ? "set quoted_identifier on set
textsize 50000" : "";
     }

     protected String sqlStatementToSetTransactionIsolationLevel()
--- 181,195 ----

     protected String sqlStatementToInitialize()
     {
!       switch (serverType) {
!       case Tds.SYBASE:
!         return "set quoted_identifier on set textsize 2147483647";
!       case Tds.SQLSERVER:
!         return "set textsize 2147483647";
!       }
!
!       return "";
!       //return serverType==Tds.SYBASE ? "set quoted_identifier on set
textsize 50000" : "";
     }

     protected String sqlStatementToSetTransactionIsolationLevel()
----------------------------------------------------------------------------
----------------------------

-----Original Message-----
From: Rob Lucier <rlucier AT pacificcolor.com>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Date: Friday, 18 June, 1999 05:33
Subject: [freetds] Re: 4096 byte limit on IMAGE?


>OK, I found out how to fix this, but it seems a little sloppy. Is there a
>way to set this value at the initial driver or connection construction?
>
>Workaround:
>for each new statement, set the maximum text(also image) size
>         st.execute("set TEXTSIZE 500000 ");
>
>where 500000 is a suitably large number for your data.
>
>---
>You are currently subscribed to freetds as: eric AT minouche.demon.co.uk
>To unsubscribe, forward this message to
$subst('Email.Unsub')
>