Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Truncated Objects in java.sql.ResultSet

843859Aug 31 2006 — edited Sep 5 2006

Hi,

I have a field in a database that is 2048 characters and when I run a sql query on a command line it shows all the text inside this field. However, when I run a sql query from java and obtain a java.sql.ResultSet I find that when I do:

Object myObject = resultSet.getObject(i);

...the contents of myObject has been truncated to 256 characters long rather than the 2048 it is in the database. Can anybody tell me a possible reason for this please?

Thanks in advance for any help you can offer! (apologies if this post is in the wrong place :-) )

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 3 2006

Added on Aug 31 2006

#java-database-connectivity-jdbc

7 comments

245 views