Hi,
I'm currently trying to implement an findall method (simplest of the simplest) but I cant get it to work allright. It deploys fine, but as soon as I call home.findAll() it fails with the following stacktrace dump:
javax.ejb.FinderException: Find failed: java.sql.SQLException: Unexpected token: FROM in statement [SELECT FROM SUBJECT t0_s]
at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:194)
I have jboss-ql generated by xdoclet:
<query-method>
<method-name>findAll</method-name>
<method-params>
</method-params>
</query-method>
<jboss-ql><![CDATA[select OBJECT(s) from Subject As s]]></jboss-ql>
It seems that in the generated sql being fired to the server the specification of the select statement is void. So I expect that I'm doing something wrong with column names or so.
Could somebody help me??
If desired I can provide the complete ejb-jar, jbosscmp-jdbc files.
Many Thnx in advance.
Jeroen