I am using hibernate 3.0.5 with MSSQL Server 2005.

I have a table with the following xml :

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
<class name="com.hp.ov.amx.persistence.ConfigProfile" table="AMX_CONFIG_PROFILE">

<!-- Primary keys -->
<!-- NOTE - We do not need a primary key on this table,
this one is for hibernate
-->
<id name="id" type="long" column="CONFIG_PROFILE_ID">
<generator class="native" />
</id>


<!-- Foreign keys - other tables are dependent on columns this table -->
<many-to-one name="serviceGroup"
class="com.hp.ov.amx.persistence.ServiceGroup">
<column name="SERVICE_GROUP_UUID" not-null="true" length="32" sql-type="char(32)"/>
</many-to-one>

<many-to-one name="service"
class="com.hp.ov.amx.persistence.Service">
<column name="SERVICE_UUID" not-null="false" length="32" sql-type="char(32)"/>
</many-to-one>

<many-to-one name="profile" class="com.hp.ov.amx.persistence.Profile">
<column name="PROFILE_ID" not-null="true"/>
</many-to-one>

</class>
</hibernate-mapping>

I am trying to run the following bulk delete query :

Query configProfileDeleteQuery = session.createQuery(
"delete ConfigProfile cP where cP.profile.id = :prId "); configProfileDeleteQuery.setParameter("prId", new Long(10)); configProfileDeleteQuery.executeUpdate();

I get the following QuerySyntax Error :

org.hibernate.hql.ast.QuerySyntaxError: unexpected token: cP near line 1, column 22 [delete ConfigProfile cP where cP.profile.id = :prId ]
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:63)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:215)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:127)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:427)
at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:884)
at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:865)
at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:89)



Please help.

regards
-Sarab

try with this:

Same problem. The query parser complains about the token "cP".


g.hibernate.hql.ast.QuerySyntaxError: unexpected token: cP near line 1, column 53 [delete from com.hp.ov.amx.persistence.ConfigProfile cP where exists ( from com.hp.ov.amx.persistence.Profile p where p = cP.profile and p.id = :prId ) ]
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:63)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:215)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:127)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:427)
at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:884)


-Sarab

use this , just remove cP



I'm 100% sure it'll work.

A different error this time :

caused by: com.inet.tds.ao: Msg 4104, Level 16, State 1, Line 1, Sqlstate 01000
[ROS80965TST-VM1]The multi-part identifier "configprof0_.CONFIG_PROFILE_ID" could not be bound.
at com.inet.tds.al.a(Unknown Source)
at com.inet.tds.h.a(Unknown Source)
at com.inet.tds.h.a(Unknown Source)
at com.inet.tds.q.f(Unknown Source)
at com.inet.tds.q.executeUpdate(Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at org.hibernate.hql.ast.UpdateStatementExecutor.execute(UpdateStatementExecutor.java:76)

-Sarab

I believe the DML style bulk updates are not available for Hibernate3.0.5.