Hibernate version: 3

Name and version of the database: Oracle 9i

I'm new to Hibernate and I want to understand more about the level 1 caching.

I have a table that represents courses taken by a person. The primary key is composite:

PERSON_ID String
COURSE_ID Integer

I thought I could read all rows from the table (and have them cached) and then do per-person queries from the cache like this:

"where PERSON_ID = ?"

However, the per-person queries seem to go to the database rather than the cache (from the Hibernate sql logging).

Is there a way to configure this so that Hibernate looks in the cache for the queries against part of the composite ID?

Thanks,
Steve

Hi

Please try this in applicationContext.xxml file..
<prop key="hibernate.use_query_cache">true</prop>

Thanks
PurnachandraRao.

This doesn't have any effect - I still see the per-person queries hitting the database.

Steve