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
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>