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!

java.sql.ResultSet.getString() truncates after 255 characters.

843859Feb 19 2007 — edited Feb 19 2007

I have a field in a (Sybase 12.52) database that is 2042 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 it Truncates Characters beyond 255 characters. Am using Sybase Driver JConnect 5.0 Version.
Code: String str = java.sql.resultSet.getString("Column Name").
Data Type of Coulmn Name is varchar(2042)

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 19 2007

Added on Feb 19 2007

#java-database-connectivity-jdbc

1 comment

380 views