Hibernate: cascade save problem

[Sebastiaan Kortleven]

Hello all,

I've got my own Query object which consists of several WhereItem objects, which can consist of a Subquery object which consists of a Query object (not the same as the original), and so on..

So:

Query -> WhereItem -> Subquery -> Query -> ...

When saving the main Query, I woul like all the rest to be saved too..
I've set the cascade option to all for all collections, but I still get a TransientObjectException..

What am I doing wrong?

Here's part of the exception:

net.sf.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing: com.lmsintl.its.aqt.dto.Query
at net.sf.hibernate.impl.SessionImpl.throwTransientObjectException(SessionImpl.java:2768)
at net.sf.hibernate.impl.SessionImpl.getEntityIdentifierIfNotUnsaved(SessionImpl.java:2760)
at net.sf.hibernate.type.EntityType.getIdentifier(EntityType.java:66)
at net.sf.hibernate.type.EntityType.isDirty(EntityType.java:139)

Here are the relevant parts of the mapping files:

<hibernate-mapping>
    <class name="com.lmsintl.its.aqt.dto.Query" table="AQT_Query">
        <id name="row_id" column="row_id">
            <generator class="identity"/>
        </id>        
        <property name="name"/>
        <property name="description"/>
        <property name="loadable"/>
        <list name="whereitems" cascade="all">
            <key column="query_id"/>
            <index column="ordernr"/>
            <one-to-many class="com.lmsintl.its.aqt.dto.WhereItem"/>
        </list>
        
 
    </class>
</hibernate-mapping>
 
<hibernate-mapping>
    <class name="com.lmsintl.its.aqt.dto.WhereItem" table="AQT_Query_Where">
        <id name="row_id" column="row_id">
            <generator class="identity"/>
        </id>
        <many-to-one name="query" column="query_id"/>
        <property name="level" column="`level`"/>
        <property name="logicaloperator"/>
               
        <many-to-one name="leftsubquery" column="leftsubquery_id" cascade="all"/>
 
        <property name="operator"/>
        
        <many-to-one name="rightsubquery" column="rightsubquery_id" cascade="all"/>
 
    </class>
</hibernate-mapping>
 
<hibernate-mapping>
    <class name="com.lmsintl.its.aqt.dto.Subquery" table="AQT_Subquery">
        <id name="row_id" column="row_id">
            <generator class="identity"/>
        </id>
        <many-to-one name="query" column="query_id" cascade="all"/>        
        <property name="subquerynr"/>
    </class>
</hibernate-mapping>