2 terms of Entity-Beans with OR in EJB-QL?

vanne Dec 2, 2002 2:25 AM

I have a problem when i try to connect in a EJB-QL statement two terms of
Entity-bean instances with OR I don't get a result.
But each of the two statements alone returns one result.

SELECT OBJECT(k) FROM KustBean k
WHERE (k.implKUSTVorgaenger.implId LIKE '1038574705549+3523611')
--> this works!

SELECT OBJECT(k) FROM KustBean k
WHERE ((k.implKUSTVorgaenger.implId LIKE '1038574705549+3523611') OR (k.implRootVorgaenger.implId LIKE '1038574705519+1753714') )
--> no results!

I use the JBoss 3.02

1. Re: 2 terms of Entity-Beans with OR in EJB-QL?

alvaro Dec 3, 2002 5:48 PM (in response to vanne)

Hi
Write in your jboss-ql

<jboss-ql>
<![CDATA[
SELECT OBJECT(k) FROM KustBean k
WHERE k.implKUSTVorgaenger.implId LIKE '1038574705549+3523611' OR k.implRootVorgaenger.implId LIKE '1038574705519+1753714'
]]>
</jboss-ql>
Actions