Hibernate Community • View topic - @ManyToMany with Map problem

View unanswered posts | View active topics

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

@ManyToMany with Map problem

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

Jorge Ayala

Post subject: @ManyToMany with Map problem

Posted: Wed Nov 14, 2007 4:00 pm

Newbie

Joined: Wed Nov 14, 2007 3:24 pm
Posts: 1
Location: México City

Hi:

I´m adding annotations to a project that used XDoclet, and I´m having trouble migrating a many to many association from XML to annotations.

This is a extract from my POJO without annotations:

Code:

**
 * @hibernate.class 
 *   table="SEGU_COLECCION_FACULTADES"
 *   proxy="com.bursatec.seguridad.persistence.model.ColeccionFacultades"
 */
public class ColeccionFacultadesImpl implements ColeccionFacultades {

    private static final long serialVersionUID = 1L;
    /**
     * El identificador de la colecci&oacute;n de facultades
     */
    private Long id;
    /**
     * Mapa de las facultades asociadas
     */
    private Map facultades;
    
    public Map getFacultades() {
        return this.facultades;
    }

    public void setFacultades(Map facultades) {
        this.facultades = facultades;
    }...

And here is the POJO with annotations

Code:

@Entity
@Inheritance(strategy = InheritanceType.JOINED)
@Table(name = "SEGU_COLECCION_FACULTADES")
@SequenceGenerator(name = "foliador", sequenceName = "SEQ_SEGU_COLECCION_FACULTADES")
public class ColeccionFacultadesImpl implements ColeccionFacultades {
    @Transient
    private static final long serialVersionUID = 1L;
    /**
     * El identificador de la colecci&oacute;n de facultades
     */
    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "foliador")
    @Column(name = "ID_COL")
    private Long id;
    /**
     * Mapa de las facultades asociadas
     */
    @MapKey( name = "nombre")
    @ManyToMany(targetEntity = com.bursatec.seguridad.persistence.model.impl.FacultadImpl.class, cascade = {CascadeType.ALL})
    @JoinTable(name = "SEGU_FACULTAD_COLECCION", joinColumns = {@JoinColumn(name = "ID_COL")}, inverseJoinColumns = {@JoinColumn(name = "ID_FACULTAD")})
    @IndexColumn(name = "FACULTAD_KEY", nullable = false, columnDefinition="VARCHAR2 NOT NULL")
    private Map facultades;
...

In the XDoclet version, the association is mapped with this file:

The table "SEGU_FACULTAD_COLECCION" has a not nullable column named "FACULTAD_key", in the XDoclet version it works fine inserting the right values in the db, as the following log shows:

But in the annotations version the "FACULTAD_key" column is ignored and an exception is raised:

The value of the Map is assigned in child classes of the POJO (in the addFacultad method):

Code:

@Entity
@Table(name = "SEGU_ROL")
@PrimaryKeyJoinColumn(name = "ID_COL")
public class RolImpl extends ColeccionFacultadesImpl implements Rol {
   
   
    @Column(name = "NOMBRE", length = 20)
    private String nombre;
   
   
    public String getNombre() {
        return this.nombre;
    }
   
    public void setNombre(String nombre) {
        this.nombre = nombre;
    }
   
   
    public void addFacultad(Facultad facultad) {
       if(this.getFacultades() == null) {
          this.setFacultades(new HashMap());
       }
       this.getFacultades().put(facultad.getNombre(), facultad);
    }
}

This is my configuration:

Hibernate Core 3.2.2.ga
Annotations 3.3.0.ga
Oracle Dialect

I´ve been looking in the documentation and the forums for a couple of days, I believe the the "translated" mapping is right (but maybe I´m wrong) since I can retrieve the Map from a test case that selects it, the problem is in the insertion part.

Any help would be apreciated.

Top

tiggy

Post subject:

Posted: Tue Mar 11, 2008 10:26 am

Beginner

Joined: Fri Oct 06, 2006 2:49 am
Posts: 25

Hello Jorge,

I have currently the same problem as you, except that for me the map is a collectionOfElements

Code:

@CollectionOfElements(fetch=FetchType.LAZY, targetElement=MyClazz.class)
    @JoinTable(name="join_table", joinColumns={@JoinColumn(name="mycol_id")})
    @org.hibernate.annotations.MapKey(columns=@Column(name="mykey"), targetElement=MyClazz.class)
    @IndexColumn(name = "position", base = 0)

did you find a workaround for this (other than to use a list ;) )?

Thx a lot,
Tiggy[/code]

Top

Page 1 of 1

[ 2 posts ]

Board index » Projects » Search, Validator, Shards

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum