Hello,

Thank you for this answer.

I am in the same situation.
The DB administrator thinks I should use RAD ONLY of every select request that we identified.

I am using DB2 9.7 and hibernate 4.3.1. I tried to resue the code given above.
The DB2 dialect has no getDatabaseReadOnlyString method.

How can I use a custom interceptor with an entity manager (because I use the enetity manager way of doing things) ?

The following solutions do not work: if the final SQL query I have no READ ONLY keyword:
query.setHint("org.hibernate.readOnly", true);
query.setLockMode(LockModeType.READ);

Thank you