Hye,

We are using UDB DB2 v7 and we want use the FOR READ ONLY clause of DB2 in a SELECT query. This clause tells the database not to lock fetching rows.

Example : SELECT person from friends FOR READ ONLY.

How can we add this clause when we need it ?

Thank's

use a native SQL query for this

Yes,

But does this mean that i can't use a hibernate HQL query ?

You can use HQL query - but not if you want the "FOR READ ONLY" added to the SQL.

For that you should use something like createSQLQuery that allows you to use propritary sql stuff like this.

You *could* hack the Hibernate source to support a new LockMode. It wouldn't be difficult.

(Do we need extensible LockModes, guys?)

Depends - are there other usecases and databases than just DB2 that has a similar lockmode ?