Hi there!

I would like to ask how to configure QueryCache in the ehcache.xml?

In addition, what is this cache region?

and where I have to configure it?

In the 14.3.1. Cache mappings said:
"Alternatively (preferrably?), you may specify <class-cache> and <collection-cache> elements in hibernate.cfg.xml."
Can anybody share an example of <class-cahe>,<collection-cache> configuration? And is this configuration an alternative or preferrable one? I think that using class-cahe and collection-cache is preferrable approach, I don't like to mix mapping and cache configuration in hbm.xml files, for me it would be more suitable to configure caches in the hibernate.cfg.xml and ehcache.xml.

Thanks,
Leonid

It is funny (too simple:), the following code for QueryCache configuration works:



DEBUG [net.sf.ehcache.store.MemoryStore] initialized MemoryStore for net.sf.hibernate.cache.QueryCache
...
INFO [net.sf.hibernate.cache.QueryCache] starting query cache at region: net.sf.hibernate.cache.QueryCache

But what about the second part of my previous post, about cache region, class-cache and collection-cache?

--
Leonid

The query cache is for caching query results (does not cache the whole objects, only the ids), the class-cache and collection-cache are specifically for making classes cachable, this affects the query cache, too (does not make much sense to use a query cache without making the returned classes cachable)

Yeah, it is fine, but I read it in the documentation :)
What about cache regions and examples of class-cache, collection-cache in hibernate.cfg.xml?

Thanks,
Leonid

Well, query.setCacheRegion() just overrides the default region "net.sf.hibernate.cache.QueryCache".

Thanks.

In the 14.3.1. Cache mappings said:
"Alternatively (preferrably?), you may specify <class-cache> and <collection-cache> elements in hibernate.cfg.xml."

Is is an alternative or preferrable approach? And where it is documented (DTD has no comments).

--
Leonid

Alternative, maybe preferable. It's your decission if you like it better or not. It is actually quite simple to use. To set up a cache for class yyy.XXX, instead of putting a <cache> element inside the Mapping, put



inside the hibernate.cfg.xml. Same goes for collection zzz of class yyy.XXX, instead of putting a cache mapping inside of the collection mapping, you can put



inside the hibernate.cfg.xml

Well, and further. Does collection cache consist only IDs of objects (that should be cached too), like query cache?

--
Leonid