Hello, I've seen this question once before but I can't
resolve the issue based on the user's own answer. Can
someone help?

org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "ACCOUNT_OBJVW" at line
2, column 21.
Was expecting one of:
"IN" ...
<ABSTRACT_SCHEMA> ...
)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCJBossQLQuery.(JDBCJBossQLQuery.java:46)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createJBossQLQuery(JDBCCommandFactory.java:63)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:203)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:511)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:416)

I was under the impression that to use jboss-ql all you had to do in the ejb-jar.xml was an entry similar to the following, by just defining the query method and an empty
<ejb-ql></ejb-ql>

<query-method>
<method-name>findByAccountCode</method-name>
<method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<ejb-ql>
</ejb-ql>


then in your jbosscmp-jdbc.xml you need to add just the following to use jboss-ql.

<query-method>
<method-name>findByAccountCode</method-name>
<method-params>
<method-param>java.lang.String
</method-param>
</method-params>
</query-method>
<jboss-ql><![CDATA[
SELECT OBJECT(g)
FROM ACCOUNT_OBJVW g
WHERE g.account_code = ?1
]]></jboss-ql>


Now, if I have the following under my entity description
in my jbosscmp-jdbc.xml, why am I getting this error. Am I missing something?

<ejb-name>cm_entity_acct_Acct</ejb-name>
<table-name>ACCOUNT_OBJVW</table-name>

-- Thanks