HQL Delete Query



Configuration configurationObj = new Configuration();
configurationObj.configure("hibernate.cfg.xml");
SessionFactory sessionfactoryObj = configurationObj.buildSessionFactory();
Session sessionObj = sessionfactoryObj.openSession();

Query queryObj = sessionObj.createQuery("DELETE FROM ENTITIES_DATA E WHERE E.id=? ");

queryObj.setParameter(0,1);
int totalDeletedRecord = queryObj.executeUpdate();
if(totalDeletedRecord == 0) {
  System.out.println(" No record deleted. ");
}else{
  System.out.println(" Total deleted records : "+ totalDeletedRecord);
}

Transaction transactionObj = session.beginTransaction();
transactionObj.commit();
sessionObj.close();
sessionfactoryObj.close();