Hi,

I need to append "WITH UR" to all the queries. I am using DB2. In HSQLs I am able to add but when ever adding the same to HQL I am getting the following error:
org.hibernate.hql.PARSER *** ERROR: line 1:80: unexpected token: with

unexpected token: with near line 1, column 80 [select distinct uomCode.uomCode from com.apll.ecom.pc.model.UomCode as uomCode with ur]

Please suggest how to use "with ur". It is urgent.

Thanks in advance...

why don't you just use a connection with a better isolation level for you ?