Query- and second-level cache in Seam and Tomcat

[yuriy_zubarev]

Hi.

I've been spinning wheels trying to make query- and second-level Hibernate cache to work in my app. I went through "wiki" example and numerous resources on-line but still having a problem.

My set-up is a bit different than all the examples I saw and therefore I wanted to see if other people succeeded with caching having a similar set-up.

My differences:

1) Using a plain Tomcat 6 (shouldn't make a difference as far as caching is concerned but I want to mention it anyway).
2) My domain objects (JPA entities) and persistence.xml are managed as a separate project outside of Seam web app project. Domain objects are JARed up and used in Seam web app afterward (it's all based on Maven, so it's quite easy)

persistence.xml looks fine:

<property name="hibernate.cache.use_query_cache" value="true"/>

<property name="hibernate.cache.use_second_level_cache" value="true"/>

<property name="hibernate.cache.provider_class" value="org.hibernate.cache.EhCacheProvider"/>

I also provide hints when dealing with Entity Manager:

.setHint("org.hibernate.cacheable", true)

Any other hints from the community?

Thanks,
Yuriy

[gonorrhea]

have you read Ch. 23 Caching in Seam ref doc?

you should be able to use JBoss Cache with Tomcat b/c there is an article in My Link which discusses how to use JBoss Cache w/ Spring (which runs on Tomcat).

are you seeing exceptions or unexpected behavior?

[yuriy_zubarev]

I don't want to use JBoss Cache for now but just EhCache.

I don't see any exceptions, the application works as expected but doesn't utilize any caching at all.

Thank you.

[gonorrhea]

In that case:

EHCache is suitable for use in any container according to Yuan book.

There is an example like this in the book for components.xml:

<cache:eh-cache-provider configuration="ehcache.xml"/>

the recommended version of ehcache.jar is EHCache 1.2.3.

Tomcat Issues and Best Practices: My Link