it seems either an interceptor or listener would be the best choice
for this. however I cannot seem to locate the proper method/listener
to implement so far I have tried:
EmptyInterceptor
SetSession (to get access to session)
AfterTransactionBegins
BeforeTransactionCompletes
BeforeTransactionCompletes will fire to set arithabort off.
AfterTransactionBegins will either throw a Session Is Closed exception
if I don't check the session is open or it will not fire my sql
statement if I check for Session.IsOpen because the session is closed.
I am trying to execute
Session.CreateSQLQuery("set arithabort on").ExecuteUpdate();
at this point.
I have tried
Session.CreateSQLQuery("set arithabort on").ExecuteUpdate();
with the following listeners
IFlush
IAutoFlush
IPreInsert
IPreUpdate
IPreDelete
IFlush will execute the arithabort statement, but it doesn't execute
the actual flushing (CUD statements)
IAutoFlush doesn't fire the listener at all
(I may have the behavor of these listeners switched)
the Pre Insert/Update/Delete listeners throw an exception that the id
property of the entity I am trying to modify is null. Maybe this is
because I'm injecting the SqlQuery just before the actual update?
On Aug 7, 3:13 pm, Jason Meckley <[email protected]> wrote:
> I have a MS Sql Server db with indexed, computed columns. I'm trying
> to insert a record utilizing session.SaveOrUpdateCopy(entity); but the
> following error is thrown:
>
> NHibernate.HibernateException: An exception occurred when executing
> batch queries ---> System.Data.SqlClient.SqlException: UPDATE failed
> because the following SET options have incorrect settings:
> 'ARITHABORT'.
>
> Is there a way to configure NH to output the sql
> SET ARITHABORT ON
> <actual nh sql>
> SET ARITHABORT OFF
>
> ideally I only want to configure this for the 2 specific tables that
> have computed columns, but if I need to apply it to all tables (or if
> this a simple 1 line config for all tables) I can use that as well.
>
> thank you in advance
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
