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. Also,side note, with only this datasource (<table-name>schema.table</table-name>), I get NoSuchEntityException when running findByPrimaryKey. My other datasource works like perfection.
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>