Hi,
Whatever I try, I always get ParseException error.
The sql after compilation is:
SELECT OBJECT(s) FROM EJBBean AS s WHERE s.branch_id IN (?1, ?2, ?3, ?4) AND s.sDate >= ?5 AND s.sDate <= ?6
The details is :
Encountered "1" at line 1, column 74.
Was expecting one of:
"ABS" ...
"COUNT" ...
column 74 is just at ?1 position.
But the sql is correct and I checked the object[] args which is also correct.
Any one can help?
Thanks
Which JBoss version do you use?
AFAIK the IN operator in the WHERE clause can use variables since J2EE-1.4.
So you must use JBoss 4.0.x for this.