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. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
