aspose file tools*
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