This content has been marked as final.
Show 6 replies
-
1. Re: CMP Bean Finder expression error
dragon_jdh Jan 21, 2005 8:30 AM (in response to xjava2001)illegal character, you should use < or sth else instead of <
-
2. Re: CMP Bean Finder expression error
xjava2001 Jan 21, 2005 12:49 PM (in response to xjava2001)Thanks for the reply.
Its not complaining on '> ' its complaining on >= ?
I appreciate your help
Xjava -
3. Re: CMP Bean Finder expression error
sysuser1 Jan 21, 2005 1:08 PM (in response to xjava2001)As suggested by dragon_jdh you need to escape your query in the xml file. So for every '<' in the query use "<" and similarly for every '>' use ">".
Another alternative is to put your query in CDATA tag<ejb-ql>[CDATA[SELECT OBJECT(o) FROM test as o WHERE o.cln =?1 AND o.pt =?2 AND o.effDt >=?3]]</ejb-ql>
Good Luck,
VM -
4. Re: CMP Bean Finder expression error
sysuser1 Jan 21, 2005 1:12 PM (in response to xjava2001)Correction to my reply...
<ejb-ql><![CDATA[SELECT OBJECT(o) FROM test as o WHERE o.cln =?1 AND o.pt =?2 AND o.effDt >=?3]]</ejb-ql>
-
5. Re: CMP Bean Finder expression error
xjava2001 Jan 21, 2005 1:48 PM (in response to xjava2001)thank you Vmukkamala.
This is what I got in my ejb-jar.xml
<ejb-ql><![CDATA[SELECT OBJECT(o) FROM Test as o WHERE o.cln =?1 AND o.pt =?2 AND o.effDt >=?3]]></ejb-ql>
but when I change >= to just > it did work. -
6. Re: CMP Bean Finder expression error
fbiaggi Jan 22, 2005 2:16 PM (in response to xjava2001)Hi,
the >= operator is not supported on ejb-ql specifications.
Use jboss-ql instead