bi-directional one-to-many - HOW TO DELETE??? (ANNOTATIONS)

mikolaj64 · **Joined:** Thu Mar 19, 2009 6:30 pm **Posts:** 7

Hi, I have 2 classes in bidirectional one-to-many relation. User:

Code:

@Entity
@Table(name="users")
public class User implements Serializable {

    @Id
    @GeneratedValue
    private long id;

    @Column(name="name", length=50, nullable=false)
    private String name;

    @Column(name="password", length=20, nullable=false)
    private String password;

    //fetch is eager, as it is almost sure that notes list will be needed
    @OneToMany(cascade=CascadeType.ALL, fetch=FetchType.EAGER, mappedBy="author")
    @JoinColumn(name="user_id")
    private List<Note> notes;

and Note:

Code:

@Entity
@Table(name="notes")
public class Note implements Serializable {

    @Id
    @GeneratedValue
    private long id;

    @Column(name="date")
    @Temporal(TIMESTAMP)
    private Date date;

    @Column(name="content")
    private String content;

    @ManyToOne
    @JoinColumn(name="user_id")
    private User author;

How can I remove some note? I was trying this way:

Code:

session.beginTransaction();
            User user = Utils.getLoggedUser();
            Note note = (Note)session.get(Note.class, id);
            if(user.getNotes().contains(note)) {
                user.getNotes().remove(note);
                session.update(user);
            }

But it doesn't work!!! I was trying many ways like:
session.delete(note), and other combinations. Nothing helps so far. Even this:

Code:

@Cascade(CascadeType.DELETE_ORPHAN)
    @OneToMany(cascade=javax.persistence.CascadeType.ALL, fetch=FetchType.EAGER, mappedBy="author")
    @JoinColumn(name="user_id")
    private List<Note> notes;

mikolaj64 · **Joined:** Thu Mar 19, 2009 6:30 pm **Posts:** 7

PLEASE HELP!!! Does anybody was deleting object from bidirectional oneToMany relation?

littypreethkr · **Posted:** Thu Mar 26, 2009 4:05 am

Are you getting any exceptions?

nordborg · **Posted:** Thu Mar 26, 2009 4:32 am

Have you tried to add a cascade option for DELETE_ORPHAN as described in http://www.hibernate.org/hib_docs/annot ... ec-cascade

mikolaj64 · **Joined:** Thu Mar 19, 2009 6:30 pm **Posts:** 7

Now it finally works (almost). Note can be deleted now, but when I try to add another note I get exception:

Batch update returned unexpected row count from update [1]; actual row count: 0; expected: 1

When I log out and log in again I can add another notes, until I delete one.

Can you help me?

mikolaj64 · **Joined:** Thu Mar 19, 2009 6:30 pm **Posts:** 7

my solution:

Code:

session.update(user);
session.flush();
session.refresh(user);