I tried a simple EJB-QL which looks like
SELECT OBJECT(a) FROM EMPLOYEE a
where a.empType = 'M'
Jboss throws a EJBQL Compile error saying it only expects functions and numeric literals and it found \'M\'
This is on Jboss 3.0.7 with Mysql on Windows.
If i change the query to take a character argument and feed that as input to sql, something like
SELECT OBJECT(a) From employee a
where a.empType = ?1
and my finder takes a "char" type , it deploys well and works well.
How do i define a character literal on EJB-QL
TIA
Raj