Ignore data truncation warning from database using JBoss

Solution Verified - Updated -

Issue

When I execute a stored procedure that has a temp table column that is incorrectly defined as being too small for the value that is being inserted.  The database column is varchar(20) and the stored proc temp column is defined as varchar(15), so I will get a "string truncation" error and no data. We want to move forward without fixing these stored procs.  Executing the same stored proc through ODBC is ok because the database has issued a setting that allows the result to ignore the truncation error

Environment

  • MSSQL
  • JBoss

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In