aspose file tools*
The moose likes JDBC and the fly likes ORA-01406: fetched column value was truncated Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ORA-01406: fetched column value was truncated" Watch "ORA-01406: fetched column value was truncated" New topic
Author

ORA-01406: fetched column value was truncated

Manoj Kumkumath
Ranch Hand

Joined: Dec 01, 2005
Posts: 71
Hi All,

I am trying to fetch all rows in a table(total 105 rows) from Oracle 10g Database. When I am using a Type 4 driver, everything works fine. But when I am using a Type 2driver, I am getting the following exception.


Please let me know if anyone of you know the cause and solution for this.
Manoj Kumkumath
Ranch Hand

Joined: Dec 01, 2005
Posts: 71
I could find a fix to solve this problem by just adding a space at the end of sql query.

But still wondering what was the cause?
[ January 31, 2006: Message edited by: Manoj Kumkumath ]
 
wood burning stoves
 
subject: ORA-01406: fetched column value was truncated