This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach 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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Database Circular Reference
 
Similar Threads
JButton Round Shape
Any way to overcome Circular Redirect using HttpClient 4.1.1
Circular Reference in Java
Khalid: GC ?
Hibernate delete exception