0 Replies Latest reply on Dec 10, 2003 2:38 PM by afranken

    does my query element look right

    afranken Newbie

      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>