I do not seem to get any results back from this set up. However when I am in sqlplus the query SELECT COUNT(*) FROM table where tainvt = '10002' returns 8. So I should get a Enumeration returned. Have I missed something?
In ejb-jar.xml
<query-method>
<method-name>findDailyActivity</method-name>
<method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<ejb-ql>
<![CDATA[SELECT OBJECT(a) FROM TaDailyActivity a WHERE (a.tainvt = ?1)]]>
</ejb-ql>
In jbosscmp-jdbc.xml
<query-method>
<method-name>findDailyActivity</method-name>
<method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<jboss-ql>
<![CDATA[SELECT OBJECT(a) FROM TaDailyActivity a WHERE (a.tainvt = ?1) ORDER BY a.actdate desc]]>
</jboss-ql>
