EJB-QL

[jacktr]

I need help!!
I'm using jboss3.0 beta, when trying to parse an ejb-ql that looks like this in the ejb-jar

<query-method>
<method-name>findByBiggest</method-name>
<method-params/>
</query-method>
<ejb-ql>
<![CDATA[
SELECT OBJECT(a)
FROM Lgun AS a]]>
</ejb-ql>

I get some errors:
13:06:55,387 ERROR [EntityContainer] Exception in service lifecyle operation: st
art
org.jboss.deployment.DeploymentException: Unable to parse EJB-QL:

SELECT OBJECT(a)
FROM Lgun AS a
null

at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.j
ava:51)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JD
BCCommandFactory.java:44)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManage
r.java:177)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManage
r.java:335)
at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManag
er.java:175)
at org.jboss.ejb.EntityContainer.start(EntityContainer.java:368)
at org.jboss.ejb.Container.invoke(Container.java:749)
at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:995)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
55)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
23)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceControl
ler.java:777)
at $Proxy2.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:341)
at java.lang.reflect.Method.invoke(Native Method)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:16
28)
at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:15
23)
at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:78)
at $Proxy1.start(Unknown Source)
at org.jboss.ejb.Application.start(Application.java:265)
at org.jboss.ejb.EJBDeployer.deploy(EJBDeployer.java:459)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:458)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:413)
at org.jboss.deployment.MainDeployer.scan(MainDeployer.java:272)
at org.jboss.deployment.MainDeployer.run(MainDeployer.java:259)
at java.lang.Thread.run(Unknown Source)

the method findByBiggest ist defined in the HOme Interface, and Lgun ist the abstract schema name. Could someone PLEASE help me???

[feuxeu77]

Hi,

You have to describe your FIND method in jbosscmp-jdbc.xml. In the <entreprise-beans>/ section, put the following code :

<query-method>
<method-name>findByBiggest</method-name>
<method-params/>
</query-method>
<declared-sql>

</declared-sql>


I never tried without "method-params" or "where" but I think it should work.

FX

[dsundstrom]

&gt; Hi,
&gt;
&gt; You have to describe your FIND method in
&gt; jbosscmp-jdbc.xml.

No you don't.

Upgrade to the RC1 release, and you will see a full error message.

[jacktr]

thanks. with the upgrade to rc1 i could see my errors and everything is running now.