Dear Hibernate users, i am doing an example on <one-to-many> relationship. but i have got the following error:

Hibernate: insert into vendor (vname, vno) values (?, ?)
Hibernate: update customer set cname=?, vid=? where cid=?
org.hibernate.HibernateException:SQL insert, update or delete failed (row not found)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:25)
at org.hibernate.persister.BasicEntityPersister.update(BasicEntityPersister.java:1693)
at org.hibernate.persister.BasicEntityPersister.update(BasicEntityPersister.java:1851)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:58)
at org.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:1224)
at org.hibernate.event.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:517)
at org.hibernate.event.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1191)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
at Client2.main(Client2.java:39)

in the database no data is inserted either parent's or child's. i am pasting both hbm files and client code. please help me. thanks in advance:

vendor.hbm.xml(parent)
----------------------
<class name="VendorPojo" table="vendor">
<id name="vendorno" column="vno">
<generator class="assigned"/>
</id>
<property name="vendorname" column="vname" length="10"/>
<set name="children" cascade="all">
<key column="vid"/>
<one-to-many class="CustomerPojo"/>
</set>
</class>

customer.hbm.xml(child)
-----------------
<class name="CustomerPojo" table="customer">
<id name="customerid" column="cid">
<generator class="assigned"/>
</id>
<property name="customername" column="cname" length="10"/>
<property name="vendorid" column="vid"/>
</class>

Client2.java
-----------
VendorPojo v = new VendorPojo();
v.setVendorno(new Integer(111));
v.setVendorname("krishna");

CustomerPojo c1 = new CustomerPojo();
c1.setCustomerid(new Integer(100));
c1.setCustomername("k1");

CustomerPojo c2 = new CustomerPojo();
c2.setCustomerid(new Integer(200));
c2.setCustomername("k2");

Set s = new HashSet();
s.add(c1);
s.add(c2);

v.setChildren(s);

Transaction tx = ses.beginTransaction();
ses.save(v);
tx.commit();
ses.close();

Hi krishnamohan,

you might want to have a look at the Transitive persistence section of the Hibernate online documentation.

CU
Froestel

P.S.: Your code snippets would be easier to read if you'd use the BBCode functionality and enclose code in code-tags.