MSSQL JDBC Insert Error Due to Long Int Type
EBI 3 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.
EBI 3 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.
EBI 3 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.
EBI 3 Resolution:
In speaking with the DBA, the MSSQL column was updated and the inbound data translated without incident.
By: Sean Hoppe on