FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

Rob Lucier writes:
 > 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.

The default for Sybase is normally 32k for TEXT/IMAGE columns. I don't 
know if jdbc warrants a smaller default.

Michael
-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler AT peppler.org    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com
Sybase on Linux mailing list: ase-linux-list AT isug.com