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
Never mind! I found the bug.
My abstract schema name was wrong