Required character converter is not available. ERRORCODE=-4220, SQLSTATE=null

Tags: , , ,



The application I migrate to Java8 was running on Java7. After the migration i had to update the db2jcc.jar to latest version and yet I have the error below:

Required character converter is not available. ERRORCODE=-4220, SQLSTATE=null

I have checked and tried the topic Getting error code 4220 with null SQL State

My DB version : DB2 v10.5.0.11
The db2 Jar I use : db2jcc-9.5.jar

Has anyone faced this before?

Regards

Answer

Your question included

My DB version : DB2 v10.5.0.11
The db2 Jar I use : db2jcc-9.5.jar

The exception text included:

     [Camel Thread #2 - JmsConsumer[null]] WARN **** - SQLException: com.ibm.db2.jcc.a.SqlException:

 [jcc][t4][10199][10462][3.52.95] Required character converter is not available. ERRORCODE=-4220, SQLSTATE=null 

Notice the db2 jdbc driver version, [3.52.95] included in the exception text. This is an old driver that comes with db2 version 9.5 fixpack2a, long out of support.

You need to be using a recent type 4 jdbc driver for Db2, and the version of the db2 jdbc driver will appear in the exception text as a three part number with a dot separating the parts.

For Db2-LUW v10.5 the currently available version of the db2 type 4 jdbc driver is 4.19.80 although you can use higher versions.

You can download the recent jdbc driver versions from this IBM website, you will need to register with IBM first, although the download is free.



Source: stackoverflow