hello,

I try to make a one-to-many association from a class to itself but
I got an error described at the end of this mail.

Here is a part of the code of the class :


------JAVA -----------
public class Keyword {

protected Set MyKeyWords;
.........................................
.........................................
}
------JAVA -----------

,here is a part of main code :

-----JAVA---------------
Set myset = new HashSet();

Keyword kw1 = new Keyword( );
myset.add(kw1);

Keyword kw2 = new Keyword( );
myset.add(kw2);

kw = new Keyword( );
kw.setMyKeyWords(myset);

session.save( kw );
..........................................
.........................................

-----JAVA---------------


,here is ly mapping file :


-----MAPPING---------------

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

<hibernate-mapping>

<class name="hb.Keyword"
table="keywords">

<id name="id"
type="integer"
column="id"
unsaved-value="null">
<generator class="identity"/>
</id>

<set name="MyKeyWords">
<key column="clef_keyword"/>
<one-to-many class="hb.Keyword"/>
</set>

</class>
</hibernate-mapping>
-----MAPPING---------------

When I execute the code, I got the following error :

[java] Hibernate: insert into keywords (NAME) values (?)
[java] Hibernate: select @@identity
[java] Hibernate: update keywords set NAME=? where id=?
[java] net.sf.hibernate.HibernateException: SQL update or deletion failed (row not found)
[java] at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(Unknown Source)
[java] at net.sf.hibernate.persister.EntityPersister.update(Unknown Source)
[java] at net.sf.hibernate.persister.EntityPersister.update(Unknown Source)
[java] at net.sf.hibernate.impl.ScheduledUpdate.execute(Unknown Source)
[java] at net.sf.hibernate.impl.SessionImpl.executeAll(Unknown Source)
[java] at net.sf.hibernate.impl.SessionImpl.execute(Unknown Source)
[java] at net.sf.hibernate.impl.SessionImpl.flush(Unknown Source)
[java] at net.sf.hibernate.transaction.JDBCTransaction.commit(Unknown Source)
[java] at Main.main(Unknown Source)
[java] Java Result: 1

If I save kw1, kw2 and kw separately, It works. How to avoid to save kw1 and kw2 ?

Thanks a lot.

LF

Thank you epbernard for your quick reply but unfortunately it
doesn't work. The option cascade=save-update" has no effect....
I got always the same error.

Thank you for your help.

LF

I am also encountering similar problem...

Code:

16:17:01,988 ERROR [STDERR] net.sf.hibernate.HibernateException: SQL update or d
eletion failed (row not found)
        at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatche
r.java:25)
        at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.jav
a:642)
        at net.sf.hibernate.persister.EntityPersister.update(EntityPersister.jav
a:611)
        at net.sf.hibernate.impl.ScheduledUpdate.execute(ScheduledUpdate.java:31
)
        at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2100)
        at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2062)
        at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2005)
        at com.nielsenmedia.myEVNTS.server.ProcessEchoEJB.flushSession(ProcessEc
hoEJB.java:336)
        at com.nielsenmedia.myEVNTS.server.ProcessEchoEJB.testWithHibernate(Proc
essEchoEJB.java:172)

If we see my mapping file

ludofleur,



What is NAME? I see no such a property in your mapping...