Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cascade or delete in database server, why if my EJB do it for me??

843830Mar 14 2007 — edited Mar 15 2007
Hi,

I am in design phase of a database for my j2EE application. In the database desing i have some relationships entities, that have foreign keys. I have several options about foreign keys in the relationships, cascade deletes, restrict .... all in my database server.

But, when i am reading the referencial integrity of the entity EJBs CMP relationships, the entity beans make the cascade deletes automaticaly for maintain the relationsships.

Need i make my relationships in my database server with cascade delete options or leave it for my application server???

Another one, if i make relationships in my database server, why i need do it in my entity beans???

tanks, sorry for my poor english
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 12 2007
Added on Mar 14 2007
2 comments
163 views