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