permaculture playing cards
The moose likes JDBC and Relational Databases and the fly likes SQLSTATE=22005 WebSphere and db2 7.x Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQLSTATE=22005 WebSphere and db2 7.x" Watch "SQLSTATE=22005 WebSphere and db2 7.x" New topic

SQLSTATE=22005 WebSphere and db2 7.x

Sam Gehouse
Ranch Hand

Joined: Jul 21, 2003
Posts: 281
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

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.
I agree. Here's the link:
subject: SQLSTATE=22005 WebSphere and db2 7.x
It's not a secret anymore!