Eclipse Community Forums: EclipseLink » How to bypass cache for a specific query?

Help

Home

Home » Eclipse Projects » EclipseLink » How to bypass cache for a specific query?

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

How to bypass cache for a specific query? [message #389747]

Fri, 26 June 2009 13:32

Torben Putkonen

Messages: 34
Registered: July 2009

Member

I have specified the following cache for an entity:

@Entity
@Cache(expiry = 3600000,
size = 10000)

However, in one specific case I need to be able to query entry using its
primary key directly from the database in order to see that no one has
changed it outside my application.

I have not so far found a way to accomplish this. For example the
following query still returns the entity from cache and not from the
database:

@NamedQuery(name = "Table.findByPK", query = "select o from Table o WHERE
o.pk1=:PK1 and o.pk2=:PK2", hints = { @QueryHint(name =
QueryHints.CACHE_USAGE, value = CacheUsage.DoNotCheckCache) }) })

Do I need to use explicit call to em.refresh or is there another way?

Report message to a moderator

Re: How to bypass cache for a specific query? [message #389750 is a reply to message #389747]

Fri, 26 June 2009 14:14

Torben Putkonen

Messages: 34
Registered: July 2009

Member

Flushing query cache explicitly isn't enough because that seems to leave
entity cache intact. Is there a way to flush the entity cache for a
specific entity?

Report message to a moderator

Re: How to bypass cache for a specific query? [message #389753 is a reply to message #389747]

Mon, 29 June 2009 14:24

James Sutherland

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

Senior Member

refresh will refresh the object in the cache.

That cache usage option will just ignore the cache hit before accessing
the database, but will still maintain the cache after fetching the data.

Other query hints are:

"eclipselink.refresh"="true" , refreshes the object in the cache.

"eclipselink.maintain-cache"="false" , this will ignore the cache entirely
and return you a different copy of the object directly from the database.

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Previous Topic:	transaction not commiting
Next Topic:	[V2] Jar locked during webapplication redeploy

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 17:41:25 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter