Home arrow static arrow Java Programming [Archive] - Is there a constaint on number of characters returned in resultset?
Warning: Creating default object from empty value in /www/htdocs/w008deb8/wiki/components/com_staticxt/staticxt.php on line 51
Java Programming [Archive] - Is there a constaint on number of characters returned in resultset?
This topic has 1 reply on 1 page.

Posts:26
Registered: 1/16/04
Is there a constaint on number of characters returned in resultset?   
Aug 10, 2004 8:01 AM



 
Hello,

I am trying to retrieve a field from database which is 5000 - 6000 character long using the rs.getString() method. (Data stored is XML). When the number of characters exceed 4096, the getString() returns only 4096 characters. The rest is ignored even though data is available. After getting the XML, I parse it again.

This standalone program fails at this point since the retrieved data (XML) is not complete.

Any ideas?

Thanks,
Des
 

Posts:31,095
Registered: 4/30/99
Re: Is there a constaint on number of characters returned in resultset?   
Aug 10, 2004 8:07 AM (reply 1 of 1)



 
Any ideas?

Yeah. One idea would be to post JDBC questions in the JDBC forum.

I use the getAsciiStream() method of ResultSet to give me an InputStream from which I can read the column.

PC²
 
This topic has 1 reply on 1 page.