> If this is the case, then is there any need for us to go for BMP's at all? > Correct me if I am wrong. The major chunk for CMP1.1 and BMP1.1 was that in > CMP1.1 we cannot join tables thru sql's so we went for BMP's. Now that we > are able to do that in EJB2.0 with ejb-ql and cmr-fields, do we really need > BMP's..
there will always be a need for BMP - probably the biggest need being to be able to relatively quickly make a wrapper around some existing system until it is fully migrated. but yes, the problem with relationships that was present in cmp 1.1 is largely addressed by this. having said that, there will always be times when you need something that suggests BMP - ther ewill always be the exception (o: cheers dim > > > ??Ramesh Kesavanarayanan > ? [EMAIL PROTECTED] > > > -----Original Message----- > From: Dmitri Colebatch [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 30, 2002 2:57 PM > To: Kesavanarayanan, Ramesh (Cognizant) > Cc: [EMAIL PROTECTED] > Subject: Re: doubt in ejb-ql > > > No my question is just like we use a join sql statement in EB is it > possible > > to write the same sql in ejb-ql also? > > I'm not quite sure I understand your question then. > > Picture this... suppose I have a database schema with three tables STORY, > STORYSECTION and SECTION which represent a many to many relationship between > story and section. > > to do a query in sql finding all stories for a given seciton id, you'd do > something like > > SELECT * FROM story AS s LEFT JOIN storysection AS ss ON s.storyid = > ss.storyid WHERE ss.sectionid = ? > > in ejb-ql, you would do this: > > SELECT OBJECT(s) FROM Story AS s, IN (s.storySections) ss WHERE ss.section = > ?1 > > the subtle difference being that the parameter to the first query is the > sectionid, but in the second its the section local interface. > > does that explain it? > > hth > dim > > > > > ??Ramesh Kesavanarayanan > > ? [EMAIL PROTECTED] > > > > > > -----Original Message----- > > From: Dmitri Colebatch [mailto:[EMAIL PROTECTED]] > > Sent: Friday, August 30, 2002 2:47 PM > > To: Kesavanarayanan, Ramesh (Cognizant); [EMAIL PROTECTED] > > Subject: Re: doubt in ejb-ql > > > > yes, you simply reference another bean. > > > > > > ----- Original Message ----- > > From: "Kesavanarayanan, Ramesh (Cognizant)" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, August 30, 2002 6:54 PM > > Subject: doubt in ejb-ql > > > > > > > Hi all, > > > > > > Is it possible to make a join in ejb-ql? > > > > > > > > > * Ramesh Kesavanarayanan > > > * [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
