You answered the question yourself. ejb.select - method level, jboss.query - class level.
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Darren Hartford > Sent: Monday, January 12, 2004 9:29 PM > To: [EMAIL PROTECTED] > Subject: [JBoss-user] RE: jboss4 and EJB2.1 ejb-ql? > > Been trying to get this to work, but no luck. How do you use > JbossQL with Xdoclet for an EJB.SELECT? The following does > not work, and some of the mailing lists mention that > jboss.query is NOT for SELECT (SELECT is method level while > jboss.query is class level), so what would one use? > > /** > * @ejb.select > * signature="java.util.Float > ejbSelectStoreSum(java.lang.String store, java.util.Date theday)" > * query = "SELECT o.amountpaid FROM Store AS o WHERE > ((o.store = ?1) AND (o.transday=?2))" > * @jboss.query > * signature="java.util.Float > ejbSelectStoreSum(java.lang.String store , java.util.Date theday)" > * strategy="none" > * query = "SELECT SUM(o.amountpaid) FROM Store AS o WHERE > ((o.store = ?1) AND (o.transday=?2))" > **/ > > p.s. seems silly to declare an ejb.select for a JbossQL SUM > that you know will not work as expected outside of Jboss. > > TIA!! > -D > > Subject: RE: [JBoss-user] jboss4 and EJB2.1 ejb-ql? > Date: Thu, 8 Jan 2004 09:03:55 -0600 > From: "Alexey Loubyansky" <[EMAIL PROTECTED]> > > Check these change notes. EJB2.1 is not yet supported but you > can do it in JBossQL in 3.2 and HEAD. > > [ 794199 ] Functions in SELECT clause > http://sourceforge.net/tracker/?func=3Ddetail&aid=3D794199&gro > up_id=3D228= > 66&at > id=3D381174 > [ 815115 ] JBossQL: SUM, AVG, MAX, MIN > http://sourceforge.net/tracker/?func=3Ddetail&aid=3D815115&gro > up_id=3D228= > 66&at > id=3D381174=20 > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of=20 > >Darren Hartford > > Sent: Thursday, January 08, 2004 4:45 PM > > To: [EMAIL PROTECTED] > > Subject: [JBoss-user] jboss4 and EJB2.1 ejb-ql? > >=20 > > Hey all, > > Grabbed a snapshot of 4.0DR3 as it is the most recent to see=20 if > >the aggregate functions defined in EJB2.1 are ready to go.=20 > >Unfortunately, this query did not work or my code is wrong. > >=20 > > EJB-QL > > "SELECT SUM(o.amountpaid) FROM MyTable AS o" > > Jboss-QL > > "SELECT SUM(o.amountpaid) FROM MyTable AS o" > > > ------------------------------------------------------- > This SF.net email is sponsored by: Perforce Software. > Perforce is the Fast Software Configuration Management System > offering advanced branching capabilities and atomic changes > on 50+ platforms. > Free Eval! http://www.perforce.com/perforce/loadprog.html > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > ------------------------------------------------------- This SF.net email is sponsored by: Perforce Software. Perforce is the Fast Software Configuration Management System offering advanced branching capabilities and atomic changes on 50+ platforms. Free Eval! http://www.perforce.com/perforce/loadprog.html _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user