Archives of the TeradataForum

Message Posted: Wed, 19 Oct 2005 @ 17:04:38 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hello All,

We have a need to transfer data from Oracle database with multi-byte characters (e.g Russian) into Teradata table.

In our java code, we are getting the following exception when try to set multi-byte characters in the callableStatement and execute it:

com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata DBMS] : The string contains an untranslatable character.

     --------------------------------------------------------------------

     code excerpt

     import java.sql.*;
     // Create the callableStatement to invoke the Teradata Macro. The
     question mark stands for the input parameter for the macro.
     CallableStatement cst = teraConn.prepareCall("{exec
     e_fpu_update_macro.sepr68_fpu_cntrct(?)}");
     //  get the sales person name from Contrac object. The value here
     contains Russian characters (double-byte): ??????. And the str value in
     reader showed the correct value in runtime when running in debugger.

     StringReader reader = new StringReader(contract.getSalesPerson());
     // get the number of characters in the string, which is 6 in this case.
     we also tried to use getBytes("UTF-8") to get the number of bytes, which
     is 12. We got the same exception with both methods.
     int len = contract.getSalesPersonCode().getBytes().length;
     cst.setCharacterStream(1, reader, len);
     cst.execute();

Notes:

If the salePserson field value contains all single-byte characters (eg French), we would be fine. If it contains any multi-byte characters, we would get the above exception.

We use Teradata Driver for JDBC version 3.1.0.8. We have two jar files included in our project: tdgssjava.jar and terajdbc4.jar. Teradata version is V2R5.1

Could anyone explain why we would be getting these errors?

Thanks,

Vivek Parikh

	<Prev	Next>		<<First	<Prev	Next>	Last>>