Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.0

Mapping documents: Not Applicable

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Our client wants to use the Native SQL feature when needing to access multiple tables for various reasons.
We have optimistic locking strategy implemented using the version property.

When using native queries, will hibernate look at the query cache
Environment
Oracle9i
Hibernate 3.0