ERRORCODE=-4220 – db2.jcc.charsetDecoderEncoder=3
Schon erlebt:
2020-03-23 09:17:15 - U02012001 Verbindung zu 'MYSERVER:50000/mydb' mit User 'myaccnt' erfolgreich hergestellt. 2020-03-23 09:17:15 DB2/AIX64 2020-03-23 09:17:15 SQL110144 2020-03-23 09:17:15 - U02012014 JDBC Treiber Version: 4.25.1301 2020-03-23 09:17:15 SELECT 2020-03-23 09:17:15 * 2020-03-23 09:17:15 FROM 2020-03-23 09:17:15 ZT_ARC_HMAC HMAC 2020-03-23 09:17:15 WHERE 2020-03-23 09:17:15 HMAC.HV_DTM < 2020-03-23 09:17:15 ( 2020-03-23 09:17:15 SELECT 2020-03-23 09:17:15 CURRENT DATE - 1 DAY 2020-03-23 09:17:15 FROM SYSIBM.SYSDUMMY1 2020-03-23 09:17:15 ) 2020-03-23 09:17:15 ORDER BY 2020-03-23 09:17:15 HMAC.HV_DTM 2020-03-23 09:17:15 DESC 2020-03-23 09:17:15 [jcc][t4][1065][12306][4.25.1301] Caught java.io.CharConversionException. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null
Wie kann das Problem behoben werden:
„Avoid the exception, you need to specify value 3 for the global property „db2.jcc.charsetDecoderEncoder“. By this way, JCC converts invalid characters to NULL instead of throwing exceptions, using „java.nio.charset.CodingErrorAction.REPLACE“ in case of error. You can add following line into your Java property file if you already have one: db2.jcc.charsetDecoderEncoder=3 or specify „-Ddb2.jcc.charsetDecoderEncoder=3″ on Java command line. “
Comments
Comments are closed.