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.

Hello,

I'm trying to read a column from my table using the getString method -> http://infocenter.sybase.com/help/index.jsp?docset=/com.sybase.help.sqlanywhere.12.0.1/sqlanywhere_en12/help_top_index.htm&docSetID=1744

This method works fine if the length of the data is less than 30000 bytes.

The problem comes when I try to read one register that has 74000 bytes in one single column. The following exception is thrown: Invalid Parameter - http://dcx.sybase.com/1200/en/saerrors/errm735.html

There is any restriction regarding the maximum number of characters that getString return?

PS: I'm capable to read the same column using the method getBlobInputStream

asked 03 Dec '12, 10:19

Gabriel%20Francischini's gravatar image

Gabriel Fran...
31223
accept rate: 0%

edited 04 Dec '12, 15:39

Graham%20Hurst's gravatar image

Graham Hurst
2.7k11843

Are you using UltraLiteJ for Android or BlackBerry?

(03 Dec '12, 12:36) Bill Somers

For Android

(05 Dec '12, 04:23) Gabriel Fran...

What is the actual data type of the column you are trying to retrieve in UltraLiteJ? CHAR / VARCHAR fields (which are returnable from getString()) only go up to 32,767 bytes worth of characters.

Is this data really stored in a LONG VARCHAR field? If so, you will need to use getClobReader() to return a Reader when accessing this data.

permanent link

answered 03 Dec '12, 12:38

Jeff%20Albion's gravatar image

Jeff Albion
10.8k171175
accept rate: 25%

edited 03 Dec '12, 12:39

The column data type is long varchar.

I was retrieving it with getString().

I will change my code to use the getClobReader and see if everything works fine

Thanks

(04 Dec '12, 07:34) Gabriel Fran...
Your answer
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:

×69
×22

question asked: 03 Dec '12, 10:19

question was seen: 3,181 times

last updated: 05 Dec '12, 04:23