Hi,

I just want to clear something.
In sybase there is something "at isolation read uncommitted" you can use when executing a query to read pages even if locked.

While searching in hibernate for sucha behavior ,I have came accross "query.setLockMode(alias??? ,LockMode.NONE)"

What I need to find out is how to specify the alias for mulitple objects+the function i query with is generic ,thus accepting each time a different query string,so I can't predict the alias.

The documentation says :

alias a query alias, or this for a collection filter

I didn't quite get it !!!
Is there a way of specifying all objects . I don't care if my query returns not-uptodate objects.I just want to get the results even though there is an update lock on the table.

Besides I can't use transaction setMode because I use it for updating afterwards.

Thanks a lot.
Z

"this" is the root alias. However, it won't help you, as it does not do what you want: it's just used to specify that you want the default read type (with nolock) instead of locking it (using the "select .. for update" or whatever your DB's syntax is). There is no way to read items that are locked: you'll have to use an SQL query, or get the JDBC connection and do it manually.

Ok, thanks

But however I think this should be submitted as an improvement ?

Well, you could head over to the JIRA issue site (see www.hibernate.org for the link), but I'd expect it to be turned down. It's not really something that fits into hibernate's way of thinking. Hibernate won't lock rows for updating prematurely: if you have a massive update loop, no DB locks are acquired until you eventually flush. So the only time this is likely to be an issue is if some other app is writing to the DB. Still, no harm in trying, and I can't profess to know anything about the development team's vision for hibernate.