users@glassfish.java.net

_at_OnetoMany in JPA: Problem with remove/delete

From: <glassfish_at_javadesktop.org>
Date: Tue, 29 Jul 2008 06:40:05 PDT

Hi,

I am having two entities which are related with @OnetoMany and @JoinTable.
It is a uni-directional mapping with JoinTable and JoinColumn. I am facing the problem while removing the data from DAOclass which states as follows.

Internal Exception: java.sql.SQLException: ORA-02292: integrity constraint violated - child record found

The enitity classes are attached.

The remove/delete in DAO class is as follows.

public String deleteName(String selectedValuesID) {

String returnValue = ERROR_MSG;
long id = (long)Integer.parseInt(selectedValuesID);

PromptsSelections prSel = getJpaTemplate().find(PromptsSelections.class,id);
getJpaTemplate().remove(prSel);

returnValue = SUCCESS_MSG;
return returnValue;

}

Thanks in Advance.
[Message sent by forum member 'dinesh_kb' (dinesh_kb)]

http://forums.java.net/jive/thread.jspa?messageID=290067