This is the EJB-CMP exercise from mastering EJB II (Ed Roman). I am using JBOSS 3.2 and hypersonic.
I can deploy my EJB fine but when I test it I get the following error :
javax.ejb.CreateException: Error checking if entity exists:java.sql.SQLException: Unexpected token: in statement [SELECT COUNT(*) FROM PRODUCTS WHERE ]
(...)
javax.ejb.FinderException: Find failed: java.sql.SQLException: Unexpected token: FROM in statement [SELECT FROM PRODUCTS t0_a WHERE t0_a.productid IS NOT NULL]
and this is the query definition in the ejb-jar.xml file :
query>
<query-method>
<method-name>findAll</method-name>
<method-params> </method-params>
</query-method>
<ejb-ql>
<![CDATA[SELECT OBJECT(a) FROM ProductBean as a WHERE a.productID IS NOT NULL]]>
</ejb-ql>
if someone has a clue, thanks very much for your hints !