EBIThree.com > Debugging Clarify > MSSQL JDBC Insert Error Due to Long Int Type

MSSQL JDBC Insert Error Due to Long Int Type

Clarify Scenario:

We are performing a SQL insert into a MSSQL table. During the insert we receive an error when we try to write '6234567890' into field: BankAccountNbr.

Clarify Issue:

The MSSQL column/field is set-up as an int and needs to be a long int. Due to the value '6234567890' being > 2,000,000,000 the column type long int needs to be used.

Clarify Auditor Error:

[ERROR] - JDBC Resource Adapter encountered an Illegal Argument Exception while attempting to set the BankAccountNbr column in row 0 to the value "6234567890" while inserting data into the table "InboundRemittanceAdvHeader".
[ERROR] - Illegal argument of type 4 value 6234567890
[DEBUG] - JDBC Resource Adapter is attempting to roll back the INSERT(S)...
[DEBUG] - JDBC Resource Adapter is FINALLY attempting to close the JDBC Connection.
[ERROR] - Error executing adapter : JDBC Resource Adapter received a Standard Exception while attempting to INSERT: JDBC Resource Adapter received a Standard Exception: Error adding row to database.

Clarify Resolution:

In speaking with the DBA, the MSSQL column was updated and the inbound data translated without incident.


By: on