in HQL you can't use table aliases for update/delete

you must use executeUpdate instead of execute  or excecuteQuery as following code:


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

String hqlInsert = "insert into DelinquentAccount (id, name) select c.id, c.name from Customer c where ...";
int createdEntities = s.createQuery( hqlInsert )
.executeUpdate();
tx.commit();
session.close();

Simple example of delete  HQL is below :

Session session = HibernateUtil.currentSession();

String hql  = "delete from Product where name = :name";
 query  query = session.createQuery(hql);
query.setString("name","Product 1");
int rowCount = query.executeUpdate();
System.out.println("Rows affected: " + rowCount);