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
Author

Database Circular Reference

Susan
Ranch Hand

Joined: Apr 26, 2005
Posts: 54
Hi,

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

thanks,

Susan
Paul Sturrock
Bartender

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: http://aspose.com/file-tools
 
subject: Database Circular Reference
 
It's not a secret anymore!