Create a finder based on multiple CMP-keys

[dencel]

Hello everybody,

Is it possible to create a finder who looks for more then one cmp-field? The sqlcode would look like "WHERE userName='me' AND userPassword='myself'".
In the documentation there are only examples of finders with single cmp-fields.
Does someone know the answer?
thnx Dencel

[rinehart]

Yes. Here's an EJB-QL Example:


<query-method>
<method-name>findByIdentity</method-name>
<method-params>
<method-param>java.lang.String</method-param>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<ejb-ql><![CDATA[
SELECT OBJECT(owner)
FROM AccountHolder owner
WHERE owner.username = ?1
AND owner.password = ?2]]>
</ejb-ql>

[dencel]

thanx a lot!