9 Replies Latest reply on Sep 14, 2002 5:32 AM by HauJye Tan

    Crimeportal example failed to deploy on JBoss 3 and PostgreS

    HauJye Tan Newbie

      Dear all,

      When I deploy the crimeportal example from the CMP book, I got the following exception. I am working with JBoss 3 and PostgreSQL 7.2. Please help.

      2002-09-09 10:23:31,841 ERROR [org.jboss.deployment.MainDeployer] could not start deployment: file:/D:/jboss-3.0.0_tomcat-4.0.3/server/all/deploy/gangster-cmp2.jar
      org.jboss.deployment.DeploymentException: Could not deploy file:/D:/jboss-3.0.0_tomcat-4.0.3/server/all/deploy/gangster-cmp2.jar; - nested throwable: (org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (javax.transaction.RollbackException: Already marked for rollback))
      at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:413)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:678)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:513)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      at $Proxy4.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:405)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:586)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:465)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:202)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:191)
      + nested throwable:
      org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (javax.transaction.RollbackException: Already marked for rollback)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:190)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:84)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:383)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
      at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
      at org.jboss.ejb.Container.invoke(Container.java:793)
      at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
      at $Proxy6.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:340)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      at $Proxy21.start(Unknown Source)
      at org.jboss.ejb.EjbModule.startService(EjbModule.java:440)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:162)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
      at $Proxy6.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:340)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      at $Proxy5.start(Unknown Source)
      at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:398)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:678)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:513)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      at $Proxy4.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:405)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:586)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:465)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:202)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:191)
      + nested throwable:
      javax.transaction.RollbackException: Already marked for rollback
      at org.jboss.tm.TxCapsule.commit(TxCapsule.java:321)
      at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:74)
      at org.jboss.tm.TxManager.commit(TxManager.java:138)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:178)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:84)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:383)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
      at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
      at org.jboss.ejb.Container.invoke(Container.java:793)
      at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
      at $Proxy6.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:340)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      at $Proxy21.start(Unknown Source)
      at org.jboss.ejb.EjbModule.startService(EjbModule.java:440)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:162)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
      at $Proxy6.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:340)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      at $Proxy5.start(Unknown Source)
      at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:398)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:678)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:513)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      at $Proxy4.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:405)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:586)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:465)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:202)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:191)
      2002-09-09 10:23:31,841 ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Failed to deploy: org.jboss.deployment.scanner.URLDeploymentScanner$DeployedURL@deb1381d{ url=file:/D:/jboss-3.0.0_tomcat-4.0.3/server/all/deploy/gangster-cmp2.jar, deployedLastModified=0 }
      org.jboss.deployment.DeploymentException: Could not deploy file:/D:/jboss-3.0.0_tomcat-4.0.3/server/all/deploy/gangster-cmp2.jar; - nested throwable: (org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (javax.transaction.RollbackException: Already marked for rollback))
      at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:413)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:678)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:513)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      at $Proxy4.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:405)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:586)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:465)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:202)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:191)
      + nested throwable:
      org.jboss.deployment.DeploymentException: Error while creating table; - nested throwable: (javax.transaction.RollbackException: Already marked for rollback)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:190)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:84)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:383)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
      at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
      at org.jboss.ejb.Container.invoke(Container.java:793)
      at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
      at $Proxy6.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:340)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      at $Proxy21.start(Unknown Source)
      at org.jboss.ejb.EjbModule.startService(EjbModule.java:440)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:162)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
      at $Proxy6.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:340)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      at $Proxy5.start(Unknown Source)
      at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:398)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:678)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:513)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      at $Proxy4.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:405)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:586)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:465)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:202)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:191)
      + nested throwable:
      javax.transaction.RollbackException: Already marked for rollback
      at org.jboss.tm.TxCapsule.commit(TxCapsule.java:321)
      at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:74)
      at org.jboss.tm.TxManager.commit(TxManager.java:138)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:178)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:84)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:383)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
      at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
      at org.jboss.ejb.Container.invoke(Container.java:793)
      at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
      at $Proxy6.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:340)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      at $Proxy21.start(Unknown Source)
      at org.jboss.ejb.EjbModule.startService(EjbModule.java:440)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:162)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:894)
      at $Proxy6.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:340)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      at $Proxy5.start(Unknown Source)
      at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:398)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:678)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:513)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:481)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:491)
      at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
      at $Proxy4.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:405)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:586)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:465)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:202)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:191)
      2002-09-09 10:23:36,868 DEBUG [org.jboss.deployment.scanner.URLDeploymentScanner] Watch URL for: file:/D:/jboss-3.0.0_tomcat-4.0.3/server/all/deploy/gangster-cmp2.jar -> file:/D:/jboss-3.0.0_tomcat-4.0.3/server/all/deploy/gangster-cmp2.jar

        • 1. Re: Crimeportal example failed to deploy on JBoss 3 and Post
          HauJye Tan Newbie

          Tables are created after I upgraded to JBoss 3.0.2. However, the deployment is still failing -- "Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: FROM not found)"

          The ejb-jar.xml is the same as the one found in the CMP book.

          16:57:39,495 INFO [MainDeployer] Starting deployment of package: file:/D:/jboss-3.0.2/server/all/deploy/gangster-cmp2.jar
          16:57:39,725 INFO [EJBDeployer]
          Bean : GangsterEJB
          Section: 10.6.2
          Warning: CMP entity beans may not define the implementation of a finder.

          16:57:39,785 INFO [EjbModule] Creating
          16:57:39,805 INFO [EjbModule] Deploying OrganizationEJB
          16:57:39,835 INFO [EjbModule] Deploying GangsterEJB
          16:57:39,855 INFO [EjbModule] Deploying JobEJB
          16:57:39,865 INFO [EjbModule] Deploying LocationEJB
          16:57:39,875 INFO [EjbModule] Deploying AutoNumberEJB
          16:57:39,885 INFO [EjbModule] Deploying EJBTestRunnerEJB
          16:57:39,905 INFO [EjbModule] Deploying ReadAheadEJB
          16:57:39,986 INFO [EjbModule] Created
          16:57:39,986 INFO [EjbModule] Starting
          16:57:41,858 INFO [OrganizationEJB] Created table 'organization' successfully.
          16:57:42,019 INFO [LocationEJB] Created table 'location' successfully.
          16:57:42,209 INFO [JobEJB] Created table 'job' successfully.
          16:57:42,359 INFO [AutoNumberEJB] Created table 'autonumber' successfully.
          16:57:42,419 INFO [GangsterEJB] Table 'gangster' already exists
          16:57:42,439 INFO [GangsterEJB] Table 'gangster_enemies' already exists
          16:57:42,559 INFO [GangsterEJB] Created table 'gangster_job' successfully.
          16:57:42,720 WARN [ServiceController] Problem starting service jboss.j2ee:service=EJB,jndiName=crimeportal/Gangster
          org.jboss.deployment.DeploymentException: Error compiling ejbql; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: FROM not found)
          at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.java:46)
          at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFactory.java:44)
          at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:214)
          at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:463)
          at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:369)
          at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
          at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
          at org.jboss.ejb.Container.invoke(Container.java:764)
          at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
          at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
          at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:967)
          at $Proxy5.start(Unknown Source)
          at org.jboss.system.ServiceController.start(ServiceController.java:396)
          at java.lang.reflect.Method.invoke(Native Method)
          at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
          at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
          at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
          at $Proxy25.start(Unknown Source)
          at org.jboss.ejb.EjbModule.startService(EjbModule.java:430)
          at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:164)
          at java.lang.reflect.Method.invoke(Native Method)
          at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
          at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
          at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:967)
          at $Proxy5.start(Unknown Source)
          at org.jboss.system.ServiceController.start(ServiceController.java:396)
          at java.lang.reflect.Method.invoke(Native Method)
          at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
          at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
          at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
          at $Proxy10.start(Unknown Source)
          at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:394)
          at org.jboss.deployment.MainDeployer.start(MainDeployer.java:802)
          at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:616)
          at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:580)
          at java.lang.reflect.Method.invoke(Native Method)
          at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
          at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
          at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
          at $Proxy4.deploy(Unknown Source)
          at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:427)
          at org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:648)
          at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:499)
          at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:212)
          at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:225)
          at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:202)
          + nested throwable:
          org.jboss.ejb.plugins.cmp.ejbql.ParseException: FROM not found
          at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.parse(EJBQLParser.java:38)
          at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.compileEJBQL(JDBCEJBQLCompiler.java:143)
          at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.(JDBCEJBQLQuery.java:40)
          at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFactory.java:44)
          at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:214)
          at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:463)
          at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:369)
          at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
          at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
          at org.jboss.ejb.Container.invoke(Container.java:764)
          at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
          at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
          at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:967)
          at $Proxy5.start(Unknown Source)
          at org.jboss.system.ServiceController.start(ServiceController.java:396)
          at java.lang.reflect.Method.invoke(Native Method)
          at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
          at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
          at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
          at $Proxy25.start(Unknown Source)
          at org.jboss.ejb.EjbModule.startService(EjbModule.java:430)
          at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:164)
          at java.lang.reflect.Method.invoke(Native Method)
          at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
          at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
          at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:967)
          at $Proxy5.start(Unknown Source)
          at org.jboss.system.ServiceController.start(ServiceController.java:396)
          at java.lang.reflect.Method.invoke(Native Method)
          at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
          at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
          at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
          at $Proxy10.start(Unknown Source)
          at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:394)
          at org.jboss.deployment.MainDeployer.start(MainDeployer.java:802)
          at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:616)
          at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:580)
          at java.lang.reflect.Method.invoke(Native Method)
          at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
          at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
          at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
          at $Proxy4.deploy(Unknown Source)
          at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:427)
          at org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:648)
          at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:499)
          at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:212)
          at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:225)
          at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:202)
          16:57:42,750 INFO [EjbModule] Started
          16:57:42,750 INFO [MainDeployer] Deployed package: file:/D:/jboss-3.0.2/server/
          all/deploy/gangster-cmp2.jar
          16:57:42,750 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
          Cause: Incomplete Deployment listing:
          Packages waiting for a deployer:

          Incompletely deployed packages:

          MBeans waiting for classes:

          MBeans waiting for other MBeans:
          [ObjectName: jboss.net:service=Axis
          state: CONFIGURED
          I Depend On: jboss.web:service=JBossWeb

          Depends On Me: jboss.net:service=Adaptor
          , ObjectName: jboss.net:service=Adaptor
          state: CONFIGURED
          I Depend On: jboss.net:service=Axis

          Depends On Me: , ObjectName: jboss.j2ee:service=EJB,jndiName=crimeportal/Gangst
          er
          state: FAILED
          I Depend On:
          Depends On Me: org.jboss.deployment.DeploymentException: Error compiling ejbql;
          - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: FROM not found)]




          • 2. Re: Crimeportal example failed to deploy on JBoss 3 and Post
            Dain Sundstrom Master

            The problem is I stupidly named one of the colums desc which is a reserved word. Change this in the jbosscmp-jdbc.xml file, and it should start working for you (make sure to clean out the old tables).

            • 3. Re: Crimeportal example failed to deploy on JBoss 3 and Post
              HauJye Tan Newbie

              Hi,

              Hit another problem after changed column name from 'desc' to 'descn' in jbosscmp-jdbc.xml: "jboss-ql element is empty".

              10:53:39,943 INFO [EJBDeployer]
              Bean : GangsterEJB
              Section: 10.6.2
              Warning: CMP entity beans may not define the implementation of a finder.

              10:53:40,003 INFO [EjbModule] Creating
              10:53:40,013 INFO [EjbModule] Deploying OrganizationEJB
              10:53:40,173 INFO [EjbModule] Deploying GangsterEJB
              10:53:40,183 INFO [EjbModule] Deploying JobEJB
              10:53:40,193 INFO [EjbModule] Deploying LocationEJB
              10:53:40,213 INFO [EjbModule] Deploying AutoNumberEJB
              10:53:40,223 INFO [EjbModule] Deploying EJBTestRunnerEJB
              10:53:40,243 INFO [EjbModule] Deploying ReadAheadEJB
              10:53:40,363 INFO [EjbModule] Created
              10:53:40,363 INFO [EjbModule] Starting
              10:53:40,654 WARN [ServiceController] Problem starting service jboss.j2ee:service=EJB,jndiName=crimeportal/Location
              org.jboss.deployment.DeploymentException: jboss-ql element is empty
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCJBossQLQueryMetaData.(JDBCJBossQLQueryMetaData.java:57)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCQueryMetaDataFactory.createJDBCQueryMetaData(JDBCQueryMetaDataFactory.java:101)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCQueryMetaDataFactory.createJDBCQueryMetaData(JDBCQueryMetaDataFactory.java:74)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCEntityMetaData.(JDBCEntityMetaData.java:555)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCApplicationMetaData.(JDBCApplicationMetaData.java:282)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCXmlFileLoader.load(JDBCXmlFileLoader.java:75)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadJDBCEntityMetaData(JDBCStoreManager.java:677)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:389)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:339)
              at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
              at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
              at org.jboss.ejb.Container.invoke(Container.java:764)
              at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:967)
              at $Proxy5.start(Unknown Source)
              at org.jboss.system.ServiceController.start(ServiceController.java:396)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
              at $Proxy20.start(Unknown Source)
              at org.jboss.ejb.EjbModule.startService(EjbModule.java:430)
              at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:164)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:967)
              at $Proxy5.start(Unknown Source)
              at org.jboss.system.ServiceController.start(ServiceController.java:396)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
              at $Proxy9.start(Unknown Source)
              at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:394)
              at org.jboss.deployment.MainDeployer.start(MainDeployer.java:802)
              at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:616)
              at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:580)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
              at $Proxy4.deploy(Unknown Source)
              at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:427)
              at org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:648)
              at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:499)
              at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:212)
              at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:225)
              at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:202)
              10:53:40,814 WARN [ServiceController] Problem starting service jboss.j2ee:service=EJB,jndiName=crimeportal/Organization
              org.jboss.deployment.DeploymentException: jboss-ql element is empty
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCJBossQLQueryMetaData.(JDBCJBossQLQueryMetaData.java:57)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCQueryMetaDataFactory.createJDBCQueryMetaData(JDBCQueryMetaDataFactory.java:101)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCQueryMetaDataFactory.createJDBCQueryMetaData(JDBCQueryMetaDataFactory.java:74)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCEntityMetaData.(JDBCEntityMetaData.java:555)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCApplicationMetaData.(JDBCApplicationMetaData.java:282)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCXmlFileLoader.load(JDBCXmlFileLoader.java:75)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadJDBCEntityMetaData(JDBCStoreManager.java:677)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:389)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:339)
              at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
              at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
              at org.jboss.ejb.Container.invoke(Container.java:764)
              at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:967)
              at $Proxy5.start(Unknown Source)
              at org.jboss.system.ServiceController.start(ServiceController.java:396)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
              at $Proxy20.start(Unknown Source)
              at org.jboss.ejb.EjbModule.startService(EjbModule.java:430)
              at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:164)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:967)
              at $Proxy5.start(Unknown Source)
              at org.jboss.system.ServiceController.start(ServiceController.java:396)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
              at $Proxy9.start(Unknown Source)
              at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:394)
              at org.jboss.deployment.MainDeployer.start(MainDeployer.java:802)
              at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:616)
              at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:580)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
              at $Proxy4.deploy(Unknown Source)
              at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:427)
              at org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:648)
              at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:499)
              at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:212)
              at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:225)
              at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:202)
              10:53:40,994 WARN [ServiceController] Problem starting service jboss.j2ee:service=EJB,jndiName=JBossUtilAutoNumber
              org.jboss.deployment.DeploymentException: jboss-ql element is empty
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCJBossQLQueryMetaData.(JDBCJBossQLQueryMetaData.java:57)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCQueryMetaDataFactory.createJDBCQueryMetaData(JDBCQueryMetaDataFactory.java:101)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCQueryMetaDataFactory.createJDBCQueryMetaData(JDBCQueryMetaDataFactory.java:74)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCEntityMetaData.(JDBCEntityMetaData.java:555)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCApplicationMetaData.(JDBCApplicationMetaData.java:282)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCXmlFileLoader.load(JDBCXmlFileLoader.java:75)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadJDBCEntityMetaData(JDBCStoreManager.java:677)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:389)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:339)
              at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
              at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
              at org.jboss.ejb.Container.invoke(Container.java:764)
              at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:967)
              at $Proxy5.start(Unknown Source)
              at org.jboss.system.ServiceController.start(ServiceController.java:396)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
              at $Proxy20.start(Unknown Source)
              at org.jboss.ejb.EjbModule.startService(EjbModule.java:430)
              at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:164)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:967)
              at $Proxy5.start(Unknown Source)
              at org.jboss.system.ServiceController.start(ServiceController.java:396)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
              at $Proxy9.start(Unknown Source)
              at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:394)
              at org.jboss.deployment.MainDeployer.start(MainDeployer.java:802)
              at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:616)
              at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:580)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
              at $Proxy4.deploy(Unknown Source)
              at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:427)
              at org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:648)
              at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:499)
              at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:212)
              at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:225)
              at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:202)
              10:53:41,154 WARN [ServiceController] Problem starting service jboss.j2ee:service=EJB,jndiName=crimeportal/Job
              org.jboss.deployment.DeploymentException: jboss-ql element is empty
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCJBossQLQueryMetaData.(JDBCJBossQLQueryMetaData.java:57)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCQueryMetaDataFactory.createJDBCQueryMetaData(JDBCQueryMetaDataFactory.java:101)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCQueryMetaDataFactory.createJDBCQueryMetaData(JDBCQueryMetaDataFactory.java:74)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCEntityMetaData.(JDBCEntityMetaData.java:555)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCApplicationMetaData.(JDBCApplicationMetaData.java:282)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCXmlFileLoader.load(JDBCXmlFileLoader.java:75)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadJDBCEntityMetaData(JDBCStoreManager.java:677)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:389)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:339)
              at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
              at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
              at org.jboss.ejb.Container.invoke(Container.java:764)
              at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:967)
              at $Proxy5.start(Unknown Source)
              at org.jboss.system.ServiceController.start(ServiceController.java:396)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
              at $Proxy20.start(Unknown Source)
              at org.jboss.ejb.EjbModule.startService(EjbModule.java:430)
              at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:164)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:967)
              at $Proxy5.start(Unknown Source)
              at org.jboss.system.ServiceController.start(ServiceController.java:396)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
              at $Proxy9.start(Unknown Source)
              at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:394)
              at org.jboss.deployment.MainDeployer.start(MainDeployer.java:802)
              at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:616)
              at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:580)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
              at $Proxy4.deploy(Unknown Source)
              at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:427)
              at org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:648)
              at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:499)
              at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:212)
              at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:225)
              at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:202)
              10:53:41,595 WARN [ServiceController] Problem starting service jboss.j2ee:service=EJB,jndiName=crimeportal/Gangster
              org.jboss.deployment.DeploymentException: jboss-ql element is empty
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCJBossQLQueryMetaData.(JDBCJBossQLQueryMetaData.java:57)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCQueryMetaDataFactory.createJDBCQueryMetaData(JDBCQueryMetaDataFactory.java:101)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCQueryMetaDataFactory.createJDBCQueryMetaData(JDBCQueryMetaDataFactory.java:74)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCEntityMetaData.(JDBCEntityMetaData.java:555)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCApplicationMetaData.(JDBCApplicationMetaData.java:282)
              at org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCXmlFileLoader.load(JDBCXmlFileLoader.java:75)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.loadJDBCEntityMetaData(JDBCStoreManager.java:677)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:389)
              at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:339)
              at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:198)
              at org.jboss.ejb.EntityContainer.start(EntityContainer.java:376)
              at org.jboss.ejb.Container.invoke(Container.java:764)
              at org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:1055)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:967)
              at $Proxy5.start(Unknown Source)
              at org.jboss.system.ServiceController.start(ServiceController.java:396)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
              at $Proxy20.start(Unknown Source)
              at org.jboss.ejb.EjbModule.startService(EjbModule.java:430)
              at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:164)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:967)
              at $Proxy5.start(Unknown Source)
              at org.jboss.system.ServiceController.start(ServiceController.java:396)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
              at $Proxy9.start(Unknown Source)
              at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:394)
              at org.jboss.deployment.MainDeployer.start(MainDeployer.java:802)
              at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:616)
              at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:580)
              at java.lang.reflect.Method.invoke(Native Method)
              at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
              at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
              at org.jboss.util.jmx.MBeanProxy.invoke(MBeanProxy.java:174)
              at $Proxy4.deploy(Unknown Source)
              at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:427)
              at org.jboss.deployment.scanner.URLDeploymentScanner.scanDirectory(URLDeploymentScanner.java:648)
              at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:499)
              at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:212)
              at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:225)
              at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:202)
              10:53:41,615 INFO [EjbModule] Started
              10:53:41,615 INFO [MainDeployer] Deployed package: file:/D:/jboss-3.0.2/server/
              default/deploy/gangster-cmp2.jar
              10:53:41,615 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
              Cause: Incomplete Deployment listing:
              Packages waiting for a deployer:

              Incompletely deployed packages:

              MBeans waiting for classes:

              MBeans waiting for other MBeans:
              [ObjectName: jboss.j2ee:service=EJB,jndiName=crimeportal/Location
              state: FAILED
              I Depend On:
              Depends On Me: org.jboss.deployment.DeploymentException: jboss-ql element is empty, ObjectName: jboss.j2ee:service=EJB,jndiName=crimeportal/Organization
              state: FAILED
              I Depend On:
              Depends On Me: org.jboss.deployment.DeploymentException: jboss-ql element is empty, ObjectName: jboss.j2ee:service=EJB,jndiName=JBossUtilAutoNumber
              state: FAILED
              I Depend On:
              Depends On Me: org.jboss.deployment.DeploymentException: jboss-ql element is empty, ObjectName: jboss.j2ee:service=EJB,jndiName=crimeportal/Job
              state: FAILED
              I Depend On:
              Depends On Me: org.jboss.deployment.DeploymentException: jboss-ql element is empty, ObjectName: jboss.j2ee:service=EJB,jndiName=crimeportal/Gangster
              state: FAILED
              I Depend On:
              Depends On Me: org.jboss.deployment.DeploymentException: jboss-ql element is empty]

              • 4. Re: Crimeportal example failed to deploy on JBoss 3 and Post
                Dain Sundstrom Master

                Does LocationEJB have an empty jboss-ql element?

                • 5. Re: Crimeportal example failed to deploy on JBoss 3 and Post
                  HauJye Tan Newbie

                  Here's an excerpt from the jbosscmp-jdbc.xml, there's is no jboss-ql elements:


                  <ejb-name>LocationEJB</ejb-name>
                  <table-name>location</table-name>

                  <cmp-field>
                  <field-name>locationId</field-name>
                  <column-name>id</column-name>
                  </cmp-field>
                  <cmp-field>
                  <field-name>description</field-name>
                  <column-name>description</column-name>
                  </cmp-field>
                  <cmp-field>
                  <field-name>street</field-name>
                  <column-name>street</column-name>
                  </cmp-field>
                  <cmp-field>
                  <field-name>city</field-name>
                  <column-name>city</column-name>
                  </cmp-field>
                  <cmp-field>
                  <field-name>state</field-name>
                  <column-name>st</column-name>
                  </cmp-field>
                  <cmp-field>
                  <field-name>zipCode</field-name>
                  <column-name>zip</column-name>
                  </cmp-field>

                  <load-groups>
                  <load-group>
                  <load-group-name>quick info</load-group-name>
                  <field-name>city</field-name>
                  <field-name>state</field-name>
                  <field-name>zipCode</field-name>
                  </load-group>
                  </load-groups>
                  <eager-load-group/>



                  And the following is extracted from the ejb-jar.xml:



                  <ejb-name>LocationEJB</ejb-name>

                  <local-home>org.jboss.docs.cmp2.crimeportal.LocationHome</local-home>
                  org.jboss.docs.cmp2.crimeportal.Location
                  <ejb-class>org.jboss.docs.cmp2.crimeportal.LocationBean</ejb-class>

                  <persistence-type>Container</persistence-type>
                  <prim-key-class>java.lang.Integer</prim-key-class>
                  False
                  <cmp-version>2.x</cmp-version>
                  <abstract-schema-name>location</abstract-schema-name>

                  <cmp-field><field-name>locationId</field-name></cmp-field>
                  <cmp-field><field-name>description</field-name></cmp-field>
                  <cmp-field><field-name>street</field-name></cmp-field>
                  <cmp-field><field-name>city</field-name></cmp-field>
                  <cmp-field><field-name>state</field-name></cmp-field>
                  <cmp-field><field-name>zipCode</field-name></cmp-field>

                  <primkey-field>locationId</primkey-field>


                  • 6. Re: Crimeportal example failed to deploy on JBoss 3 and Post
                    HauJye Tan Newbie

                    Here's an excerpt from the jbosscmp-jdbc.xml, there's is no jboss-ql elements:


                    <ejb-name>LocationEJB</ejb-name>
                    <table-name>location</table-name>

                    <cmp-field>
                    <field-name>locationId</field-name>
                    <column-name>id</column-name>
                    </cmp-field>
                    <cmp-field>
                    <field-name>description</field-name>
                    <column-name>description</column-name>
                    </cmp-field>
                    <cmp-field>
                    <field-name>street</field-name>
                    <column-name>street</column-name>
                    </cmp-field>
                    <cmp-field>
                    <field-name>city</field-name>
                    <column-name>city</column-name>
                    </cmp-field>
                    <cmp-field>
                    <field-name>state</field-name>
                    <column-name>st</column-name>
                    </cmp-field>
                    <cmp-field>
                    <field-name>zipCode</field-name>
                    <column-name>zip</column-name>
                    </cmp-field>

                    <load-groups>
                    <load-group>
                    <load-group-name>quick info</load-group-name>
                    <field-name>city</field-name>
                    <field-name>state</field-name>
                    <field-name>zipCode</field-name>
                    </load-group>
                    </load-groups>
                    <eager-load-group/>



                    And the following is extracted from the ejb-jar.xml:



                    <ejb-name>LocationEJB</ejb-name>

                    <local-home>org.jboss.docs.cmp2.crimeportal.LocationHome</local-home>
                    org.jboss.docs.cmp2.crimeportal.Location
                    <ejb-class>org.jboss.docs.cmp2.crimeportal.LocationBean</ejb-class>

                    <persistence-type>Container</persistence-type>
                    <prim-key-class>java.lang.Integer</prim-key-class>
                    False
                    <cmp-version>2.x</cmp-version>
                    <abstract-schema-name>location</abstract-schema-name>

                    <cmp-field><field-name>locationId</field-name></cmp-field>
                    <cmp-field><field-name>description</field-name></cmp-field>
                    <cmp-field><field-name>street</field-name></cmp-field>
                    <cmp-field><field-name>city</field-name></cmp-field>
                    <cmp-field><field-name>state</field-name></cmp-field>
                    <cmp-field><field-name>zipCode</field-name></cmp-field>

                    <primkey-field>locationId</primkey-field>


                    • 7. Re: Crimeportal example failed to deploy on JBoss 3 and Post
                      HauJye Tan Newbie

                      Here's an excerpt from the jbosscmp-jdbc.xml, there's is no jboss-ql elements:


                      <ejb-name>LocationEJB</ejb-name>
                      <table-name>location</table-name>

                      <cmp-field>
                      <field-name>locationId</field-name>
                      <column-name>id</column-name>
                      </cmp-field>
                      <cmp-field>
                      <field-name>description</field-name>
                      <column-name>description</column-name>
                      </cmp-field>
                      <cmp-field>
                      <field-name>street</field-name>
                      <column-name>street</column-name>
                      </cmp-field>
                      <cmp-field>
                      <field-name>city</field-name>
                      <column-name>city</column-name>
                      </cmp-field>
                      <cmp-field>
                      <field-name>state</field-name>
                      <column-name>st</column-name>
                      </cmp-field>
                      <cmp-field>
                      <field-name>zipCode</field-name>
                      <column-name>zip</column-name>
                      </cmp-field>

                      <load-groups>
                      <load-group>
                      <load-group-name>quick info</load-group-name>
                      <field-name>city</field-name>
                      <field-name>state</field-name>
                      <field-name>zipCode</field-name>
                      </load-group>
                      </load-groups>
                      <eager-load-group/>



                      And the following is extracted from the ejb-jar.xml:



                      <ejb-name>LocationEJB</ejb-name>

                      <local-home>org.jboss.docs.cmp2.crimeportal.LocationHome</local-home>
                      org.jboss.docs.cmp2.crimeportal.Location
                      <ejb-class>org.jboss.docs.cmp2.crimeportal.LocationBean</ejb-class>

                      <persistence-type>Container</persistence-type>
                      <prim-key-class>java.lang.Integer</prim-key-class>
                      False
                      <cmp-version>2.x</cmp-version>
                      <abstract-schema-name>location</abstract-schema-name>

                      <cmp-field><field-name>locationId</field-name></cmp-field>
                      <cmp-field><field-name>description</field-name></cmp-field>
                      <cmp-field><field-name>street</field-name></cmp-field>
                      <cmp-field><field-name>city</field-name></cmp-field>
                      <cmp-field><field-name>state</field-name></cmp-field>
                      <cmp-field><field-name>zipCode</field-name></cmp-field>

                      <primkey-field>locationId</primkey-field>

                      • 8. Re: Crimeportal example failed to deploy on JBoss 3 and Post
                        Dain Sundstrom Master

                        You got me. Can you file a bug report on this (assign it to dsundstrom) and I'll take a closer look at it.

                        • 9. Re: Crimeportal example failed to deploy on JBoss 3 and Post
                          HauJye Tan Newbie

                          Bug opened:
                          Request ID=609212