• Post Reply Bookmark Topic Watch Topic
  • New Topic

SQLSTATE=22005 WebSphere and db2 7.x  RSS feed

Ranch Hand
Posts: 281
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 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

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.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!