You must use ejbSelect. Define it in ejb-jar.xml and overwrite it in jbosscmp-jdbc.xml the same way as a finder query. You could also check the testsuite for cmp2/ejbselect. Though, it usese dynamic queries.
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Darren Hartford > Sent: Wednesday, January 14, 2004 11:23 PM > To: [EMAIL PROTECTED] > Subject: [JBoss-user] JbossQL SUM (was: [jboss4 and EJB2.1 ejb-ql?]) > > I have the paid-for docs, full google, and several days later > I still do not know how to use the JbossQL to get a SUM. > Could someone enlighten me please? It should have been simple... > > -D > > --__--__-- > Subject: RE: [JBoss-user] RE: jboss4 and EJB2.1 ejb-ql? > Date: Mon, 12 Jan 2004 16:25:24 -0600 > From: "Alexey Loubyansky" <[EMAIL PROTECTED]> > > You answered the question yourself. ejb.select - method > level, jboss.query - class level. > > > -----Original Message----- > > /** > > * @ejb.select > > * signature=3D"java.util.Float=20 > > ejbSelectStoreSum(java.lang.String store, java.util.Date theday)" > > * query =3D "SELECT o.amountpaid FROM Store AS o WHERE=20 > > ((o.store =3D ?1) AND (o.transday=3D?2))" > > * @jboss.query > > * signature=3D"java.util.Float=20 > > ejbSelectStoreSum(java.lang.String store , java.util.Date theday)" > > * strategy=3D"none" > > * query =3D "SELECT SUM(o.amountpaid) FROM Store AS o WHERE=20 > > ((o.store =3D ?1) AND (o.transday=3D?2))" > > **/ > > > ------------------------------------------------------- > 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 > > ------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user