<property name="connection.isolation">ReadUncommitted</property>
there is a sample here: https://forum.hibernate.org/viewtopic.php?f=25&t=999284 On Mon, Sep 21, 2009 at 3:30 AM, Newbie <[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
