Limit on LONGVARBINARY in MS JDBC driver?

I am having some unexpected behavior in attempting to retrieve binary data
from a SQL 2000 server for use in my Java application. I am pulling the
data (which is stored as an 'image' in the table) through via a stored
procedure call, but somewhere between leaving the database and populating a
byte array or binary input stream in my application the data is being
truncated to 500,000 bytes.

I have verified that the data is intact upon leaving the database by using
the same stored procedure in a non-Java environment and seeing that it
arrived complete (which it did). It seems that the JDBC driver converts the
image data type to a LONGVARBINARY type prior to being queried by the
application via the ResulSet.get... methods. Has anyone encountered
anything like this before?

By the way, I am using JDK v. 1.5.0_04 and MS JDBC Driver service pack 3.
Any help would be greatly appreciated as I'm pulling my hair out here.

- Charles Krebs
Engineering Dept.
Petz Enterprisis, Inc.
(209)835-2720 x2104
http://www.taxbrain.com
http://www.petzent.com


.

Loading