Re: Inheritance and foreign keys

2006-07-13 Thread Vincent Frison
Le jeudi 2006 juillet 13 18:12, Thomas Dudziak a écrit : > Hi Vincent, > > the main problem that you have is that you cannot define a foreign key > that references TableA OR TableB. That's my problem. It doesn't seem very exotic.. > Basically if you want to have database foreign keys (and if your

Re: Inheritance and foreign keys

2006-07-13 Thread Thomas Dudziak
Hi Vincent, the main problem that you have is that you cannot define a foreign key that references TableA OR TableB. Basically if you want to have database foreign keys (and if your OJB app is the only user of the database, then you don't need to, OJB handles the referencial integrity itself), t

Re: Inheritance and foreign keys

2006-07-13 Thread Vincent Frison
Le mercredi 2006 juillet 12 18:22, Vincent Frison a écrit : > Hi all, > > I have a class A referencing another class B. My code (and database) works > fine for a long time but now I have to do some major changes to my app: > class A must reference class B OR class C. These two classes should share