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,128 times

last updated: 05 Dec '12, 04:23