[Hibernate] (no subject)

[Rob B. <rob...@ve...>]

Hello all,

If you are using Hibernate with ID's as the primary keys (i.e. not using business data as keys / composite keys) should the database have referential integrity, and if so, how much?

So:

1) If I have a parent child relationship, and in the DB the child has the parents key, should the RI of that relationship be enforced in the DB?

2) What about "business" referential integrity?  If I were doing things the "old way" and using the business data as keys, the DB would perform lots of RI checking to make sure only "valid" rows could be inserted (rows where the primary key / foriegn key relationships were correct).  Should these RI "rules" still be enforced in the database, or not?

Later
Rob