Hibernate version: 3.2.2

Mapping documents:
<hibernate-mapping
>
<class
name="com.seqis.kltm.model.db.project.logging.ProjectKLTMLog"
table="kltm_log"
>

<id
name="objectId"
column="object_id"
type="long"
>
<generator class="native">
</generator>
</id>

<list
name="values"
table="kltm_log_values"
lazy="false"
cascade="all"
>

<key
column="log_id"
>
</key>

<index
column="sequence"
/>

<element
column="value"
type="text"
not-null="false"
unique="false"
length="2147483647"
/>

</list>
</class>

</hibernate-mapping>


Full stack trace of any exception that occurs:
18.12.2007 17:40:50 org.hibernate.util.JDBCExceptionReporter logExceptions
WARNUNG: SQL Error: 547, SQLState: 23000
18.12.2007 17:40:50 org.hibernate.util.JDBCExceptionReporter logExceptions
SCHWERWIEGEND: Die DELETE-Anweisung verstieß gegen die COLUMN REFERENCE-Einschränkung 'FK7BDAC42DE4A9234'. Der Konflikt trat in der wl4_kltm_hibernate-Datenbank, Tabelle 'kltm_log_values', column 'log_id' auf.
org.hibernate.exception.ConstraintViolationException: could not execute update query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:84)
at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:396)
at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:259)
at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1141)
at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:94)
at com.seqis.kltm.model.dbconn.LogActionCleaner.run(LogActionCleaner.java:45)
Caused by: java.sql.SQLException: Die DELETE-Anweisung verstieß gegen die COLUMN REFERENCE-Einschränkung 'FK7BDAC42DE4A9234'. Der Konflikt trat in der wl4_kltm_hibernate-Datenbank, Tabelle 'kltm_log_values', column 'log_id' auf.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:367)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:505)
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:75)
... 5 more
org.hibernate.exception.ConstraintViolationException: could not execute update query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:84)
at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:396)
at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:259)
at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1141)
at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:94)
at com.seqis.kltm.model.dbconn.LogActionCleaner.run(LogActionCleaner.java:45)
Caused by: java.sql.SQLException: Die DELETE-Anweisung verstieß gegen die COLUMN REFERENCE-Einschränkung 'FK7BDAC42DE4A9234'. Der Konflikt trat in der wl4_kltm_hibernate-Datenbank, Tabelle 'kltm_log_values', column 'log_id' auf.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:367)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:505)
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:75)
... 5 more

Name and version of the database you are using: MSSQL Server 2000 8.00.194

The generated SQL (show_sql=true):

Hibernate:
delete
from
kltm_log
where
object_id in (
select
logs2_.object_id
from
kltm_log_action projectklt1_,
kltm_log logs2_
where
projectklt1_.object_id=logs2_.log_action_id
and (
projectklt1_.referenced_object_id is null
)
)

i want to delete a view objects of the type ProjectKLTMLog. each ProjectKLTMLog has a list of strings, so hibernate creates a second table to store the items of the list. now i if i execute the hql:
delete ProjectKLTMLog log where log.id in (...) the sql query above is executed. but the table with the strings is not included in this sql query.
does anyone know how to delete this kind of objects with an hql query?

cascade deletes?

hi,



this is the mapping of the string list. i dont use session.delete(), instead i want to delete the objects directly in the database ->
session.createyQuery("delete ProjectKLTMLog log where log.id in (...)").executeUpdatee();
As far is i understand the cascade option of the hbm.xml mapping is not used with hql delete.
session.delete() works fine with cascading, but i dont want to load the objects if i can delete them directly in the database with a simple hql.

If you want deletes to cascade in the database you have to tell your database in the appropriate foreign key definition to do so. If you want cascading deletes not based on foreign keys to execute in the database you would need to define appropriate triggers.

thx, i added on-delete=cascade so a foreign key with cascading deletion is created. that works fine for me.