We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now


is it required to flush and clear hibernateTemplate?

cuttieveenz asked
Medium Priority
Last Modified: 2013-11-11
Hi ,
I am using Hibernate and Spring. we are using getHibernateTemplate().find() in our DAOs. After the find() is called, do we have to explicitly call flush() and clear()? Will it lead to memory leak if we dont flush and clear?
Watch Question

flush() don't help, becaus it only synchronizes with the DB
clear() helps if you are loading to much data
you can use evict() instead of clear() for specific objects

It don't load to memory leaks but if you are loading to much data, you have to evict()/clear() so that the session-cache doesn't get too big.

Normaly the session is cleared when it will be closed and you don't have to clear it on you own.


actually the data consists of CLOB column data...hence it is very large and leads to memory leak

Then I would advice to iterate through the result and evict each result

Iterator iter = session.createQuery("from CatImpl as cat").iterate();
while(iter.hasNext() ) {
	Cat currentCat = (Cat) iter.next();

Open in new window


In my DAO code is as follows:

List emp = getHibernateTemplate().find("from Employee");
return emp;

Here emp is a list of objects which has CLOB data. I get a memory leak due to this clob in hibernate.

That's why i changed the code as follows:

List emp = getHibernateTemplate().find("from Employee");
return emp;

Will this help?
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

flush() is used for flush getHibernateTemplate() content u were used in  session factory creation
Just a side question, do you experience LazyInitializationException when you call to get associated objects from the Employee you queried for, like employee.getDepartment().getName() ? What I try to ask is: is the Hibernate Session closed right after each call to HibernateTemplate?

Are you using CMT or BMT?? I ask this because the solution to your problem really depends on how you define the demarcation of a transaction and of a Hibernate session.

As mahome suggested, the Hibernate Session object will cache the result of any queries and will clear the cache out automatically when it is closed. But when does a Hibernate Session close? As you use the class  HibernateTemplate from Spring and make a query, if you setting is not correct, you will find that the Hibernate Session will always close itself right after each call.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.