Thank you. Can you please let me know the syntax of the isolation level I need to specify in the nhibernate config file. Your assistance is greatly appricated.
On Sep 19, 2:39 pm, Fabio Maulo <[email protected]> wrote: > If you need that isolation level for anything you can set it as default in > nh-config. > > 2009/9/19 [email protected] <[email protected]> > > > > > > > > > The DBA's I work with gave us a similar issue but it was on SQL Server > > and they wanted WITH(NOLOCK) added to every select/join. Using a > > transaction isolation level of ReadUncommitted gives us the > > equivalent. Not sure if it will do the same for you in DB2 or not. > > > using (session.BeginTransaction(IsolationLevel.ReadUncommitted) > > return session.CreateCriteria<Type>().List<Type>(); > > > On Sep 18, 7:08 pm, Newbie <[email protected]> wrote: > > > We are using NHibernate to interact with DB2 ZOS. For general selects, > > > we would like NHibernate to execute all selects with "WITH UR" > > > keyword to perform dirty reads. We are new to NHibernate. Any ideas > > > on how we can automatically append "WITH UR" to all select statements? > > > Thanks in advance. > > -- > Fabio Maulo- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
