1 Reply Latest reply on Jan 29, 2003 2:07 PM by mang qin

    Help! Problem using "IN" expression in ejbql

    mang qin Newbie

      I have this query in my ejb-jar.xml

      <ejb-ql><![CDATA[SELECT OBJECT (c) FROM CRATemplateMapView as c WHERE c.sourceWell IN ( ?3 ) AND c.jobID = ?1 AND c.containerID = ?2 ]]></ejb-ql>

      I got error:
      2003-01-29 10:17:26,511 ERROR [org.j=tru.ejb.EjbModule] Starting failed
      org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwa
      ble: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "CRATemplateMa
      pView" at line 1, column 24.
      Was expecting one of:
      "IN" ...

      ava:46) at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.java)

      I even substitude (?3) with ('abc','xyz'), but still get this error.

      This happens with both jboss 3.0.0 and jboss3.0.2