UltraliteJ - Length of string returned by ResultSet.getString method

[Former Member]

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

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

[former_SQLA_member1694884]

Are you using UltraLiteJ for Android or BlackBerry?

[Former Member]

For Android

[jeff_albion]

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.

[Former Member]

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