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