JAVA How to JAVA Development tutorials and how to

20Jul/100

How to set ARITHABORT from JAVA – SQL Server

I had a problem yesterday. I was developing a RESTful web service where i have to run an UPDATE to SQL Server 2005 table, but when i do that i have the next problem:

UPDATE failed because the following SET options have incorrect settings: 'ARIHABORT'

Damn! What the hell is that? Googling i found this:

http://j2eeframeworks.blogspot.com/2008/10/insert-failed-because-following-set.html

And i understood that the table that i want to update is related to indexed views so the UPDATE or INSERT proccess isn't as simple because i had to set the parameter ARIHABORT = ON to do my operations.

So, how to do that?