one to many issue

gbattinelli · **Joined:** Sun Jan 30, 2011 8:14 am **Posts:** 24

Dear all,
I've a question for you.
I've to implement with annotation a one to many relation between object paziente and another object.
I post some code.
When I add a Paziente object, other object is saved, but foreign key (paziente_id) is always null.
I missed something with foreign key.
Could you help me?

Code:

public class Paziente implements java.io.Serializable{
    @Id
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    @Column(name = "ID_PAZIENTE")
    private long    idPaziente;
    @OneToOne(cascade = CascadeType.ALL)
    @JoinColumn(name="ID_ANAGRAFICA")
    private pzAnagrafica            cAnagrafica;

    [b]@OneToMany(mappedBy="paziente_fk",cascade = CascadeType.ALL)
    private Set<pzAnamnFisioAllergia> allergie = new HashSet<pzAnamnFisioAllergia>(0);

    public Set<pzAnamnFisioAllergia> getAllergie() {
        return this.allergie;
    }
    public void setAllergie(Set<pzAnamnFisioAllergia> allergie) {
        this.allergie = allergie;[/b]
    }

    public Paziente() {
    }
     
}

Code:

@Entity
@Table(name = "an_fis_allergia")

public class pzAnamnFisioAllergia implements java.io.Serializable{
    @Id
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    @Column(name = "ID_ALLERGIA")
    private long        idAllergia;
     @ManyToOne
    @JoinColumn(name="paziente_fk", insertable=false, updatable=false)
    private Paziente paziente_fk;


    public Paziente getPaziente()
    {
        return paziente_fk;
    }

could you help me?
Where I'm going wrong?
In the child table, my parent is always NULL...

Thanks

gbattinelli · **Joined:** Sun Jan 30, 2011 8:14 am **Posts:** 24

no one can help me?
I'm not able to have a value different from null in my foreign key...

raul.bena · **Joined:** Fri Dec 15, 2006 4:24 am **Posts:** 8

I already have a similar problem...

Lets try to solve it toguether.

overmeulen · **Joined:** Fri Jan 28, 2011 11:44 am **Posts:** 117

Can you post the code where you are creating and saving the object ?

gbattinelli · **Joined:** Sun Jan 30, 2011 8:14 am **Posts:** 24

Set<pzAnamnFisioAllergia> cAllergie = new HashSet<pzAnamnFisioAllergia>(0);
for (int j = 0; j < cRows.size(); j++) {

//do some logic
cAllergie.add(cAllergia);

}
cPaziente.setAllergie(cAllergie);

gbattinelli · **Joined:** Sun Jan 30, 2011 8:14 am **Posts:** 24

sorry...in the previous post reply was not correct and I can't edit it.
This is my logic to save this set in my cPaziente Object

Code:

Set<pzAnamnFisioAllergia> cAllergie = new HashSet<pzAnamnFisioAllergia>(0);
            for (int j = 0; j < cRows.size(); j++) {
                Allergia all = new Allergia();
                 //do some logic                
                cAllergie.add(cAllergia);

            }
            cPaziente.setAllergie(cAllergie);
            PazienteMng.create(cPaziente);

where

Code:

protected void create(Paziente cPaz) {
        try {
            startOperation();
            session.saveOrUpdate(cPaz);
            tx.commit();

        } catch (HibernateException e) {
            handleException(e);
        } finally {
            HibernateFactory.close(session);
        }
    }

             

that is, in few words, I create and fill collection of childs, I set collection for parent and I save parent.

Where I'm going in error?

Thanks, please help me

overmeulen · **Joined:** Fri Jan 28, 2011 11:44 am **Posts:** 117

Do you set the paziente_fk property for each pzAnamnFisioAllergia of your collection ?

gbattinelli · **Joined:** Sun Jan 30, 2011 8:14 am **Posts:** 24

yes...at leaast I think....I do

Code:

Paziente cPaziente = new Paziente();
cPaziente .setName("Michael Best");
Set<pzAnamnFisioAllergia> cAllergie = new HashSet<pzAnamnFisioAllergia>(0);
            for (int j = 0; j < cRows.size(); j++) {
                Allergia all = new Allergia();
                all.set(....)
                all.setPaziente_fk(cPaziente);
                 //do some logic                
                cAllergie.add(cAllergia);

            }
            cPaziente.setAllergie(cAllergie);
            PazienteMng.create(cPaziente);

I do it with

Code:

all.setPaziente_fk(cPaziente);

but at that point cPaziente is not yet saved...cause I save it at the end...is this the problem?
What can I do?
Thanks very much for your helpe..

raul.bena · **Joined:** Fri Dec 15, 2006 4:24 am **Posts:** 8

I solved my problem, It was a insertable=false, updatable=false issue.

Looks that you too have it in your code

gbattinelli · **Joined:** Sun Jan 30, 2011 8:14 am **Posts:** 24

Ok thanks...I solved following your help and setting true either to insert and update.
There is still an issue...when I try to update parente (with its child), child row are duplicated...that is if I change a property of child 1, child1 property is duplicated...
can someone help me?
Maybe it's caused by cascade all in the parent object?
I tried to change it, but only with cascade all is sets a parent different from null..
I hope someone can help me

gbattinelli · **Joined:** Sun Jan 30, 2011 8:14 am **Posts:** 24

no one can help me?

ed1122 · **Joined:** Thu May 05, 2011 4:45 am **Posts:** 3

I solved following your help and setting true either to insert and update.