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

      <query-method>
      <method-name>findByJobAndContainerID</method-name>
      <method-params>
      <method-param>java.lang.Long</method-param>
      <method-param>java.lang.Long</method-param>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <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" ...
      <ABSTRACT_SCHEMA> ...

      )
      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

      Thanks