I am using Hibernate and Spring. I need to write a query with where cluase.

Ex: select * from Testtable where id=123

Could some tell which method I have to call from this getHibernateTemplate() ?. It should return a list.

Thanks

http://www.springframework.org/docs/api ... tions.html
http://www.springframework.org/docs/api ... essor.html

the HibernateTemplate class uses a SessionFactory just like a normal app would, and there is a getter for that SessionFactory.

to use direct hql you can just open a new session from the SessionFactory object and use session.createQuery, or one of those custom wrapper methods from the hibernate template will work.

Since you are getting multiple results bacj, I assume id is NOT your primary key.

If you are extending HibernateDaoSupport, you can use this

HibernateTemplate ht = this.getHibernateTemplate();

return ht.findByNamedParam("from TestTable tt where id=:id,
"id", new Long(cityId));

Since you are getting multiple results back, I assume id is NOT your primary key.

If you are extending HibernateDaoSupport, you can use this

HibernateTemplate ht = this.getHibernateTemplate();
return ht.findByNamedParam("from TestTable tt where id=:id",
"id", new Long(123));

Here TestTable is yr class modeled on the table, and must have a TestTable.hbm.xml hibernate mapping file

-Pratik