I am using the follwing in my jbosscmp-jdbc.xml file, and it returns a collection of "id"'s just fine. However, I want to return a collection of FAQ entities. So I remove the "<field-name>" element but now it either returns an empty collection (in the 3.0 alpha release) or a FinderException (in the latest from CVS).
Any ideas on how to get this to work??!?!
select faqs that match question <query-method> <method-name>ejbSelectFAQs</method-name> <method-params> <method-param>java.lang.String</method-param> </method-params> </query-method> <declared-sql>