The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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.6k11843

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.7k171174
accept rate: 24%

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:

×46
×18

question asked: 03 Dec '12, 10:19

question was seen: 1,315 times

last updated: 05 Dec '12, 04:23