DB2 - Problembeschreibung
Problem IT28261 | Status: Geschlossen |
JAVA.LANG.CLASSCASTEXCEPTION DURING EXECUTEBATCH() WITH SQLJAVOIDTIMESTAMPCONVERSION | |
Produkt: | |
DB2 CONNECT / DB2CONNCT / B10 - DB2 | |
Problembeschreibung: | |
Description : While doing a batch insert of a timestamp with a batch size greater than 1 and the property SqljAvoidTimeStampConversion is set to true, ClassCastException is thrown. This behavior is seen in jcc drivers Jcc driver 4.23 and 4.24. DataSource.setSqljAvoidTimeStampConversion(true); connection = dataSource.getConnection(); statement = connection.prepareStatement( "INSERT INTO APP.TEST ( ID ) VALUES ( ? )" ); String ts = "2018-12-12-16.24.04.123456"; statement.setString(1, ts); statement.addBatch(); statement.setString(1, ts); statement.addBatch(); int[] b = statement.executeBatch(); The exception is: Exception in thread "main" java.lang.ClassCastException: com.ibm.db2.jcc.am.InternalTimestamp incompatible with java.lang.String at com.ibm.db2.jcc.t4.ah.a(ah.java:1526) at com.ibm.db2.jcc.t4.ah.a(ah.java:1425) | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * 2 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Vnext Jcc driver * **************************************************************** | |
Local-Fix: | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 01.03.2019 30.05.2019 30.05.2019 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |