Hi,
I need your help.
I am using HibernateDaoSupport.
so all the database related things i am doing using
getHibernateTemplate().
method.

Now i want to delete some rows from a table so instead of passing list of object i want to do it in a single query like this
My SQL fro delete:
Delete from Table_Name where Id =Some_value;

so can any body help me how can i perform this task by writting a single sql and executing it by getHibernateTemplate().
Please help me.
thanks in advance.[/b]

http://www.hibernate.org/hib_docs/v3/re ... tch-direct

Session session = sessionFactory.openSession();
Transaction tx = session.beginTransaction();

String hqlDelete = "delete Customer c where c.name = :oldName";
int deletedEntities = s.createQuery( hqlDelete )
.setString( "oldName", oldName )
.executeUpdate();
tx.commit();
session.close();

I think that you can do HQL from HibernateTemplate as well. Actually I would not encourage the use of HibernateTemplate in an Hibernate 3.x environment.