criteria and filters using spring

newtohibernate · **Posted:** Wed Jan 12, 2005 8:39 am

Hi everybody,

I am using hibernate with spring transction magement. I extend the HibernateDaoSupport class and use the getHibernateTemplate() method to find, save and update objects in to the database. But it does not provide a direct way for me to create criteria instead of writing queries. I am requiered to explicitly pass a session objects to create a criteria object which is subsequently causing me many problems. It also provides no feature for me to create filters. I searched the web and found no related examples. PLEASE HELP!

Thank you in advance.

christian · **Posted:** Wed Jan 12, 2005 8:59 am

Complain to the Spring guys if you can't access Hibernate anymore after you use their wrapper. Or don't use it.

croco · **Joined:** Wed Jan 12, 2005 8:58 am **Posts:** 3

If you want do do something that HibernateDaoSupport does not provide, you should try something like:

Code:

getHibernateTemplate().execute(new HibernateCallback(){
   public Object doInHibernate(net.sf.hibernate.Session session) throws HibernateException, SQLException {
           //do your stuff with the hibernate session here
           return .... ;
        }
});

In this way you get the access to the hibernate session. You also get the session/transaction management + exception handling of the Spring HibernateTemplate.

Paul Newport · **Posted:** Wed Jan 12, 2005 11:57 am

We use objects that extend the Spring HibernateDAOSupport class. To create a criteria instance do this:

Criteria criteria = getSession().createCriteria(StandingDataRow.class);