This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes Database Circular Reference Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Database Circular Reference" Watch "Database Circular Reference" New topic

Database Circular Reference

Ranch Hand

Joined: Apr 26, 2005
Posts: 54

could somebody please explain what a database circular reference is, and what design shortcomings it has?


Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Table A has an FK to Table B. Table B has an FK to Table A. If I try to delete a record from Table A the delete will fail, because the record is referenced in Table B. If I try to delete a record from Table B the delete will fail because the record is referenced in Table A.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link:
subject: Database Circular Reference
It's not a secret anymore!