Uncommitted read in select clause

tjsaker · **Joined:** Wed Oct 08, 2003 3:29 pm **Posts:** 6

Hibernate version: 2.1

Name and version of the database you are using: IBM UDB 8

For performance reasons, I would like to be able to include the "WITH UR" select clause item which sets the isolation level for the query to "UNCOMMITTED READ".

Is there a way to do this on a Criteria or Query ?

christian · **Posted:** Mon Oct 18, 2004 4:29 pm

You realize what you are doing?

tjsaker · **Joined:** Wed Oct 08, 2003 3:29 pm **Posts:** 6

Yes. This is a DBA recommendation for our particular application.

christian · **Posted:** Mon Oct 18, 2004 5:37 pm

Did anyone tell him that it will very quickly destory the information in his database?

christian · **Posted:** Mon Oct 18, 2004 5:40 pm

And if you really like to have uncommited data muddling the real information in your database, simply search for "dirty reads" in this forum. There have been others with DB2 before you asking the same question.

tjsaker · **Joined:** Wed Oct 08, 2003 3:29 pm **Posts:** 6

Thanks Christian - I appreciate the heads-up and I'll take this discussion up with my DBA! In the meantime, I'd still like to know what my options are. Is it possible to enhance the select clause for "WITH UR" on a Criteria and/or Query object?

christian · **Posted:** Tue Oct 19, 2004 10:20 am

No, please read the other threads too.