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 trying to read a column from my table using the getString method ->

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 -

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

edited 04 Dec '12, 15:39

Graham%20Hurst's gravatar image

Graham Hurst

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
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


(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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 03 Dec '12, 10:19

question was seen: 3,181 times

last updated: 05 Dec '12, 04:23