Hibernate version:
2.1.6

Mapping documents:

EmisoTarjeta.hbm.xml

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

<hibernate-mapping package="cr.go.ice.vep.domain" auto-import="true">
<class name="EmisorTarjeta" table="EMISORTARJETA">
<id column="IDEMISORTARJETA" name="idEmisorTarjeta" type="integer" unsaved-value="null">
<generator class="sequence">
<param name="sequence">IDEMISORTARJETA_SQ</param>
</generator>
</id>
<property column="DESCRIPCION" length="25" name="descripcion" not-null="true" type="string" />
<property column="OBSERVACIONES" length="50" name="observaciones" not-null="false" type="string" />
<property column="ESTADO" length="1" name="estado" not-null="true" type="integer" />

<set name="recaudadores" table="RECAUDADOREMISORTARJETA" lazy="true">
<key column="IDEMISORTARJETA" />
<many-to-many class="Recaudador" column="IDRECAUDADOR" />
</set>
</class>
</hibernate-mapping>

Recaudador.hbm.xml

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

<hibernate-mapping package="cr.go.ice.vep.domain" auto-import="true">
<class name="EmisorTarjeta" table="EMISORTARJETA">
<id column="IDEMISORTARJETA" name="idEmisorTarjeta" type="integer" unsaved-value="null">
<generator class="sequence">
<param name="sequence">IDEMISORTARJETA_SQ</param>
</generator>
</id>
<property column="DESCRIPCION" length="25" name="descripcion" not-null="true" type="string" />
<property column="OBSERVACIONES" length="50" name="observaciones" not-null="false" type="string" />
<property column="ESTADO" length="1" name="estado" not-null="true" type="integer" />

<set name="recaudadores" table="RECAUDADOREMISORTARJETA" lazy="true">
<key column="IDEMISORTARJETA" />
<many-to-many class="Recaudador" column="IDRECAUDADOR" />
</set>
</class>
</hibernate-mapping>


Code between sessionFactory.openSession() and session.close():

Using Spring's HibernateDaoSupport:

public final void modificarEmisorTarjeta(final EmisorTarjeta emisorTarjeta) {
getHibernateTemplate().update(emisorTarjeta);
}

Full stack trace of any exception that occurs:

Name and version of the database you are using:

Oracle 9i

The generated SQL (show_sql=true):

hibernate: update EMISORTARJETA set DESCRIPCION=?, OBSERVACIONES=?, ESTADO=? where IDEMISORTARJETA=?
hibernate: delete from RECAUDADOREMISORTARJETA where IDEMISORTARJETA=?

Debug level Hibernate log excerpt:

EmisorTarjeta has a many-to-many relationship with Recaudador (table EMISORTARJETARECAUDADOR). When i update any information on EmisorTarjeta hibernate delete the relationship (in table EMISORTARJETARECAUDADOR) betwen the two objects

i only want to delete the relatioship if i delete emisorTarjeta

any idea ???

thanks
Ignacio

look at cascade in the reference guide

i have allready read and try all types of cascade (save-update, delete, none) but none of this work .... i really dont know what happend

Thanks
Ignacio

the problem was that i have to set one side of the many-to-many relationship to inverse="true"

<set inverse="true" name="recaudadores" table="RECAUDADOREMISORTARJETA" lazy="true">
<key column="IDEMISORTARJETA" />
<many-to-many class="Recaudador" column="IDRECAUDADOR" />
</set>

now everything works ok

if you have this problem read

http://www.hibernate.org/155.html

thanks
Ignacio