Bugs item #538802, was opened at 2002-04-03 10:25
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=538802&group_id=22866
Category: JBossCMP
Group: v3.0 Rabbit Hole
Status: Open
Resolution: None
Priority: 5
Submitted By: Eric Jain (ejain)
>Assigned to: Dain Sundstrom (dsundstrom)
Summary: LOCATE(bean.field, ?1)
Initial Comment:
LOCATE(bean.field, ?1) returns all rather than just
the matching records.
<query>
<query-method>
<method-name>findByPartialName</method-name>
<method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<ejb-ql>
<![CDATA[
SELECT OBJECT(s) FROM Service s WHERE LOCATE
(s.name, ?1) > -1
]]>
</ejb-ql>
</query>
2002-04-03 18:07:23,080 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ServiceE
JB.findByPartialName] Executing SQL: SELECT t0_s.id
FROM ServiceEJB t0_s WHERE locate(t0_s.name, ?, 1) > -1
----------------------------------------------------------------------
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=538802&group_id=22866
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
