Hello, I allways used the deprecated delete(String) method when I needed to delete several object at once...

Now, to conform to the version 3 API, how must I do to achieve my goal ?

I thought it could be :

session.createQuery("FROM AND WHERE clauses").list().clear();

but it does not work (nothing is deleted from the database).

Is it a problem with my mapping that prevent objects to be deleted or is it because this way is the wrong way ?

Thank you

HQL now supports UPDATE/DELETE statements. There are some limitations with this currently, especially with anything relating to <join/>, <joined-subclass/>, or <union-subclass/>. But outside of those current restrictions, you'd do:


This is the EJB3 bulk operation stuff.

Okay, thank you Steve I understand the logic now... I tried with a simple statement but there is a problem :

hsession.createQuery("DELETE FROM Message WHERE id=?").setString(0,messageId).executeUpate();

Produce a NPE and a cryptic error during parsing :
*** ERROR: <AST>:0:0: unexpected end of subtree

java.lang.NullPointerException
at org.hibernate.hql.antlr.HqlSqlBaseWalker.path(HqlSqlBaseWalker.java:2193)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:2281)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2232)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:498)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.deleteStatement(HqlSqlBaseWalker.java:276)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:156)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:189)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:130)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:414)
at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:814)
at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:801)
at org.hibernate.impl.QueryImpl.executeUpate(QueryImpl.java:89)

Perhaps the error message can be improved.

try

Remove the "FROM" from your query string. See http://forum.hibernate.org/viewtopic.php?t=940351