[JBoss-user] [Beginners Corner] - Re: How to implement LIKE with input parameters in EJB QL 2.

[ltcmelo <nu...@jb...>]

I still haven't gotten it working.

Here's what i have in jbosscmp-jdbc.xml

  |          <query>
  |             <query-method>
  |                <method-name>findByName</method-name>
  |                <method-params>
  |                   <method-param>java.lang.String</method-param>
  |                </method-params>
  |             </query-method>
  | 			<jboss-ql><![CDATA[SELECT OBJECT(b) FROM mySchemaPartyHouse AS b WHERE b.name LIKE ?1]]></jboss-ql>
  | 
  | 	     </query>
  | 

for the exact same bean that i have this description in ejb-jar.xml

  |          <query>
  |             <query-method>
  |                <method-name>findByName</method-name>
  |                <method-params>
  |                   <method-param>java.lang.String</method-param>
  |                </method-params>
  |             </query-method>
  |             <ejb-ql><![CDATA[SELECT OBJECT(b) FROM mySchemaPartyHouse AS b WHERE b.name = ?1]]></ejb-ql>
  |          </query>
  | 

As I undertand, the query in JBossQL was supposed to be overriding the one in EJBQL, but this is not happening (or maybe, the jbossql query is not working as it should).

Does anyone have an idea?

Thanks,
ltcmelo

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3835028#3835028

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3835028