CODEWITHSUNDEEP
databasejdbcdb2webspheredb2-luw
Ivan
Ivan

Reputation: 21

DB2 Unrecognized JDBC type: -9. ERRORCODE=-4228, SQLSTATE=null

Is anyone familiar with this error:

Caused by: com.ibm.db2.jcc.am.SqlException: [jcc][10271][10296][4.19.26] Unrecognized JDBC type: -9. ERRORCODE=-4228, SQLSTATE=null
at com.ibm.db2.jcc.am.kd.a(Unknown Source)
at com.ibm.db2.jcc.am.kd.a(Unknown Source)
at com.ibm.db2.jcc.am.kd.a(Unknown Source)
at com.ibm.db2.jcc.am.hb.m(Unknown Source)
at com.ibm.db2.jcc.am.gp.a(Unknown Source)
at com.ibm.db2.jcc.am.gp.setObject(Unknown Source)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setObject(WSJdbcPreparedStatement.java:2476)
at org.springframework.jdbc.core.StatementCreatorUtils.setValue(StatementCreatorUtils.java:351)
at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:217)
at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:145)

The current version of my DB2 Database is 10.5.5.

I am using Websphere Application Server (WAS) v.8.5.5 and my JDBC providers use db2jcc4.jar v.4.19.26.

I placed Generic JVM Arguments in WAS which is - -Dclient.encoding.override=UTF-8 -Dfile.encoding=UTF-8 and then this error occurred.

Is there something wrong with the DB2 JDBC jars or it is not compatible with my database?

Upvotes: 2

Views: 8593

Answers (1)

DB2
DB2

Reputation: 1

Check if you are really sending the right type of values to the proc. Generally this happens when you send wrong type of value, could be you are sending CharacterSequence for a Character input value to the proc

Upvotes: 0

Related Questions