ORA-01406: fetched column value was truncated

[Manoj Kumkumath]

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.

  
Server MKG > Tuesday, January 31, 2006 at 13:51:29.014 Thread-3/1.4.2_06/Sun Microsystems Inc./Windows XP/5.1/MKG/MKG/1138695689014 About to do Execute against Statement: select name, return_class_name, contained_class_names, query_request_adapter_name, dml_request_adapter_name, target_db_object, target_db_object_type, target_db_object_properties, description, collectionsaverstrategy_class, domainobjectfactory_class, query_server_name_space, query_server_name, target_row_format,order_by_properties, target_db_object_parms from POLLUX.TARGET_SET_ROOT  - Server Thread: Thread-3
Server MKG  ERROR> Tuesday, January 31, 2006 at 13:51:29.076 Thread-3/1.4.2_06/Sun Microsystems Inc./Windows XP/5.1/MKG/MKG/1138695689076 JDBC SQLException: java.sql.SQLException: ORA-01406: fetched column value was truncated
 

Please let me know if anyone of you know the cause and solution for this.

[Manoj Kumkumath]

I could find a fix to solve this problem by just adding a space at the end of sql query.

 
 "select name, return_class_name, contained_class_names, "
+ "query_request_adapter_name, dml_request_adapter_name, "
+ "target_db_object, target_db_object_type, "
+ "target_db_object_properties, description, "
+ "collectionsaverstrategy_class, domainobjectfactory_class, "
+ "query_server_name_space, query_server_name, target_row_format,"
+ "order_by_properties, target_db_object_parms from "
+ props.getProperty("TargetSetRegistrySchema") + "."
+ props.getProperty("TargetSetRegistryTableName") + " ";

But still wondering what was the cause?
[ January 31, 2006: Message edited by: Manoj Kumkumath ]