Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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

asked 16 Nov '11, 09:04

Lou's gravatar image

Lou
1111
accept rate: 0%

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?

(17 Nov '11, 20:39) Derli Marcochi
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×78
×39

question asked: 16 Nov '11, 09:04

question was seen: 2,093 times

last updated: 17 Nov '11, 20:48