Hi Thomas, The example we have is related to the handling of royalties in the music industry. We have the following 3 tables for which we need a ternary association.
WORKS MEMBERS SHARES A work has a number of members associated with it each of which has a share in the work. (Or looking at it the other direction a member has a share in a number of works). Our bridge (association) table would have 3 columns storing foreign keys into these 3 tables. The sort of queries we would need would be 1. Find all members associated with a work and the share they have. 2. Find all works a member has a share in (and what that share is for each work). Regards, John -----Original Message----- From: Mahler Thomas [mailto:[EMAIL PROTECTED] Sent: 04 March 2003 16:16 To: 'OJB Users List' Subject: RE: Ternary associations Hi John, How das do your object model and the respective table look like. Please give some details, so that I can try to answer. thanks, Thomas > -----Original Message----- > From: O'Reilly John [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 04, 2003 4:58 PM > To: 'OJB Users List' > Subject: RE: Ternary associations > > > Hi, > > Sorry to repost the following question but can someone give > me a yes/no > answer on this. If no, then we need to look for another way > of doing this. > > Thanks, > John > > > -----Original Message----- > From: O'Reilly John [mailto:[EMAIL PROTECTED] > Sent: 26 February 2003 16:59 > To: 'OJB Users List' > Subject: Ternary associations > > > Hi, > > According to the following, OJB is supposed to support > ternary associations: > http://c2.com/cgi-bin/wiki?ObjectRelationalToolComparison > > I can't find any info on this. Is it actually supported? > > Thanks, > John > ************************************************************** > ********** > This e-mail and any files transmitted with it are > confidential and may be > privileged and are intended solely for the individual named/ > for the use of > the individual or entity to whom they are addressed.If you are not the > intended addressee, you should not disseminate, distribute or > copy this > e-mail.Please notify the sender immediately if you have > received this e-mail > by mistake and delete this e-mail from your system.If you are not the > intended recipient, you are notified that reviewing, > disclosing, copying, > distributing or taking any action in reliance on the contents > of this e-mail > is strictly prohibited.Please note that any views or opinions > expressed in > this e-mail are solely those of the author and do not > necessarily represent > those of Traventec Limited.E-mail transmission cannot be > guaranteed to be > secure or error-free as information could be intercepted, > corrupted, lost, > destroyed, or arrive late or incomplete.Traventec Limited > therefore does not > accept liability for any errors or omissions in the contents of this > message, which arise as a result of e-mail transmission.The > recipient should > check this e-mail and any attachments for the presence of viruses.This > e-mail has been swept for computer viruses however Traventec > Limited accepts > no liability for any damage caused by any virus transmitted > by this e-mail. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > ************************************************************** > ********** > This e-mail and any files transmitted with it are > confidential and may be > privileged and are intended solely for the individual named/ > for the use of > the individual or entity to whom they are addressed.If you are not the > intended addressee, you should not disseminate, distribute or > copy this > e-mail.Please notify the sender immediately if you have > received this e-mail > by mistake and delete this e-mail from your system.If you are not the > intended recipient, you are notified that reviewing, > disclosing, copying, > distributing or taking any action in reliance on the contents > of this e-mail > is strictly prohibited.Please note that any views or opinions > expressed in > this e-mail are solely those of the author and do not > necessarily represent > those of Traventec Limited.E-mail transmission cannot be > guaranteed to be > secure or error-free as information could be intercepted, > corrupted, lost, > destroyed, or arrive late or incomplete.Traventec Limited > therefore does not > accept liability for any errors or omissions in the contents of this > message, which arise as a result of e-mail transmission.The > recipient should > check this e-mail and any attachments for the presence of viruses.This > e-mail has been swept for computer viruses however Traventec > Limited accepts > no liability for any damage caused by any virus transmitted > by this e-mail. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ************************************************************************ This e-mail and any files transmitted with it are confidential and may be privileged and are intended solely for the individual named/ for the use of the individual or entity to whom they are addressed.If you are not the intended addressee, you should not disseminate, distribute or copy this e-mail.Please notify the sender immediately if you have received this e-mail by mistake and delete this e-mail from your system.If you are not the intended recipient, you are notified that reviewing, disclosing, copying, distributing or taking any action in reliance on the contents of this e-mail is strictly prohibited.Please note that any views or opinions expressed in this e-mail are solely those of the author and do not necessarily represent those of Traventec Limited.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, or arrive late or incomplete.Traventec Limited therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission.The recipient should check this e-mail and any attachments for the presence of viruses.This e-mail has been swept for computer viruses however Traventec Limited accepts no liability for any damage caused by any virus transmitted by this e-mail. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
