sorry, i didnt read the the buttom of your mail. English UK has language code lets say 1234 and English US maybe has code 1233
On Tue, 2003-10-07 at 16:13, David Nielsen wrote: > No i have 1 language which can only have 1 regionCode > say Danish is always a region 2, it cannot be a region 3 dvd > > > > On Tue, 2003-10-07 at 16:01, Konstantin Priblouda wrote: > > --- 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 Verstrkung meines Teams suche ich ab Sofort einen > > Softwareentwickler[In] fr 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 > > > > > > ------------------------------------------------------- > 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 > ------------------------------------------------------- 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
