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&group_id=3D228= 66&at id=3D381174 [ 815115 ] JBossQL: SUM, AVG, MAX, MIN http://sourceforge.net/tracker/?func=3Ddetail&aid=3D815115&group_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
