Eclipse Community Forums: EclipseLink » How to configure query cache invalidation with JPA queries?

Help

Home

Home » Eclipse Projects » EclipseLink » How to configure query cache invalidation with JPA queries?

Show: Today's Messages :: Show Polls :: Message Navigator

How to configure query cache invalidation with JPA queries? [message #386054]

Mon, 23 March 2009 11:34

Torben Putkonen

Messages: 34
Registered: July 2009

Member

Query cache seems to work nice with cache-usage hint
CheckCacheThenDatabase. However, I need to be able to invalidate cached
queries after a timeout.

EclipseLink documentation contains this example:

readQuery.setQueryResultsCachePolicy(
new QueryResultsCachePolicy(new
TimeToLiveCacheInvalidationPolicy(1000))
);

Our code is currently fully JPA compliant, but we would like to use some
EclipseLink extensions like the query cache. Because we are currently
getting the javax.persistence.Query objects from EntityManager's
createNamedQuery() method, is there a way to set invalidation policy for
them without completely rewriting query code?

Report message to a moderator

Re: How to configure query cache invalidation with JPA queries? [message #386058 is a reply to message #386054]

Mon, 23 March 2009 13:56

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

In EclipseLink 1.1 you can configure the query cache, and invalidation
using query hints in any NamedQuery.

The list of query hints are defined here:
http://www.eclipse.org/eclipselink/api/1.1/org/eclipse/persi stence/config/QueryHints.html

The ones for the query cache are:
"eclipselink.query-results-cache"
"eclipselink.query-results-cache.expiry"
"eclipselink.query-results-cache.size"

The cache-usage option is for the object cache however, not the query
cache. For the object cache you can set the invalidation using the @Cache
annotation, EclipseLink orm.xml, or persistence.xml properties.

---
James
http://www.nabble.com/EclipseLink---Users-f26658.html

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Re: How to configure query cache invalidation with JPA queries? [message #386065 is a reply to message #386058]

Tue, 24 March 2009 09:21

Torben Putkonen

Messages: 34
Registered: July 2009

Member

Thanks James! I upgraded to release 1.1.

Cache seems to work now the way I wanted, by adding one hint to the query:
query.setHint(QueryHints.CACHE_USAGE, CacheUsage.CheckCacheThenDatabase);

And one annotation to the Entity:
@Cache ( expiry=100000 )

Report message to a moderator

Previous Topic:	mapping problem: entity as join table
Next Topic:	Optimistic locking without EclipseLink dependency in my domain objects?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 02 10:39:33 GMT 2020

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter