enabling second level cache issue

[phoenix]

I was using second level cache of hibernate, and the following code, the content in my dao method, works. By that I mean if i repeatly run this dao method, only the first SQL was sent to the DB.

try {
Session session = sessionFactory.openSession();
String queryString = "from User u where u.name=:username";
Query q = session.createQuery(queryString);
q.setParameter("username", username);
q.setCacheable(true); // <---- enable query cache
return (User)q.uniqueResult();
}
catch (HibernateException e) {
throw SessionFactoryUtils.convertHibernateAccessExceptio n(e);
}


But, the follow code does not work. I tried to enable the query cache:

HibernateTemplate template = new HibernateTemplate(sessionFactory);
template.setCacheQueries(true); // <--- enable query cache
return (User)template.execute(
new HibernateCallback() {
public Object doInHibernate(Session session) throws HibernateException {
return session.createQuery("from User u where u.name=:userName")
.setParameter("userName", username)
.uniqueResult(); }
}
);

Did i do anything wrong?

Thanks for help in advance...

[phoenix]

it sent out SQL to database each time this dao method is called (thus not using seond level cache).

[phoenix]

By looking at the spring source, I was able to do it now. Case closed.

public User getUser(final String username) throws DataAccessException {
HibernateTemplate template = new HibernateTemplate();
template.setCacheQueries(true);
try {
return (User)template.createQuery(sessionFactory.openSess ion(), "FROM User u where u.name=:userName")
.setParameter("userName", username).uniqueResult();
} catch (HibernateException e) {
throw SessionFactoryUtils.convertHibernateAccessExceptio n(e);
}

}