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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
