Hibernate cache ?

[mn]

hi

I have a couple of "data dictionaries" tables in my database, that i'm sure won't change in a whole deploy-time, so obviously i want them cached by hibernate. Each access to those tables whether it's by "getHibernateTemplate().find..." or loadAll() or simply as a property (FK) of other object, or whatever i want it to be a memory-access, and not hibernate doing selects. I have done this:

<class name="Blabla" table="VIT_BLABLA" mutable="false">
<cache usage="read-only"/>

but i see in logs that hibernate is still doing selects (show_sql=true) even with getHibernateTemplate().loadAll(). any suggestions appreciated

thanks
tom

[Colin Yates]

There is a seperate setting for caching collections. Check hibernate docs, I cannot remember them off hand

Also, be aware that if you do cache collections, hibernate *probably* (how else could it work?) will drop the collection cache as soon as the table is modified.

[Costin Leau]

Very good example are found inside Spring samples and javadocs.

Quote from LocalSessionFactoryBean:

setEntityCacheStrategies

public void setEntityCacheStrategies(Properties entityCacheStrategies)

Specify the cache strategies for entities (persistent classes or named entities). This configuration setting corresponds to the <class-cache> entry in the "hibernate.cfg.xml" configuration format.

For example:

<property name="entityCacheStrategies">
<props>
<prop key="com.mycompany.Customer">read-write
<prop key="com.mycompany.Product">read-only
</props>
</property>

Parameters:
entityCacheStrategies - properties that define entity cache strategies, with class names as keys and cache concurrency strategies as values
See Also:
Configuration.setCacheConcurrencyStrategy(String, String)

setCollectionCacheStrategies

public void setCollectionCacheStrategies(Properties collectionCacheStrategies)

Specify the cache strategies for persistent collections (with specific roles). This configuration setting corresponds to the <collection-cache> entry in the "hibernate.cfg.xml" configuration format.

For example:

<property name="collectionCacheStrategies">
<props>
<prop key="com.mycompany.Order.items">read-only
</props>
</property>

Parameters:
collectionCacheStrategies - properties that define collection cache strategies, with collection roles as keys and cache concurrency strategies as values
See Also:
Configuration.setCollectionCacheConcurrencyStrateg y(String, String)