----- Original Message ----- From: "Oliver" <[EMAIL PROTECTED]> To: "'OJB Users List'" <[EMAIL PROTECTED]> Sent: Saturday, June 19, 2004 5:26 PM Subject: Subtle mapping on multiple joined tables <SNIP>
> Tables: > A_TABLE with aID, > B_TABLE with bID and aID(foreignkey to A_TABLE), > C_TABLE with cID and bID(foreignkey to B_TABLE) > > First problem and question: > OJB needs a reference from C to A, which is defined in > class-descriptor for B and cant be defined > in C, because there is no column with a foreignkey to A in C_TABLE. > Is that right? How can we solve this? > Can't you have the primary key of C also be the foreign key to B? This way you only have 1 key column. Just a thought... -Stijn --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
