Programing/Java JSP

DB2 ERRORCODE=-4220, SQLSTATE=null

시처럼 음악처럼 2014. 3. 5. 21:55
http://stackoverflow.com/questions/16910791/getting-error-code-4220-with-null-sql-state 

  com.ibm.db2.jcc.am.SqlException: [jcc][t4][1065][12306][3.65.77] Caught java.io.CharConversionException.  See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null

I fixed the issue by using latest version of jar and by setting below system property .

System.setProperty("db2.jcc.charsetDecoderEncoder", "3");

Also another way is disable unicode encoding for char and varchar type in DB2 SP which also worked for me ..


또는 아래와 같이 jvm 옵션 주고 실행

This link discusses the problem, https://www-304.ibm.com/support/docview.wss?uid=swg21412846 but the way we were able to work around it locally was to use the java command line argument "-Ddb2.jcc.charsetDecoderEncoder=3" which maps the funky chars to null on the way out of the DB.