0 Replies Latest reply on Nov 18, 2002 10:48 PM by Eric Chow

    EJB-QL with byte[] as the parameter ??

    Eric Chow Newbie

      Hello,

      The following is my simple EJB-QL defining in ejb-jar.xml.
      =============================================

      <query-method>
      <method-name>findByName</method-name>
      <method-params>
      <method-param>WHAT_IS_THIS_TYPE_IN_JAVA</method-param>
      </method-params>
      </query-method>

      <ejb-ql>
      <![CDATA[
      SELECT OBJECT(a) FROM RestaurantEJB a WHERE a.name = ?1
      ]]>
      </jboss-ql>

      ==================================================

      if the a.name is a BLOB(in database) and byte[] in Java, what is the data type of <method-param> should be used ?


      In addition, I defined the in ejb-jar.xml, do I need to re-define <jboss-ql> in jbosscmp-jdbc.xml?

      If I only defined in ejb-jar.xml, it seems not work, and some exception message showed that it must define some ejb-ql for each findXXXX methods .....

      But I can't see any duplicate EJB-QL or JBOSS-QL definition in your cmp2 template example.


      Best regards,
      Eric