I have some relations:
DVDProjectLocal has: Collection getMasterSets(); which is a 1-m relation to my MasterSetBean EJB MasterSetLocal has: Collection getSubtitleLanguages(); which is a 1-m realtion to my SubtitleLanguageBean EJB now im trying to make a ejb-ql in my SubtitleBean so i can select all subtitles with the projectKey, here is my ejb-ql: * @ejb:finder * signature= "java.util.Collection findByProjectKey(java.lang.Integer projectKey)" * query =" SELECT OBJECT(sl) * FROM DVDProject AS p, IN (p.masterSets) AS ms, IN (ms.subtitleLanguages) AS sl * WHERE p.projectKey = ?1 * " is this right ?? i have some problems undestanding the x-doclet way to do the sql.... ------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ xdoclet-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/xdoclet-user
