IC SunsetThe developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this forum will no longer be available. More details available on our FAQ.
Topic
  • 8 replies
  • Latest Post - ‏2009-04-14T14:44:24Z by SystemAdmin
OceanBreeze
OceanBreeze
2 Posts

Pinned topic CLI0112E Error in assignment. SQLSTATE=22005 DB2 7.x, WebSphere 5.1.1.3

‏2006-03-04T15:31:23Z |
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. There is no constraint in database because of business reason. As such, the same record can be inserted multiple times in database.

I am using WAS 5.1.1.3 and DB2 7.x. I am using datasource to get database connection.

Any solution/suggestion will be appreciated.

Exception Stack Trace:

IBMCLI 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.
Updated on 2009-04-14T14:44:24Z at 2009-04-14T14:44:24Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    6040 Posts

    Re: CLI0112E Error in assignment. SQLSTATE=22005 DB2 7.x, WebSphere 5.1.1.3

    ‏2006-06-21T20:13:38Z  
    Hi,

    Did you get any solution for this issue? We are also facing the same issue. Could you please reply back to ManjushMenon@hotmail.com?

    Thanks in advance.
    Manjush
  • SystemAdmin
    SystemAdmin
    6040 Posts

    Re: CLI0112E Error in assignment. SQLSTATE=22005 DB2 7.x, WebSphere 5.1.1.3

    ‏2007-01-11T10:30:50Z  
    Hi,

    Did you get any solution for this issue? We are also facing the same issue. Could you please reply back to ManjushMenon@hotmail.com?

    Thanks in advance.
    Manjush
    Can you please send me the resolution if you got. I'm getting the similar error.

    Your help will be greatly appreciated
  • SystemAdmin
    SystemAdmin
    6040 Posts

    Re: CLI0112E Error in assignment. SQLSTATE=22005 DB2 7.x, WebSphere 5.1.1.3

    ‏2007-01-11T10:31:36Z  
    Can you please send me the resolution if you got. I'm getting the similar error.

    Your help will be greatly appreciated
    Please send me the resolution to bharath_chandra_20@yahoo.com
  • SystemAdmin
    SystemAdmin
    6040 Posts

    Re: CLI0112E Error in assignment. SQLSTATE=22005 DB2 7.x, WebSphere 5.1.1.3

    ‏2007-01-13T15:11:27Z  
    Please send me the resolution to bharath_chandra_20@yahoo.com
    bharath_chandra_20@yahoo.com wrote:
    > Please send me the resolution to bharath_chandra_20@yahoo.com
    Bharath,

    You might try asking for help on the ibm.software.db2.udb or
    ibm.software.websphere-application-server newsgroups

    Regards,
    Kenneth
  • SystemAdmin
    SystemAdmin
    6040 Posts

    Re: CLI0112E Error in assignment. SQLSTATE=22005 DB2 7.x, WebSphere 5.1.1.3

    ‏2007-12-27T10:50:57Z  
    can you please send me the solution to ramakrishna.basagalla@gmail.com
  • SystemAdmin
    SystemAdmin
    6040 Posts

    Re: CLI0112E Error in assignment. SQLSTATE=22005 DB2 7.x, WebSphere 5.1.1.3

    ‏2009-01-13T15:15:42Z  
    Hi
    I am using Microsoft IIS instead of WAS.
    I am also facing this error.
    However, I found some info in this link.. something to do with DB2 Fixpack 9 & 10
    Appreciate if we get an alternative solution
  • SystemAdmin
    SystemAdmin
    6040 Posts

    Re: CLI0112E Error in assignment. SQLSTATE=22005 DB2 7.x, WebSphere 5.1.1.3

    ‏2009-04-14T14:41:31Z  
    This may or may not be a solution to your issue, but I have found that if I'm using a variable, and the variable has not been assigned a "null" or "empty" value for those cases when the information coming into it is empty or null (usually from a Form Post), then I get this error you mention.

    Therefore, if I have a variable, then I have to be sure I have said (basically), "If variable does not have a value, then give it this "value" -- which would usually be null or and empty string, or some other acceptable thing.

    **************************************
    In simple ASP, it looks like this:
    **************************************
    Dim myVariable
    myVariable = "" 'do this too!

    If Request.Form("FirstName")"" Then
    myVariable = Request.Form("FirstName")
    Else
    myVariable = "" 'empty string assigned to it since it is empty -- overkill but effective
    End If

    **************************************

    I hope that helps!
  • SystemAdmin
    SystemAdmin
    6040 Posts

    Re: CLI0112E Error in assignment. SQLSTATE=22005 DB2 7.x, WebSphere 5.1.1.3

    ‏2009-04-14T14:44:24Z  
    This may or may not be a solution to your issue, but I have found that if I'm using a variable, and the variable has not been assigned a "null" or "empty" value for those cases when the information coming into it is empty or null (usually from a Form Post), then I get this error you mention.

    Therefore, if I have a variable, then I have to be sure I have said (basically), "If variable does not have a value, then give it this "value" -- which would usually be null or and empty string, or some other acceptable thing.

    **************************************
    In simple ASP, it looks like this:
    **************************************
    Dim myVariable
    myVariable = "" 'do this too!

    If Request.Form("FirstName")"" Then
    myVariable = Request.Form("FirstName")
    Else
    myVariable = "" 'empty string assigned to it since it is empty -- overkill but effective
    End If

    **************************************

    I hope that helps!
    Woops! left off the equal sign.

    **************************************
    In simple ASP, it looks like this:
    **************************************
    Dim myVariable
    myVariable = "" 'do this too!

    If Request.Form("FirstName")="" Then
    myVariable = Request.Form("FirstName")
    Else
    myVariable = "" 'empty string assigned to it since it is empty -- overkill but effective
    End If