Hi,

I have the following entity fields:

...
@Id
@GeneratedValue
@Column(name = "ID", nullable = false)
private Short id;
@Column(name = "NAME")
private String name;
@Column(name = "CATEGORY", nullable = false)
private int category;
@Column(name = "JPAQLSTATEMENT", nullable = false)
private String jpaqlstatement;
@OneToMany(cascade = CascadeType.ALL, mappedBy = "tblAdvFilter")
private List<TblAdvFilterRow> tblAdvFilterRowCollection =
new ArrayList<TblAdvFilterRow>();
@ManyToOne(cascade=CascadeType.ALL)
@JoinTable(name = "TBLADVFILTERUSER", joinColumns =
{@JoinColumn(name = "FILTERID")}, inverseJoinColumns =
{@JoinColumn(name = "USERID")})
private TblUser owner;

....

with this method I want to delete this entity instance from the database:

public void deleteAdvFilter(TblAdvFilter p_filter) throws SystemException {
try {
utx.begin();
TblAdvFilter filter = em.find(TblAdvFilter.class, p_filter.getId());
filter.getTblAdvFilterRowCollection().remove(filter);
em.remove(filter);
em.flush();
utx.commit();
} catch (Exception ex) {
utx.rollback();
logger.severe(MessageUtil.getMessage("error.advfilter.errorDeletingFilter") + ex.getMessage());
}
}


but the result is the following erro message:

deleted entity passed to persist: [......TblUser#<null>]

How do I correctly drop this instance, whats wrong.


Thanks for your advice!

you could add the annotation
@Cascade ({@Cascade({CascadeType.ALL,CascadeType.DELETE_ORPHAN}) })
to your @OneToMany and @ManyToOne attributes and then simply do :


@Id
@GeneratedValue
@Column(name = "ID", nullable = false)
private Short id;
@Column(name = "NAME")
private String name;
@Column(name = "CATEGORY", nullable = false)
private int category;
@Column(name = "JPAQLSTATEMENT", nullable = false)
private String jpaqlstatement;
@OneToMany(cascade = CascadeType.ALL, mappedBy = "tblAdvFilter")
@Cascade ({@Cascade({CascadeType.ALL,CascadeType.DELETE_ORPHAN}) })
private List<TblAdvFilterRow> tblAdvFilterRowCollection =
new ArrayList<TblAdvFilterRow>();
@ManyToOne(cascade=CascadeType.ALL)
@JoinTable(name = "TBLADVFILTERUSER", joinColumns =
{@JoinColumn(name = "FILTERID")}, inverseJoinColumns =
{@JoinColumn(name = "USERID")})
@Cascade ({@Cascade({CascadeType.ALL,CascadeType.DELETE_ORPHAN}) })
private TblUser owner;

....


public void deleteAdvFilter(TblAdvFilter p_filter) throws SystemException {
try {
utx.begin();
TblAdvFilter filter = utx.get(TblAdvFilter.class, p_filter.getId());
utx.delete(filter);
utx.commit();
} catch (Exception ex) {
utx.rollback();
logger.severe(MessageUtil.getMessage("error.advfilter.errorDeletingFilter") + ex.getMessage());
}