Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3
SQL Server 2005


I want to execute and set database property SET ARITHABORT ON before
executing insert on a table.

I am trying this but does not work.
I want this property to be set for the scope of the transaction

Session session = HibernateSession.openSession(databaseType);

SQLQuery sqlQuery = session.createSQLQuery("SET ARITHABORT ON ");
int i = sqlQuery.executeUpdate();

session.save(myObject);

///////

I want to replicate this sequence in query Analyzer:

SET ARITHABORT ON
GO
insert into myObject(a,b,c) values (1,2,3)


Any suggestions.

Thanks,Malini

Hi Malini,

I am also having the smae problem now. Hopefully you fixed that problem. Please let me know the solution if you solved it.

Thanks
Venkat