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:
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?
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.