0 Replies Latest reply on Oct 1, 2003 2:51 PM by Raja

    EJB-QL With Character as input

    Raja Master

      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