Hibernate version:
3.0.5
Name and version of the database you are using:
Ingres 2.6

Just wanted to know if it is possible to call sql commands such as the following:

set lockmode on afrelease where readlock=nolock

We are having trouble with table locking and want to try executing this command before we query the table.

Thanks,
Andrew

Use Session.connection(), and create your own Statement, etc.
Note the different situations in which you must or must not close the connection returned by this method (see the javadocs).