Seven Stars RAJ
Seven Stars

java.io.CharConversionException error

Hi talend folks,

 

I am moving data from db2 to PostgreSQL. My db2 input query like select * from table name. when I ran the job getting java.io.CharConversionException error.

I tried below link also. still am facing same issue

https://community.talend.com/t5/Design-and-Development/DB2-CharConversionException/m-p/53308#M17929

kindly share your information for below error. 

 

[statistics] connecting to socket on port 3484
[statistics] connected
Exception in component tDB2Input_1 (demo_job)
com.ibm.db2.jcc.am.SqlException: [jcc][t4][1065][12306][4.11.77] Caught java.io.CharConversionException. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null
at com.ibm.db2.jcc.am.gd.a(gd.java:660)
at com.ibm.db2.jcc.am.gd.a(gd.java:60)
at com.ibm.db2.jcc.am.gd.a(gd.java:112)
at com.ibm.db2.jcc.am.jc.a(jc.java:2027)
at com.ibm.db2.jcc.am.jc.n(jc.java:491)
at com.ibm.db2.jcc.am.jc.K(jc.java:1402)
at com.ibm.db2.jcc.am.ym.e(ym.java:1147)
at com.ibm.db2.jcc.am.ym.getString(ym.java:1122)
at routines.system.JDBCUtil.getString(JDBCUtil.java:21)
at db2_to_postgres.demo_job_0_1.demo_job.tDB2Input_1Process(demo_job.java:1111)
at db2_to_postgres.demo_job_0_1.demo_job.runJobInTOS(demo_job.java:1867)
at db2_to_postgres.demo_job_0_1.demo_job.main(demo_job.java:1693)
Caused by: java.nio.charset.MalformedInputException: Input length = 1
at java.nio.charset.CoderResult.throwException(CoderResult.java:281)
[FATAL]: db2_to_postgres.demo_job_0_1.demo_job - tDB2Input_1 [jcc][t4][1065][12306][4.11.77] Caught java.io.CharConversionException. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null
com.ibm.db2.jcc.am.SqlException: [jcc][t4][1065][12306][4.11.77] Caught java.io.CharConversionException. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null
at com.ibm.db2.jcc.am.gd.a(gd.java:660)
at com.ibm.db2.jcc.am.gd.a(gd.java:60)
at com.ibm.db2.jcc.am.gd.a(gd.java:112)
at com.ibm.db2.jcc.am.jc.a(jc.java:2027)
at com.ibm.db2.jcc.am.jc.n(jc.java:491)
at com.ibm.db2.jcc.am.jc.K(jc.java:1402)
at com.ibm.db2.jcc.am.ym.e(ym.java:1147)
at com.ibm.db2.jcc.am.ym.getString(ym.java:1122)
at routines.system.JDBCUtil.getString(JDBCUtil.java:21)
at db2_to_postgres.demo_job_0_1.demo_job.tDB2Input_1Process(demo_job.java:1111)
at db2_to_postgres.demo_job_0_1.demo_job.runJobInTOS(demo_job.java:1867)
at db2_to_postgres.demo_job_0_1.demo_job.main(demo_job.java:1693)
at com.ibm.db2.jcc.am.t.a(t.java:44)
at com.ibm.db2.jcc.am.jc.a(jc.java:2019)
... 8 more
Caused by: java.nio.charset.MalformedInputException: Input length = 1
at java.nio.charset.CoderResult.throwException(CoderResult.java:281)
at com.ibm.db2.jcc.am.t.a(t.java:44)
at com.ibm.db2.jcc.am.jc.a(jc.java:2019)
... 8 more
[statistics] disconnected
Job demo_job ended at 06:15 11/04/2018. [exit code=1]

Thanks
RAJ
1 REPLY
Moderator

Re: java.io.CharConversionException error

Hello,

What's your DB2 version you are using? Could you please refer to this online document about:TalendHelpCenterSmiley Frustratedupported systems, databases and business applications by Talend components for V 7.0?

DB2 11.x, 10.5 and 10.1 are list on the supported databases table.

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.