0 Replies Latest reply on Feb 9, 2004 7:50 AM by Walter

    Problem with LIKE Parameters in JBossQL

    Walter Newbie

      Hi, I need a problem.
      I have this jbosscmp-jdbc.xml


      <query-method>
      <method-name>findDmdName</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <jboss-ql>SELECT OBJECT(d) FROM DmdEntityBean AS d WHERE d.name LIKE CONCAT(?1,'%')</jboss-ql>

      <result-type-mapping>Local</result-type-mapping>


      For example, I want to find the name "Arno", and in my DataBase I have:
      Arnos, Arnosmi, Arnotti, Mai, Putin....

      The result of this query is all de record:
      Arnos
      Arnosmi
      Arnotti
      Mai
      Putin

      but I need only Arno, what is the problem??
      Thank's