Jakob, I'm a bozo. It was operator error (again). The m:n stuff is working fine in both directions. I apologize for bothering you. Sincerely, MOD
--- Jakob Braeuchi <[EMAIL PROTECTED]> wrote: > hi michael, > > ojb handles non-decomposed m:n relationships > internally. there's no need > for you to deal with the intermediate table. > > jakob > > Michael Duffy wrote: > > >I have an m:n relationship between two > tables/classes > >A and B, modeled with an A_TO_B intermediate table > >in-between. > > > >I'd like to get all the instances of B associated > with > >a given A as a Collection. The SQL might look > like: > > > >SELECT * FROM B > >WHERE > >B.B_ID = A_TO_B.B_ID AND > >A_TO_B.A_ID = X; > > > >where X is the value of the A.A_ID that I want. > > > >Is Criteria.addEqualToColumn the right method, or > >should I just toss in raw SQL using SQLCriteria? > How > >do I get back the Collection if I use raw SQL? Any > >advice is most welcome. > > > >Also, the list is broken on the db.apache.org Web > >site. Notes younger than 24Feb2003 don't appear. > >Thanks - MOD > > > > > >__________________________________________________ > >Do you Yahoo!? > >Yahoo! Platinum - Watch CBS' NCAA March Madness, > live on your desktop! > >http://platinum.yahoo.com > > > >--------------------------------------------------------------------- > >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] > __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]