Hello there, I use to declare my foreign key as constraints at the DB level (INTEGER REFERENCES "anotherTable" under PostgreSQL) which seems to be the very traditional way to do. But.. I get troubles with OJB.
For example, if I have a two classes, each of them do 1:1 mapping to the other one, and if I want to do some deleting on cascade (auto-delete="true"), referential integrity violations occur. But it shouldn't happen if the referenced object is deleted first! This is not the case? Actually I work around it by removing REFERENCES in my tables creations, adn deleting on cascade works fine. But maybe this is normal way since this is the work of OJB to manage the references. But there's no way to keep the DB level referential integrity? Vincent --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
