Hibernate version: 2.x

[b]Mapping documents:

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:


Does Hibernate ever scan the second-level cache to satisfy a HQL query that contains predicates involving non-primary field keys, or does it go to the database in such a situation?
Does does it make use of the query support afforded by the underlying cache provider? Tangosol Coherence, for example, allows a cache to be queried on non-primary key fields( and it also allows indices to be defined on such fields).