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

Encounter problem while switching to MySQL 5.

xpcoder Apr 7, 2009 5:03 AM

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

1. Re: Encounter problem while switching to MySQL 5.

tcunning Apr 7, 2009 1:55 PM (in response to xpcoder)

I think you also have to change this line in jbossesb.sar/esb.juddi.xml :

juddi-sql/hsqldb/create_database.sql,juddi-sql/hsqldb/import.sql

so that it refers to the mysql versions of the files.
Actions
2. Re: Encounter problem while switching to MySQL 5.

xpcoder Apr 11, 2009 10:59 AM (in response to xpcoder)

"tcunning" wrote:
I think you also have to change this line in jbossesb.sar/esb.juddi.xml :

<entry key="juddi.sqlFiles">juddi-sql/hsqldb/create_database.sql,juddi-sql/hsqldb/import.sql</entry>

so that it refers to the mysql versions of the files.

I did that part already..still not working
Actions
3. Re: Encounter problem while switching to MySQL 5.

beve Apr 12, 2009 12:18 AM (in response to xpcoder)

Hi,

the error message that you posted is just the about which services did not deploy and does not tell you the initial reason why they failed to deploy.
If you look higher up in the console output or look in server.log you should see a more detailed message about what is causing this.

Regards,

/Daniel
Actions

Go to original post