5 Replies Latest reply on May 18, 2004 5:33 AM by sesques

    EJB-QL ERROR with 3.2.3 but working with 3.0.4

    jbs Newbie

      Hello to all JBOSS-Users.

      I have some simple CMP EJBs which worked well with JBOSS 3.0.4.
      For several reasons I moved to the new JBOSS Version 3.2.3 and surprisingly all previously working EJBs are now undeployable.
      Unfortunately I do not understand what JBOSS tries to tell me about my EJBs by throwing a 'NoSuchMethod' exception.

      Can anybody help me out here or point me to the right direction?

      Thanks in advance

      Jens

      Please see below the exception log and the xdoclet header

      -------------------------------------------------------------------


      jvm 1 | 11:04:57,425 ERROR [EntityContainer] Starting failed
      jvm 1 | org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJECT(c) FROM CustomerEJB
      c'; - nested throwable: (java.lang.NoSuchMethodError)
      jvm 1 | at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.java:50)
      jvm 1 | at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFactory.java:59)
      jvm 1 | at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:212)
      jvm 1 | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:490)
      jvm 1 | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:388)
      jvm 1 | at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:152)
      jvm 1 | at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:342)
      jvm 1 | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
      jvm 1 | at java.lang.reflect.Method.invoke(Native Method)
      jvm 1 | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      jvm 1 | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      jvm 1 | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
      jvm 1 | at $Proxy14.start(Unknown Source)
      jvm 1 | at org.jboss.system.ServiceController.start(ServiceController.java:394)
      jvm 1 | at java.lang.reflect.Method.invoke(Native Method)
      jvm 1 | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      jvm 1 | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      jvm 1 | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      jvm 1 | at $Proxy58.start(Unknown Source)
      jvm 1 | at org.jboss.ejb.EjbModule.startService(EjbModule.java:331)
      jvm 1 | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
      jvm 1 | at java.lang.reflect.Method.invoke(Native Method)
      jvm 1 | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      jvm 1 | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      jvm 1 | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
      jvm 1 | at $Proxy14.start(Unknown Source)
      jvm 1 | at org.jboss.system.ServiceController.start(ServiceController.java:394)
      jvm 1 | at java.lang.reflect.Method.invoke(Native Method)
      jvm 1 | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      jvm 1 | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      jvm 1 | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      jvm 1 | at $Proxy12.start(Unknown Source)
      jvm 1 | at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:544)
      jvm 1 | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
      jvm 1 | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642)
      jvm 1 | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
      jvm 1 | at java.lang.reflect.Method.invoke(Native Method)
      jvm 1 | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      jvm 1 | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
      jvm 1 | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      jvm 1 | at $Proxy6.deploy(Unknown Source)
      jvm 1 | at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302)
      jvm 1 | at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476)
      jvm 1 | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner

      -------------------------------------------------------

      /**
      * j2ee customer implementation
      *
      * @ejb.bean
      * name="CustomerEJB"
      * description="customer persistence ejb."
      * display-name="customer entity."
      * generate="true"
      * jndi-name="mce/control/Customer"
      * view-type="remote"
      * type="CMP"
      * transaction-type="Container"
      * cmp-version="2.x"
      * primkey-field="id"
      *
      * @ejb.finder
      * view-type="remote"
      * description="finds all customer."
      * signature="java.util.Collection findAll()"
      * query="SELECT OBJECT(c) FROM CustomerEJB c"
      *
      * @ejb.home
      * extends="javax.ejb.EJBHome"
      * generate="remote"
      *
      * @ejb.interface
      * extends="javax.ejb.EJBObject"
      * generate="remote"
      *
      * @ejb.persistence
      * table-name="customer"
      *
      * @ejb.pk
      * class="java.lang.Integer"
      *
      * @ejb.util
      * generate="physical"
      *
      * @jboss.persistence create-table="false" remove-table="false"
      * @jboss.container-configuration name="Standard CMP 2.x EntityBean"
      */

        • 1. Re: EJB-QL ERROR with 3.2.3 but working with 3.0.4
          deanwampler Newbie

          Try adding "as" to the query:

          query="SELECT OBJECT(c) FROM CustomerEJB AS c"

          • 2. Re: EJB-QL ERROR with 3.2.3 but working with 3.0.4
            sesques Novice

            What is your jdk version ?

            • 3. Re: EJB-QL ERROR with 3.2.3 but working with 3.0.4
              jbs Newbie

              Unfortunately it does not work. The error message is the same:

              jvm 1 | org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT OBJECT(c) FROM CustomerEJB
              AS c'; - nested throwable: (java.lang.NoSuchMethodError)
              jvm 1 | at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.java:50)
              jvm 1 | at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFactory.java:59)
              jvm 1 | at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:212)
              jvm 1 | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:490)
              jvm 1 | at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:388)
              jvm 1 | at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:152)
              jvm 1 | at org.jboss.ejb.EntityContainer.startService(EntityContainer.java:342)
              jvm 1 | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
              jvm 1 | at java.lang.reflect.Method.invoke(Native Method)
              jvm 1 | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              jvm 1 | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
              jvm 1 | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
              jvm 1 | at $Proxy14.start(Unknown Source)
              jvm 1 | at org.jboss.system.ServiceController.start(ServiceController.java:394)
              jvm 1 | at java.lang.reflect.Method.invoke(Native Method)
              jvm 1 | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              jvm 1 | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
              jvm 1 | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
              jvm 1 | at $Proxy40.start(Unknown Source)
              jvm 1 | at org.jboss.ejb.EjbModule.startService(EjbModule.java:331)
              jvm 1 | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
              jvm 1 | at java.lang.reflect.Method.invoke(Native Method)
              jvm 1 | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              jvm 1 | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
              jvm 1 | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
              jvm 1 | at $Proxy14.start(Unknown Source)
              jvm 1 | at org.jboss.system.ServiceController.start(ServiceController.java:394)
              jvm 1 | at java.lang.reflect.Method.invoke(Native Method)
              jvm 1 | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              jvm 1 | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
              jvm 1 | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
              jvm 1 | at $Proxy12.start(Unknown Source)
              jvm 1 | at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:544)
              jvm 1 | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
              jvm 1 | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642)
              jvm 1 | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
              jvm 1 | at java.lang.reflect.Method.invoke(Native Method)
              jvm 1 | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              jvm 1 | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
              jvm 1 | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
              jvm 1 | at $Proxy6.deploy(Unknown Source)
              jvm 1 | at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302)
              jvm 1 | at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476)
              jvm 1 | at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner
              .java:201)
              jvm 1 | at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:27
              4)
              jvm 1 | at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
              jvm 1 | at java.lang.reflect.Method.invoke(Native Method)
              jvm 1 | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              jvm 1 | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
              jvm 1 | at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:976)
              jvm 1 | at $Proxy0.start(Unknown Source)
              jvm 1 | at org.jboss.system.ServiceController.start(ServiceController.java:394)
              jvm 1 | at java.lang.reflect.Method.invoke(Native Method)
              jvm 1 | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              jvm 1 | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
              jvm 1 | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
              jvm 1 | at $Proxy4.start(Unknown Source)
              jvm 1 | at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226)
              jvm 1 | at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
              jvm 1 | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:642)
              jvm 1 | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:605)
              jvm 1 | at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:589)
              jvm 1 | at java.lang.reflect.Method.invoke(Native Method)
              jvm 1 | at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              jvm 1 | at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
              jvm 1 | at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
              jvm 1 | at $Proxy5.deploy(Unknown Source)
              jvm 1 | at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:384)
              jvm 1 | at org.jboss.system.server.ServerImpl.start(ServerImpl.java:291)
              jvm 1 | at org.jboss.Main.boot(Main.java:150)
              jvm 1 | at org.jboss.Main$1.run(Main.java:395)
              jvm 1 | at java.lang.Thread.run(Thread.java:484)
              jvm 1 | + nested throwable:
              jvm 1 | java.lang.NoSuchMethodError
              jvm 1 | at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.visit(JDBCEJBQLCompiler.java:932)
              jvm 1 | at org.jboss.ejb.plugins.cmp.ejbql.ASTSelect.jjtAccept(ASTSelect.java:25)


              Jens

              • 4. Re: EJB-QL ERROR with 3.2.3 but working with 3.0.4
                jbs Newbie

                 

                "sesques" wrote:
                What is your jdk version ?


                1.3.1_01

                • 5. Re: EJB-QL ERROR with 3.2.3 but working with 3.0.4
                  sesques Novice

                  Try to update your JDK
                  JBoss has potentially problems with JDK 1.3.x

                  See the Wiki page:
                  http://jboss.org/wiki/Wiki.jsp?page=JBossInstallation

                  Pascal