Exception when trying to save object with one-to-many relati

oren · **Joined:** Wed Mar 03, 2004 6:38 am **Posts:** 26

I have 2 classes:

Code:

<hibernate-mapping package="com.bertrams.berteShop.domain">
    <class name="OrderHeader" table="REORDH">
    <id name="id" type="long" unsaved-value="0">
      <column name="RHORNO" sql-type="long" not-null="true"/>
      <generator class="assigned"/>
   </id>

   <map name="orderItems">
           <key column="ODORNO"/>
           <index column="ODISBN" type="string"/>
              <one-to-many class="OrderItem"/>
   </map>
    </class>
</hibernate-mapping>

<hibernate-mapping package="com.bertrams.berteShop.domain">
    <class name="OrderItem" table="REORDL">
   <composite-id name="id" class="OrderItemKey">
      <key-property name="number" type="long" column="ODORNO"/>
      <key-property name="customer" type="int" column="ODCUST"/>
      <key-property name="branch" type="int" column="ODBRCH"/>
      <key-property name="consumerId" type="string" column="ODCNSM"/>        
      <key-property name="isbn" type="string" column="ODISBN"/>        
   </composite-id>
    </class>
</hibernate-mapping>

when i try to save OrderHeader i see 2 sqls:
first: insert into REORDH.....
seconde: update REORDL....
but then there is an exception:

Code:

30:22,812 DEBUG BatcherImpl:241 - preparing statement
30:22,844 DEBUG LongType:46 - binding '111111' to parameter: 1
30:22,844 DEBUG Cascades:331 - id unsaved-value strategy NONE
30:22,844 DEBUG LongType:46 - binding '111111' to parameter: 3
30:22,844 DEBUG IntegerType:46 - binding '1111111' to parameter: 4
30:22,844 DEBUG IntegerType:46 - binding '1' to parameter: 5
30:22,906 ERROR SessionImpl:2343 - Could not synchronize database state with session
net.sf.hibernate.HibernateException: SQL insert, update or delete failed (row not found)

Any idea why update sql and not insert to REORDL and why there is exception?

anthony · **Posted:** Tue Mar 16, 2004 1:49 pm

seeing your previous post and this one, it seems your hibernate session management is not good

oren · **Joined:** Wed Mar 03, 2004 6:38 am **Posts:** 26

delpouve wrote:

seeing your previous post and this one, it seems your hibernate session management is not good

but it is all happening in one session:

Code:

Session s = sessionFactory.openSession();
Transaction t = s.beginTransaction();
s.save(order);
t.commit();
s.close();

I thought by usin openSession i always get a new session.

oren · **Joined:** Wed Mar 03, 2004 6:38 am **Posts:** 26

delpouve wrote:

seeing your previous post and this one, it seems your hibernate session management is not good

When i put inverse="true" on the map the header is saved but not the items.

anthony · **Posted:** Tue Mar 16, 2004 2:06 pm

just take one hour to configure servletFilter, remove all session.close() (you may need to force it again in some cases) from your app, and you'll see many bugs will dissappear