Is there a constaint on number of characters returned in resultset?

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

[484 byte] By [dessri] at [2007-9-30 15:04:03]