I do see this exception infrequently. This exception may happen for the exact same record, which was inserted into database successfully before.
There is no pattern for this exception to occur. As I said, the exact same record that had success before may throw this exception.
I am using WAS 18.104.22.168 and DB2 7.x.
I am using datasource to get database connection.
[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005 at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:267) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:209) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:455)
I get following exception verbiage:
CLI0112E Error in assignment. Explanation: The data sent for a parameter or column was incompatible with the data type of the associated table column. User Response: Respecify the output binding through SQLBindCol or SQLGetData or the input binding through SQLSetParam or SQLBindParameter.
Above verbiage is of no use to me as this error is infrequent without any pattern. As I said before, the exact same message which was successsful inserting before could throw the exception above.
subject: SQLSTATE=22005 WebSphere 22.214.171.124 and db2 7.x