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

1
votes

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?

1
databasejdbcdb2webspheredb2-luw
Looks like at least one of your statement parameters has a data type that has no SQL equivalent. - mustaccio
JDBC type -9 is NVARCHAR: docs.oracle.com/javase/8/docs/api/… - Luke Woodward
You stack contains Spring framework, may you be using an rather older version? There was a fixed issue resembling this. - Kurtcebe Eroglu
Is this an issue about the DB2 JDBC jar that I am using or should I update the java version/spring jar of my Websphere Application Sever? - Ivan
I'm currently using spring version 2.5.6. - Ivan

1 Answers

0
votes

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