Hi All,

I need help on using cache for many-to-one relations.

I have looKup data table which has lookup value. Almost every table in application is linked to Lookup data table and every one has many-to-one relations.

So whenever i load an object, i need to load these Lookup data objects also.

So can i use caching for this solution, as i dont want hibernate to hit the db for each lookup data.

Thanks

Siddharth

First you need to decide which Second Level Cache provider to use. The reference doc may help you:

http://www.hibernate.org/hib_docs/refer ... ance-cache

The configure the cache settings in your hbm file for class level properties and collection valued properties.


If you are going to use ehcache, then you need to configure ehcache.xml.

Thanks

Sorry i might wrongly put the question but,
I am already using the ehcache and configured it, its working for the Collections i.e relation which are one-to-many, but in case on many-to-one its not working. So i need that my look up data which is in many to one relation should be picked from cache.

Make sure that there is a cache region for the class that's the "one" in your ManyToOne.

You should configure the linked lookup data as Lazy, or "select" mode fetch; othervise it will generate a Join SQL statement. Then when trying to load the linked value with a second separated query it will hit cache.

see http://forum.hibernate.org/viewtopic.php?t=970070