IBM Support

JDBC Adapter batch business object with a sequence value greater than 2147483647 causes "Invalid Conversion" exception

Troubleshooting


Problem

When a JDBC outbound batch business object uses a sequence with a value greater than 2147483647, the "Invalid Conversion, probably a number format problem" exception is generated.

Symptom

[1/4/10 15:43:31:093 CST] 0000014b FFDC Z com.ibm.ws.sca.internal.j2c.J2CMethodBindingImpl com.ibm.ws.sca.internal.j2c.J2CMethodBindingImpl#0x04 Exception:
javax.resource.ResourceException: Invalid Conversion, probably a number format problem
at com.ibm.j2ca.jdbc.commands.JDBCExecuteCommand.setSequenceValues(JDBCExecuteCommand.java:532)
at com.ibm.j2ca.jdbc.commands.JDBCExecuteCommand.doProcessBatchSQL(JDBCExecuteCommand.java:269)
at com.ibm.j2ca.jdbc.commands.JDBCExecuteCommand.execute(JDBCExecuteCommand.java:111)
at com.ibm.j2ca.extension.commandpattern.CommandForCursor.execute(CommandForCursor.java:74)
at com.ibm.j2ca.extension.commandpattern.Interpreter.executeWithChildren(Interpreter.java:123)
at com.ibm.j2ca.extension.commandpattern.Interpreter.execute(Interpreter.java:82)
at com.ibm.j2ca.jdbc.JDBCInteraction.executeInternal(JDBCInteraction.java:382)
at com.ibm.j2ca.jdbc.JDBCInteraction.execute(JDBCInteraction.java:140)
at com.ibm.ws.sca.internal.j2c.J2CMethodBindingImpl.invoke(J2CMethodBindingImpl.java:242)
at com.ibm.ws.sca.internal.j2c.J2CInterfaceBindingImpl.invoke(J2CInterfaceBindingImpl.java:118)

Cause

A business object with the "int" data type does not support a value greater than "2147483647". When the JDBC adapter receives a sequence value greater than "2147483647" from the database, and tries to insert the value into a business object's attribute with the "int" data type, it fails and the "Invalid Conversion, probably a number format problem" exception is generated.

Resolving The Problem

After the JDBC outbound batch business object is generated, change the data type of the statement1parameter1 element from "int" to "string".
<xsd:sequence minOccurs="1" maxOccurs="1">
<xsd:element name="statement1parameter1" type="xsd:int" nillable="true" minOccurs="0" maxOccurs="1">
<xsd:annotation xml:space="preserve">

[{"Product":{"code":"SSMKUK","label":"WebSphere Adapters Family"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Adapter for JDBC","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"6.1;6.0.2;6.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
15 June 2018

UID

swg21416771

Page Feedback