Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: Hibernate 3.0

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using: MS SQL 2000

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

I use Hibernate criteria queries in my application to read data from tables. However I require data to be read from these tables with the "with nolock" feature of SQL. The idea is most of these read tables get updated by a batch process during the day and thus lock these tables for read during which the application is unable to read data. We are fine to do a dirty read for these tables without locking them from use. How can this be done

u can enable dirty read by this:

session.connection().setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED);