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]
