Ignore data truncation warning from database using JBoss
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, tools, and much more.