--- David Nielsen <[EMAIL PROTECTED]> wrote: > Oh, sorry in using jboss. > i dont want to use jbos specific ql (jboss-ql)
Well, I decided to throw entity beans alltogether and go for hibernate istead, but I'll try to help you So, you try to define relation language (n) - (m) region code - does CMR support n-m relations? > On Tue, 2003-10-07 at 15:04, Konstantin Priblouda > wrote: > > --- David Nielsen <[EMAIL PROTECTED]> wrote: > > > Hi there... > > > > > > I have 2 EJB's > > > > > > 1. LanguageBean > > > 2. DVDRegionCodesBean > > > > > > in LanguagesBean i have: > > > > > > /** > > > * @ejb.interface-method > > > * @ejb.relation > > > * name="Languages-DVDRegionCodes" > > > * role-name="Languages-Has-one-DVDRegionCode" > > > * target-ejb="DVDRegionCodes" > > > * > > > > > > target-role-name="DVDRegionCodes-belongs-to-Languages" > > > * target-cascade-delete="no" > > > * @jboss.relation > > > * related-pk-field="regionCode" > > > * fk-column="DVDREGION" > > > * fk-contraint="true" > > > */ > > > public abstract DVDRegionCodesLocal > getDVDRegion(); > > > > > > i then ty to make a finder that finds all > Languages > > > the have a specific > > > regioncode. eks: region 2 > > > > > > i then creates the folowing xdoclet @ejb:finder > > > comment: > > > > > > * @ejb:finder > > > * signature= "java.util.Collection > > > findByDVDRegion(java.lang.Integer dvdRegion)" > > > * query ="SELECT OBJECT(l) FROM Languages > AS > > > l,IN(l.DVDRegion) AS r > > > WHERE r = ?1" > > > > > > and whats wrong... > > I would try : SELECT OBJECT(l) FROM Languages AS l where l.DVDRegion = ?1 assuming your property name was DVDRegion. But did you cared that one language can be present in several region codes? ( Spain / Portuguise / Chinese / English will certainly... ) regards, ===== ----[ Konstantin Pribluda ( ko5tik ) ]---------------- Zu Verst�rkung meines Teams suche ich ab Sofort einen Softwareentwickler[In] f�r die Festanstellung. Arbeitsort: Mainz Skills: Programieren, Kentnisse in OpenSource-Bereich ----[ http://www.pribluda.de ]------------------------ __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ xdoclet-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/xdoclet-user
