In JBoss 4.0.0, I am trying to deploy an entity EJB with the following EJBQL statement
in it
SELECT OBJECT(f) FROM address f
WHERE f.validDate <= ?1
During deployment I get a ParseException on "<=" operator. According to the EJB 2.0
spec, <= is a valid operator. validDate field is a DATE field in the database.
On changing the statement as follows, I was able to make it work.
SELECT OBJECT(f) FROM address f
WHERE f.validDate < ?1 or f.validDate = ?1
I am interested in knowing why the first form of SELECT statement did not work.
Thanks,
Ancin
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3853956#3853956
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3853956
---
This SF.Net email is sponsored by:
Sybase ASE Linux Express Edition - download now for FREE
LinuxWorld Reader's Choice Award Winner for best database on Linux.
http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
___
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user