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

    <table-name>schema.table</table-name>  CORRECT??

    afranken Newbie

      Weblogic had an element for schema-name. Converting to jboss, i put schema.table in <table-name> element. Is this the correct way to do it with jboss? My findAll method works but my findXXX doesn't return any.

      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>