DB2 CharConversionException

SaliasX — Mon, 12 Mar 2018 08:33:39 GMT

Hi,

Im trying to load data from a db2 to the same db2 1:1 as a simple test.

The following error appears after some time:

Exception in component tDB2Input_1 (talend_job)
com.ibm.db2.jcc.am.SqlException: [jcc][t4][1065][12306][4.22.29] Excpetion java.io.CharConversionException - ERRORCODE=-4220, SQLSTATE=null
   at com.ibm.db2.jcc.am.ld.a(ld.java:794)
   at com.ibm.db2.jcc.am.ld.a(ld.java:66)
   at com.ibm.db2.jcc.am.ld.a(ld.java:125)
   at com.ibm.db2.jcc.am.mc.a(mc.java:2963)
   at com.ibm.db2.jcc.am.mc.p(mc.java:575)
   at com.ibm.db2.jcc.am.mc.P(mc.java:1656)
   at com.ibm.db2.jcc.am.ResultSet.getStringX(ResultSet.java:1214)
   at com.ibm.db2.jcc.am.ResultSet.getString(ResultSet.java:1183)
   at routines.system.JDBCUtil.getString(JDBCUtil.java:21)
   at cmm_talend_poc.talend_job_0_1.talend_job.tDB2Input_1Process(talend_job.java:3278)
   at cmm_talend_poc.talend_job_0_1.talend_job.tDB2Connection_1Process(talend_job.java:560)
   at cmm_talend_poc.talend_job_0_1.talend_job.runJobInTOS(talend_job.java:5376)
   at cmm_talend_poc.talend_job_0_1.talend_job.main(talend_job.java:5201)

   Caused by: java.nio.charset.UnmappableCharacterException: Input length = 1
   at java.nio.charset.CoderResult.throwException(CoderResult.java:282)
   at com.ibm.db2.jcc.am.r.a(r.java:52)
   at com.ibm.db2.jcc.am.mc.a(mc.java:2952)
   ... 9 more

The affected column contains special german characters (ä ß) as it is a comment column.

After some research i tried to use the following parameter "db2.jcc.charsetDecoderEncoder=3;" as it seem to be a DB2 driver problem - nothing changed.

Appropriate db2jcc4.jar installed (11.1.1 DB2)

Has anyone any ideas?

Greetings

Simon

Re: DB2 CharConversionException

Anonymous — Mon, 12 Mar 2018 14:05:20 GMT

Hi Simon,

I think the parameter needs to be added as JVM parameter under Job - Advanced Settings - Job Run VM Arguments:

-Ddb2.jcc.charsetDecoderEncoder=3

Regards

Mathias

topic Re: DB2 CharConversionException in Talend Studio

DB2 CharConversionException

Re: DB2 CharConversionException