Querying Hibernate cache

Question

I have the following code:

Person a = new Person();
a.setName("John");

Session session = openHibernateSession();

session.beginTransaction();

session.saveOrUpdate(a);

Criteria critera = session.createCriteria(Person.class);
critera.add(Restrictions.eq("name","John"));
Person personFromCache = (Person) criteria.uniqueResult();

...

session.commit();

What I want is to have the ability to search objects from both the database and Hibernate's cache. The following example returns null upon calling uniqueResult. Is there any way to retrieve saved objects that have not yet been committed to the database?

score 1 · Answer 1 · answered Feb 25 '13 at 13:15

If you are searching other than ID then Hibernate will not use first level cache. Hibernate get and load is related to first level cache by default but criteria query is not. In your case there are two solution from my side

By flushing session = Just flush your session like this session.flush(); while doing so data from session will be synchronize to database hence Id will ge generated and as result Criteria query will find the result in database and will result list to you.
Enable hibernate second level cache = You can enable second level cache by hibernate cache providers like ehCache and apply the trick.

score 0 · Answer 2 · answered Feb 25 '13 at 13:58

0

You can use the StatelessSession but be warned: those entitys are not bound to any session and you will get Exceptions if you like to resolve relations or lazy fields!

answered Feb 25 '13 at 13:58

Grim

1,938
10
56
123

score 0 · Answer 3 · answered Mar 08 '13 at 01:46

0

session.beginTransaction();

session.saveOrUpdate(a);

session.flush();

Criteria critera = session.createCriteria(Person.class);
critera.add(Restrictions.eq("name","John"));
Person personFromCache = (Person) criteria.uniqueResult();

answered Mar 08 '13 at 01:46

JcLucky

1
1

score 0 · Answer 4 · answered Mar 14 '13 at 20:25

We do some similar things except using TestNg test framework. Several of the answers discuss the session.flush() method call. This is correct. The call to flush tells Hibernate to do several things, including making sure that all database calls currently waiting in the queue get executed and cleared from the queue.

score 0 · Answer 5 · answered Oct 31 '14 at 20:25

0

It returns data even if you are selecting on the basis of username. It is not returning null.

answered Oct 31 '14 at 20:25

unknown

412
7
20

Querying Hibernate cache

5 Answers5