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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content