Troubleshooting
Problem
java.lang.NumberFormatException: For input string: "A" from a DB2 JDBC(JCC) application after upgrading DB2 Server.
Symptom
java.lang.NumberFormatException: For input string: "A"
at
java.lang.NumberFormatException.forInputString(NumberFormatException.jav
a:48)
at java.lang.Integer.parseInt(Integer.java:447)
at java.lang.Integer.parseInt(Integer.java:497)
at com.ibm.db2.jcc.a.xc.<init>(xc.java:64)
at com.ibm.db2.jcc.b.f.<init>(f.java:44)
at com.ibm.db2.jcc.b.b.cb(b.java:1940)
at com.ibm.db2.jcc.a.p.a(p.java:3251)
at com.ibm.db2.jcc.b.b.a(b.java:618)
at com.ibm.db2.jcc.b.b.<init>(b.java:333)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:165)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at
Resolving The Problem
This is a side effect of the modification level of the product identifier in DB2 LUW Servers described in DB2 APAR: IC78892
http://www-01.ibm.com/support/docview.wss?uid=swg1IC78892
The issue is caused by old JCC drivers trying to access newer DB2 server versions.
Upgrade the DB2 JCC driver to match the DB2 Server version.
JCC drivers can be downloaded from here.
https://www-304.ibm.com/support/docview.wss?rs=71&uid=swg21363866
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21625290