Query syntax error when bulk-deleting in Hibernate

Question

I try to executer bulk delete using Hibernate HQL query, following reference manunal but I get a query syntax error. This line ``` final Query qry = getSession(false).createQuery(" delete from NewCalendarDay"); ``` causes exception: org.hibernate.QueryException: query must begin with SELECT or FROM: delete [ delete from pl.com.bms.avaro.staticData.model.NewCalendarDay ] Class in which the code is executed extends `org.springframework.orm.hibernate3.support.HibernateDaoSupport`, so `getSession()` method should return `org.hibernate.Session`. I use spring v. 2.5.5 and Hibernate v. 3.2.6.ga Should I configure something to be able to bulk-delete or what? EDIT Bozho asked for complete stack trace, so here it goes: ``` org.hibernate.QueryException: query must begin with SELECT or FROM: delete [ delete from pl.com.bms.avaro.staticData.model.NewCalendarDay ] at org.hibernate.hql.classic.ClauseParser.token(ClauseParser.java:83) at org.hibernate.hql.classic.PreprocessingParser.token(Preprocessi…

Accepted Answer

Get rid of the leading whitespace for a start. Then execute the query using `query.executeUpdate()` Then, even if this works for you, I wouldn't advice using HQL to delete entities. In case they have any relations, these will not be cascaded and you will end up with inconsistencies. Select all objects and call `session.remove(entity)` on each. Of course, if you don't have any x-to-x relationships, you can proceed with the HQL, but be careful if you add such in the future. Update: you might be having something like this in your hibernate configurations: ``` org.hibernate.hql.classic.ClassicQueryTranslatorFactory ``` It makes Hibernate use the classic parser. Remove it and try again.

Query syntax error when bulk-deleting in Hibernate

Solution

Problem

Related problems