Getting error Unsupported ccsid, encoding, or locale: "Cp037", we are using Websphere 8.5 with Java SDK8 and DB2 10.5.How to resolve it?
Getting error : Unsupported ccsid, encoding, or locale: "Cp037". ERRORCODE=-4220, SQLSTATE=22021; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException
Tried changing the encoding to UTF-8 in jvm properties in Webspehere console but did not work. Updated DB2 from Db2 v9.9 to DB2 v10.5 but still getting same error. We have pointed java for our workspace to Websphere's java SDK 8.
The following DB2 APAR addresses the SQLException "Unsupported ccsid, encoding, or locale" error...
IT07334: JCC DRIVER THROWS AN EXCEPTION: UNSUPPORTED CCSID, ENCODING, OR LOCALE: "CP1047". ERRORCODE=-4220, SQLSTATE=22021
http://www-01.ibm.com/support/docview.wss?uid=swg1IT07334
It is recommended to upgrade the DB2 driver to 10.1 FP 6 or higher. Here is a document which contains links to various DB2 driver versions...
DB2 JDBC Driver Versions and Downloads
https://www-304.ibm.com/support/docview.wss?uid=swg21363866