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
