Delete table contents

asuft · **Joined:** Fri Jul 07, 2006 5:45 pm **Posts:** 1

I am having trouble in Hibernate 3 deleting all rows in the table. The HQL:

'DELETE FROM TABLE_NAME'

throws this exception:

org.hibernate.QueryException: query must begin with SELECT or FROM: DELETE [DELETE FROM Users]
at org.hibernate.hql.classic.ClauseParser.token(ClauseParser.java:83)
at org.hibernate.hql.classic.PreprocessingParser.token(PreprocessingParser.java:108)
at org.hibernate.hql.classic.ParserHelper.parse(ParserHelper.java:28)
at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:191)
at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:167)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:75)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:54)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1583)

Any insight would be greatly appreciated.

dslevine · **Joined:** Thu May 26, 2005 12:20 am **Posts:** 72

Quick note that might solve your problem:

in HQL you refer to your hibernate class name, not the TABLE_NAME. So if I have an HQL object as defined in the xml file to be named "RoadRunner" and the table is named "ROAD_RUNNER", you would:

DELETE FROM RoadRunnner

batmat · **Posted:** Mon Jul 10, 2006 8:09 am

Yes, as dslevine said, you must use class names. Second, you must not call list() on the Query object that createQuery() returns. Call executeUpdate() do run hql delete statement (http://www.hibernate.org/hib_docs/v3/re ... tch-direct) :

Code:

Session session = HibernateUtil.currentSession();
session.beginTransaction();
   
Query q = session.createQuery("delete from Client");
q.executeUpdate();

session.getTransaction().commit();

How do you do your call ?

kovarex · **Joined:** Mon Jul 24, 2006 12:48 pm **Posts:** 4

I have the same problem with hibarnate
Hibernate-Version: 3.1.3

I'm using the update method, and object names, already made few select queries, but the delete doesn't work

kovarex · **Joined:** Mon Jul 24, 2006 12:48 pm **Posts:** 4

I have the same problem with hibarnate
Hibernate-Version: 3.1.3

I'm using the update method, and object names, already made few select queries, but the delete doesn't work

kai11706 · **Posted:** Mon Jul 24, 2006 10:15 pm

I have the same problem!

kovarex · **Joined:** Mon Jul 24, 2006 12:48 pm **Posts:** 4

Here is more detailed description of the problem
Hibernate-Version: 3.1.3

I tried these methods how to delete something
1)
java code (from documentation):
Query query = session.createQuery( "delete from ErrorMessage e where e.portid = :portid ");
query.setString("portid", id);
query.setReadOnly(false);
query.executeUpdate()
result :
query must begin with SELECT or FROM: delete [delete from cz.ami.cac.db.ileas.ErrorMessage e where e.portid= :portid ]
2)
Session sess = HibernateFactory.currentSession();
session.delete("select e FROM cz.ami.db.ileas.ErrorMessage as e where portid = '" + id + "'");
result (strange): Unknown entity: java.lang.String

3)
This works, but it is not bad solution :
List<ErrorMessage> errorMessages = loadErrorMessages(id);
for (int i = 0; i < errorMessages.size();i++)
{
ErrorMessage errorMessage = errorMessages.get(i);
session.delete(errorMessage);
}

dslevine · **Joined:** Thu May 26, 2005 12:20 am **Posts:** 72

is portid a string value? is portid the name of the property in your object model? can you post your hibernate mapping file.

White_King · **Joined:** Thu Jan 26, 2012 11:56 am **Posts:** 9

Same problem Here! i think that Hibernate just troll us...

i think they deprecate that functionallity or something

XD i found the answer here:
http://enlightensoft.wordpress.com/2011/07/01/how-to-resolve-org-hibernate-queryexception-for-delete-hql-query/

Johnson02 · **Joined:** Thu Dec 20, 2012 11:11 pm **Posts:** 6

Thank you, I think I still have many problems going to improve