0 Replies Latest reply on Feb 18, 2002 11:33 AM by Brenton House

    Using EJB-QL Declaration in JBoss 3.0

    Brenton House Newbie

      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??!?!

      thanks!

      brenton

      ______________________________________________


      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>


      <ejb-name>FaqItemEJB</ejb-name>
      <field-name>question</field-name>

      question like {0}
      question
      </declared-sql>