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?

Rais Alam · Accepted Answer · 2013-02-25 13:15:59Z

1

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.

answered Feb 25, 2013 at 13:15

Rais Alam

7,02613 gold badges56 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Grim · Accepted Answer · 2013-02-25 13:58:06Z

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, 2013 at 13:58

Grim

2,16312 gold badges63 silver badges139 bronze badges

Comments

JcLucky · Accepted Answer · 2013-03-08 01:46:04Z

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 8, 2013 at 1:46

JcLucky

11 bronze badge

Comments

Mark Harris · Accepted Answer · 2013-03-14 20:25:04Z

0

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.

answered Mar 14, 2013 at 20:25

Mark Harris

35 bronze badges

Comments

Amby · Accepted Answer · 2014-10-31 20:25:46Z

0

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

answered Oct 31, 2014 at 20:25

Amby

4621 gold badge10 silver badges23 bronze badges

Collectives™ on Stack Overflow

Querying Hibernate cache

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related