simple query error (bug?)

[kenh]

Hello,

jboss-3.0.6_tomcat-4.1.18 on Windows

Entity beans deploy without query but when adding a very simple "findByUserId" query following error occurs:

org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "IdentityMeta" at line 2, column 21.
Was expecting one of:
"IN" ...
<ABSTRACT_SCHEMA> ...
)

the ejb-jar.xml:

<query-method>
<method-name>findByUserId</method-name>
<method-params><method-param>java.lang.String</method-param></method-params>
</query-method>
<ejb-ql><![CDATA[ SELECT OBJECT(o) FROM IdentityMeta o
WHERE o.userId = ?1
]]>
</ejb-ql>


the table is defined as IdentityMeta in jbosscmp-jdbc.xml

Any ideas regarding where to search for this?

Ken

[kenh]

Ok. The problem was here:
Apparently <abstract-schema-name>
is the table name used in the EJB-QL select
ie. in this case the schema name should have
been "IdentityMeta"
It was not. When I changed it the cryptic error message went away.