3 Replies Latest reply on Apr 12, 2009 12:18 AM by Daniel Bevenius

    Encounter problem while switching to MySQL 5.

    Leon Xu Newbie

      Hi,guys
      I'm new to the JBossESB and I tried to swtich the default database to MySQL 5.
      I firstly installed the JBoss AS 4.22, configure the database to MySql. And I write a program to test and everythings goes okay. Here I still keep the "hsqldb-ds.xml" in the deploy directory and also add the "mysql-ds.xml".

      Then I installed the JBossESB 4.5 to my AS and configure all those xml files as the Administration Guide has described. In the mysql database I'm using JBossESBDB, juddidb and jbpmesbdb

      But when I start the server, I encoutered the following problems:

      16:32:42,573 ERROR [URLDeploymentScanner] Incomplete Deployment listing:

      --- Packages waiting for a deployer ---
      org.jboss.deployment.DeploymentInfo@3d7727cb { url=file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/jbossesb.esb/ }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER
      watch: file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/jbossesb.esb/
      altDD: null
      lastDeployed: 1239093162557
      lastModified: 1239086433698
      mbeans:

      org.jboss.deployment.DeploymentInfo@eeb826d3 { url=file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/jbpm.esb/ }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER
      watch: file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/jbpm.esb/
      altDD: null
      lastDeployed: 1239093162557
      lastModified: 1239087397979
      mbeans:

      org.jboss.deployment.DeploymentInfo@eb92df01 { url=file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/jbrules.esb/ }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER
      watch: file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/jbrules.esb/
      altDD: null
      lastDeployed: 1239093162557
      lastModified: 1239080742500
      mbeans:

      org.jboss.deployment.DeploymentInfo@cd03c240 { url=file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/management.esb }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER
      watch: file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/management.esb
      altDD: null
      lastDeployed: 1239093162573
      lastModified: 1239093162573
      mbeans:

      org.jboss.deployment.DeploymentInfo@bfd93180 { url=file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/slsb.esb/ }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER
      watch: file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/slsb.esb/
      altDD: null
      lastDeployed: 1239093162573
      lastModified: 1239080748390
      mbeans:

      org.jboss.deployment.DeploymentInfo@13174a86 { url=file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/smooks.esb/ }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER
      watch: file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/smooks.esb/
      altDD: null
      lastDeployed: 1239093162573
      lastModified: 1239080746203
      mbeans:

      org.jboss.deployment.DeploymentInfo@5730663d { url=file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/soap.esb/ }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER
      watch: file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/soap.esb/
      altDD: null
      lastDeployed: 1239093162573
      lastModified: 1239080748359
      mbeans:

      org.jboss.deployment.DeploymentInfo@c7b267fb { url=file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/spring.esb/ }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER
      watch: file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/spring.esb/
      altDD: null
      lastDeployed: 1239093162573
      lastModified: 1239080746437
      mbeans:

      --- Incompletely deployed packages ---
      org.jboss.deployment.DeploymentInfo@3d7727cb { url=file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/jbossesb.esb/ }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER
      watch: file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/jbossesb.esb/
      altDD: null
      lastDeployed: 1239093162557
      lastModified: 1239086433698
      mbeans:

      org.jboss.deployment.DeploymentInfo@eeb826d3 { url=file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/jbpm.esb/ }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER
      watch: file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/jbpm.esb/
      altDD: null
      lastDeployed: 1239093162557
      lastModified: 1239087397979
      mbeans:

      org.jboss.deployment.DeploymentInfo@eb92df01 { url=file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/jbrules.esb/ }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER
      watch: file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/jbrules.esb/
      altDD: null
      lastDeployed: 1239093162557
      lastModified: 1239080742500
      mbeans:

      org.jboss.deployment.DeploymentInfo@cd03c240 { url=file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/management.esb }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER
      watch: file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/management.esb
      altDD: null
      lastDeployed: 1239093162573
      lastModified: 1239093162573
      mbeans:

      org.jboss.deployment.DeploymentInfo@bfd93180 { url=file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/slsb.esb/ }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER
      watch: file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/slsb.esb/
      altDD: null
      lastDeployed: 1239093162573
      lastModified: 1239080748390
      mbeans:

      org.jboss.deployment.DeploymentInfo@13174a86 { url=file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/smooks.esb/ }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER
      watch: file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/smooks.esb/
      altDD: null
      lastDeployed: 1239093162573
      lastModified: 1239080746203
      mbeans:

      org.jboss.deployment.DeploymentInfo@5730663d { url=file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/soap.esb/ }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER
      watch: file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/soap.esb/
      altDD: null
      lastDeployed: 1239093162573
      lastModified: 1239080748359
      mbeans:

      org.jboss.deployment.DeploymentInfo@c7b267fb { url=file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/spring.esb/ }
      deployer: null
      status: null
      state: INIT_WAITING_DEPLOYER
      watch: file:/E:/Development/jboss-4.2.2.GA/server/default/deploy/spring.esb/
      altDD: null
      lastDeployed: 1239093162573
      lastModified: 1239080746437
      mbeans:

      --- MBeans waiting for other MBeans ---
      ObjectName: jboss.esb:service=JuddiRMI
      State: CONFIGURED
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=juddiDB
      jboss.esb:service=PropertyService
      Depends On Me:
      jboss.esb:service=ESBDeployer

      ObjectName: jboss.esb:service=ESBDeployer
      State: CONFIGURED
      I Depend On:
      jboss.esb:service=ESBRegistry
      jboss.esb:service=JuddiRMI
      Depends On Me:
      jboss.esb:service=SoapUIClientService

      ObjectName: jboss.esb:service=SoapUIClientService
      State: CONFIGURED
      I Depend On:
      jboss.esb:service=ESBDeployer

      ObjectName: jboss.jca:service=LocalTxCM,name=juddiDB
      State: CONFIGURED
      I Depend On:
      jboss.jca:service=ManagedConnectionPool,name=juddiDB
      jboss.jca:service=CachedConnectionManager
      jboss:service=TransactionManager
      Depends On Me:
      jboss.jca:service=DataSourceBinding,name=juddiDB

      ObjectName: jboss.jca:service=ManagedConnectionPool,name=juddiDB
      State: CONFIGURED
      I Depend On:
      jboss.jca:service=ManagedConnectionFactory,name=juddiDB
      Depends On Me:
      jboss.jca:service=LocalTxCM,name=juddiDB

      ObjectName: jboss.jca:service=ManagedConnectionFactory,name=juddiDB
      State: CONFIGURED
      I Depend On:
      jboss:service=MySql,database=juddiDB
      jboss.jca:service=RARDeployment,name='jboss-local-jdbc.rar'
      Depends On Me:
      jboss.jca:service=ManagedConnectionPool,name=juddiDB

      ObjectName: jboss.jca:service=DataSourceBinding,name=juddiDB
      State: CONFIGURED
      I Depend On:
      jboss.jca:service=LocalTxCM,name=juddiDB
      Depends On Me:
      jboss.esb:service=JuddiRMI

      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
      ObjectName: jboss:service=MySql,database=juddiDB
      State: NOTYETINSTALLED
      Depends On Me:
      jboss.jca:service=ManagedConnectionFactory,name=juddiDB


      16:32:42,666 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
      16:32:42,682 INFO [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
      16:32:42,713 INFO [Server] JBoss (MX MicroKernel) [4.2.2.GA (build: SVNTag=JBoss_4_2_2_GA date=200710221139)] Started in 32s:281ms


      Is it because the juddiDB haven't been binding to the datasource? I spent almost a day on this problem but yet got no solution. please help me. Many Thanks