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
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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ORA-01406: fetched column value was truncated