IInterceptor.OnPrepareStatementor
YourCustomDrive.GenerateCommand
2009/8/7 Jason Meckley <[email protected]>
>
> 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
> >
>
--
Fabio Maulo
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
