Hibernate Community • View topic - Query cache with misses in case of entity parameter

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Query cache with misses in case of entity parameter

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

chris@dvdb.de

Post subject: Query cache with misses in case of entity parameter

Posted: Fri Jan 28, 2011 8:28 am

Newbie

Joined: Sun Feb 11, 2007 3:42 pm
Posts: 8

Hey,

we re using Jboss 5.1 with JPA in our application. Cache mode for our entities is transactional.

The issue is that for certain queries the cache is ignored, e.g:

Code:

core.createQuery("select sr.site from SiteRole sr where sr.person = :person order by sr.siteRoleId asc").setParameter("person", p).setHint("org.hibernate.cacheable", true).getResultList();

However, if I'm changing the query to:

Code:

core.createQuery("select sr.site from SiteRole sr where sr.person.personId = :person order by sr.siteRoleId asc").setParameter("person", p.getPersonId().setHint("org.hibernate.cacheable", true).getResultList();

it is retrieved via the cache without DB roundtrip.

The only difference is that instead of setting the person object as query parameter I'm just using its ID.
The cache mode of the Person entity itself is also transactional.

Any hints what I'm missing here?

Thanks, Chris

Top

chris@dvdb.de

Post subject: Re: Query cache with misses in case of entity parameter

Posted: Tue Feb 01, 2011 8:08 am