Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » SQL Server session Settings(Problem with ANSI_WARNINGS flag and TRUNCATE-ing error)
SQL Server session Settings [message #1768636] Thu, 20 July 2017 20:22
Bret Williams is currently offline Bret WilliamsFriend
Messages: 1
Registered: July 2017
Junior Member
Our project is mid converting from Sybase to SQL Server. I've had a number of exceptions due to the SQL Server prohibiting insert of data which will be truncated.

If I SET ANSI_WARNINGS OFF the insert happens without exception but of course truncates the data. That's what I want. But... the setting that I install at the database-level of "OFF" seems to be overridden by a Session/ClientSession-level switch.

How do I explicitly set the initial/default value of the connection to OFF at the session level?

Previous Topic:Persist with secondaryTable from non PK field
Next Topic:Unable to get data from extensible entity using Odata
Goto Forum:
  


Current Time: Sun Dec 17 11:58:47 GMT 2017

Powered by FUDForum. Page generated in 0.01440 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software