posted 17 years ago
Hi friends,
Using CMP ,I am trying to delete a record from database ,but While deleting a record from database (first i deleted foreign key in the table and then i deleted primary key)the following exception i am getting,
javax.transaction.TransactionRolledbackException: CORBA TRANSACTION_ROLLEDBACK 0x0 No; nested exception is:
org.omg.CORBA.TRANSACTION_ROLLEDBACK: javax.transaction.TransactionRolledbackException: ; nested exception is:
java.sql.SQLException: A parent row cannot be deleted because the relationship "NEWDESIGN.USER_ROLE_MAP.URM_FK" restricts the deletion.DSRA0010E: SQL State = 23504, Error Code
can you help me out.