Delete all objects from database in hibernate Spring java

Question

I want to delete all those rows from xyz table where id = 1 using hibernate spring.

I have tried following code but its not giving error but not deleting rows -

 Session session = (Session) getEm().getDelegate();
 String sql ="Delete from xyz where id=:id" ;
SQLQuery query  = session.createSQLQuery(sql);
query.setParameter("id", "1");
int flg = query.executeUpdate();

Can you please help me to delete all rows using hibernate query.

Answer 1

Try wrapping your code within a transaction like this:

Session session = (Session) getEm().getDelegate();
Transaction tx = session.beginTransaction();
String sql ="Delete from xyz where id=:id" ;
SQLQuery query  = session.createSQLQuery(sql);
query.setParameter("id", "1");
int flg = query.executeUpdate();
tx.commit();