DB2 WITH UR (Uncomitted Reads)

[Newbie]

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.

[allan....@gmail.com]

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>();

[Fabio Maulo]

If you need that isolation level for anything you can set it as default in nh-config.

2009/9/19 allan....@gmail.com <allan....@gmail.com>

--
Fabio Maulo

[Fabio Maulo]

have a look to the IInterceptor interface.

2009/9/18 Newbie <karamj...@gmail.com>

--
Fabio Maulo

[Newbie]

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 <fabioma...@gmail.com> wrote:
> If you need that isolation level for anything you can set it as default in
> nh-config.
>

> 2009/9/19 allan.ritc...@gmail.com <allan.ritc...@gmail.com>

>
>
>
>
>
>
>
> > 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 <karamjit.k...@gmail.com> 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 -

[Fabio Maulo]

attach the xsd (schema) to the file where you are writing the nh-conf.

write

<property name=
and follow the intellisense

for values accepted

http://nhforge.org/doc/nh/en/index.html#configuration-hibernatejdbc

2009/9/20 Newbie <karamj...@gmail.com>

--
Fabio Maulo

[Zdeslav Vojkovic]

<property name="connection.isolation">ReadUncommitted</property>

there is a sample here: https://forum.hibernate.org/viewtopic.php?f=25&t=999284