I am using JBoss 4.0.1SP1 and mysql I have this JBoss declared-sql : SELECT c.Status, Month(c.firstUsed), COUNT(c.serialNumber) FROM Card c WHERE c.status = 4 GROUP BY Month(c.firstUsed)
here is my jbosscmp-jdbc.xml: | <query-method> | <method-name>ejbSelectCountCardsUsed</method-name> | <method-params> | </method-params> | </query-method> | | <declared-sql> | < select > | <ejb-name><![CDATA[Card]]></ejb-name> | <field-name><![CDATA[status]]></field-name> | < alias ><![CDATA[c]]>< /alias > | <additional-columns><![CDATA[, Month(c.firstUsed), COUNT(c.serialNumber)]]></additional-columns> | < /select > | < where ><![CDATA[ c.status = 4 GROUP BY Month(c.firstUsed)]]>< /where > | </declared-sql> | Is there anyway I can read these Month(c.firstUsed), COUNT(c.serialNumber) from the collection returned by this query? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3890357#3890357 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3890357 ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
