java getBytes with LONG BINARY returns truncated data

[Former Member]

I'm using an older version of ASA (9) with jconn 5.5 and running into an issue with some pretty basic java code:

byte[] bytes = rs.getBytes( 1 );

Column 1 is declared as a LONG BINARY. The issue is, sporadically, the data returned is truncated. It happens with all data sizes, but I see it most when data is larger than 8Mb. I tried getting it as a binary stream but that has the same issue. I'm thinking it is a driver issue since the data was retrieved OK using xp_write_file from isql.

Environment:

jconn 5.5

windows 2003 32bit

jdk 1.5

[former_SQLA_member1694870]

In order to check whether this is a driver issue or not could you try using a separate box to upgrade one component at time? Maybe upgrading to SA12 and / or recompiling your code under the latest jdk1.6 could help?