Problem with JBossMQ+MySQL standalone, no problem with Defau
ospri Dec 15, 2004 12:40 PMHello,
I'm currently running out of ideas of why JBossMQ (JBoss 4.0.0) standalone isn't workinng with MySQL.
Besides, with server/default config of JBoss 4.0.0+MySQL, no problem at all !!!
I explain what I've done:
Configured JBoss to use MySQL instead of hsqldb using FAQ
- Added MySQL driver to /server/default/lib
- Added /docs/examples/jca/mysql-ds.xml to /server/default/deploy
- Modified DefaultDS to MySqlDS in STANDARDJAWS.XML
- Modified <type-mapping/> to mySql in STANDARDJAWS.XML
- Modified DefaultDS to MySqlDS in STANDARDJBOSSCMP-JDBC.XML
- Modified DefaultDS to MySqlDS in LOGIN-CONFIG.XML
- Added mysql-jdbc2-service.xml to /server/default/deploy/jms
- Deleted hsqldb-jdbc2-service.xml
- Added /docs/examples/jms/mysql-jdbc2-service.xml to /server/default/deploy/jms
- Modified hsqldb-jdbc2-state-service.xml to use MySqlDS
(- Renamed hsqldb-jdbc2-state-service.xml to mysqldb-jdbc2-state-service.xml -> No harm, isn't it ? )
I do a ./run.sh -> everything runs like a charm ...
I do a ant in /docs/examples/jms/standalone directory
-> jbossmq directory created in /server -> OK
Check configuration files to see if all is configured to use MySqlDS -> OK
I do a ./run.sh -c jbossmq
and I have this :
========================================================================= JBoss Bootstrap Environment JBOSS_HOME: /usr/local/jboss-4.0.0 JAVA: /usr/java/jdk1.5.0/bin/java JAVA_OPTS: -server -Xms128m -Xmx128m -Dprogram.name=run.sh CLASSPATH: /usr/local/jboss-4.0.0/bin/run.jar:/usr/java/jdk1.5.0/lib/tools.jar ========================================================================= 18:31:35,672 INFO [Server] Starting JBoss (MX MicroKernel)... 18:31:35,674 INFO [Server] Release ID: JBoss [Zion] 4.0.0 (build: CVSTag=JBoss_4_0_0 date=200409200418) 18:31:35,675 INFO [Server] Home Dir: /usr/local/jboss-4.0.0 18:31:35,675 INFO [Server] Home URL: file:/usr/local/jboss-4.0.0/ 18:31:35,676 INFO [Server] Library URL: file:/usr/local/jboss-4.0.0/lib/ 18:31:35,678 INFO [Server] Patch URL: null 18:31:35,678 INFO [Server] Server Name: jbossmq 18:31:35,679 INFO [Server] Server Home Dir: /usr/local/jboss-4.0.0/server/jbossmq 18:31:35,679 INFO [Server] Server Home URL: file:/usr/local/jboss-4.0.0/server/jbossmq/ 18:31:35,680 INFO [Server] Server Data Dir: /usr/local/jboss-4.0.0/server/jbossmq/data 18:31:35,680 INFO [Server] Server Temp Dir: /usr/local/jboss-4.0.0/server/jbossmq/tmp 18:31:35,681 INFO [Server] Server Config URL: file:/usr/local/jboss-4.0.0/server/jbossmq/conf/ 18:31:35,681 INFO [Server] Server Library URL: file:/usr/local/jboss-4.0.0/server/jbossmq/lib/ 18:31:35,682 INFO [Server] Root Deployment Filename: jboss-service.xml 18:31:35,687 INFO [Server] Starting General Purpose Architecture (GPA)... 18:31:36,178 INFO [ServerInfo] Java version: 1.5.0,Sun Microsystems Inc. 18:31:36,178 INFO [ServerInfo] Java VM: Java HotSpot(TM) Server VM 1.5.0-b64,Sun Microsystems Inc. 18:31:36,178 INFO [ServerInfo] OS-System: Linux 2.6.9-1.667smp,i386 18:31:37,059 INFO [Server] Core system initialized 18:31:38,681 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resource:log4j.xml 18:31:39,184 INFO [NamingService] Started jnpPort=1099, rmiPort=0, backlog=50, bindAddress=null, Client SocketFactory=null, Server SocketFactory=org.jboss.net.sockets.DefaultSocketFactory@ad093076 18:31:40,956 ERROR [URLDeploymentScanner] Incomplete Deployment listing:Packages waiting for a deployer: org.jboss.deployment.DeploymentInfo@a95c6f66 { url=file:/usr/local/jboss-4.0.0/server/jbossmq/deploy/jboss-local-jdbc.rar } deployer: null status: null state: INIT_WAITING_DEPLOYER watch: file:/usr/local/jboss-4.0.0/server/jbossmq/deploy/jboss-local-jdbc.rar altDD: null lastDeployed: 1103131899475 lastModified: 1103131899000 mbeans: org.jboss.deployment.DeploymentInfo@1ae9d639 { url=file:/usr/local/jboss-4.0.0/server/jbossmq/deploy/hsqldb-ds.xml } deployer: null status: null state: INIT_WAITING_DEPLOYER watch: file:/usr/local/jboss-4.0.0/server/jbossmq/deploy/hsqldb-ds.xml altDD: null lastDeployed: 1103131899484 lastModified: 1103131899000 mbeans: org.jboss.deployment.DeploymentInfo@a91bffa1 { url=file:/usr/local/jboss-4.0.0/server/jbossmq/deploy/mysql-ds.xml } deployer: null status: null state: INIT_WAITING_DEPLOYER watch: file:/usr/local/jboss-4.0.0/server/jbossmq/deploy/mysql-ds.xml altDD: null lastDeployed: 1103131899488 lastModified: 1103131899000 mbeans: Incompletely deployed packages: org.jboss.deployment.DeploymentInfo@a95c6f66 { url=file:/usr/local/jboss-4.0.0/server/jbossmq/deploy/jboss-local-jdbc.rar } deployer: null status: null state: INIT_WAITING_DEPLOYER watch: file:/usr/local/jboss-4.0.0/server/jbossmq/deploy/jboss-local-jdbc.rar altDD: null lastDeployed: 1103131899475 lastModified: 1103131899000 mbeans: org.jboss.deployment.DeploymentInfo@1ae9d639 { url=file:/usr/local/jboss-4.0.0/server/jbossmq/deploy/hsqldb-ds.xml } deployer: null status: null state: INIT_WAITING_DEPLOYER watch: file:/usr/local/jboss-4.0.0/server/jbossmq/deploy/hsqldb-ds.xml altDD: null lastDeployed: 1103131899484 lastModified: 1103131899000 mbeans: org.jboss.deployment.DeploymentInfo@a91bffa1 { url=file:/usr/local/jboss-4.0.0/server/jbossmq/deploy/mysql-ds.xml } deployer: null status: null state: INIT_WAITING_DEPLOYER watch: file:/usr/local/jboss-4.0.0/server/jbossmq/deploy/mysql-ds.xml altDD: null lastDeployed: 1103131899488 lastModified: 1103131899000 mbeans: MBeans waiting for other MBeans: ObjectName: jboss.mq:service=DestinationManager state: CONFIGURED I Depend On: jboss.mq:service=MessageCache jboss.mq:service=PersistenceManager jboss.mq:service=StateManager Depends On Me: jboss.mq.destination:service=Queue,name=ToValidate jboss.mq.destination:service=Queue,name=ToCheck jboss.mq.destination:service=Queue,name=ToNotify jboss.mq.destination:service=Queue,name=ToProcess jboss.mq.destination:service=Topic,name=SynchronousResponse jboss.mq.destination:service=Queue,name=ToLog jboss.mq:service=SecurityManager jboss.mq.destination:service=Queue,name=DLQ ObjectName: jboss.mq:service=PersistenceManager state: CONFIGURED I Depend On: jboss.jca:service=DataSourceBinding,name=MySqlDS Depends On Me: jboss.mq:service=DestinationManager ObjectName: jboss.mq:service=InvocationLayer,type=UIL2 state: CONFIGURED I Depend On: jboss.mq:service=Invoker Depends On Me: ObjectName: jboss.mq.destination:service=Queue,name=ToValidate state: CONFIGURED I Depend On: jboss.mq:service=DestinationManager jboss.mq:service=SecurityManager Depends On Me: ObjectName: jboss.mq.destination:service=Queue,name=ToCheck state: CONFIGURED I Depend On: jboss.mq:service=DestinationManager jboss.mq:service=SecurityManager Depends On Me: ObjectName: jboss.mq.destination:service=Queue,name=ToNotify state: CONFIGURED I Depend On: jboss.mq:service=DestinationManager jboss.mq:service=SecurityManager Depends On Me: ObjectName: jboss.mq.destination:service=Queue,name=ToProcess state: CONFIGURED I Depend On: jboss.mq:service=DestinationManager jboss.mq:service=SecurityManager Depends On Me: ObjectName: jboss.mq.destination:service=Topic,name=SynchronousResponse state: CONFIGURED I Depend On: jboss.mq:service=DestinationManager jboss.mq:service=SecurityManager Depends On Me: ObjectName: jboss.mq.destination:service=Queue,name=ToLog state: CONFIGURED I Depend On: jboss.mq:service=DestinationManager jboss.mq:service=SecurityManager Depends On Me: ObjectName: jboss.mq:service=Invoker state: CONFIGURED I Depend On: jboss.mq:service=TracingInterceptor Depends On Me: jboss.mq:service=InvocationLayer,type=UIL2 ObjectName: jboss.mq:service=TracingInterceptor state: CONFIGURED I Depend On: jboss.mq:service=SecurityManager Depends On Me: jboss.mq:service=Invoker ObjectName: jboss.mq:service=SecurityManager state: CONFIGURED I Depend On: jboss.mq:service=DestinationManager Depends On Me: jboss.mq.destination:service=Queue,name=ToValidate jboss.mq.destination:service=Queue,name=ToCheck jboss.mq.destination:service=Queue,name=ToNotify jboss.mq.destination:service=Queue,name=ToProcess jboss.mq.destination:service=Topic,name=SynchronousResponse jboss.mq.destination:service=Queue,name=ToLog jboss.mq:service=TracingInterceptor jboss.mq.destination:service=Queue,name=DLQ ObjectName: jboss.mq.destination:service=Queue,name=DLQ state: CONFIGURED I Depend On: jboss.mq:service=DestinationManager jboss.mq:service=SecurityManager Depends On Me: ObjectName: jboss.mq:service=StateManager state: CONFIGURED I Depend On: jboss.jca:service=DataSourceBinding,name=MySqlDS Depends On Me: jboss.mq:service=DestinationManager MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM: ObjectName: jboss.jca:service=DataSourceBinding,name=MySqlDS state: NOTYETINSTALLED I Depend On: Depends On Me: jboss.mq:service=PersistenceManager jboss.mq:service=StateManager 18:31:41,177 INFO [Server] JBoss (MX MicroKernel) [4.0.0 (build: CVSTag=JBoss_4_0_0 date=200409200418)] Started in 5s:490ms
I'm afraid I don't understand what's going on ... MySqlDS should be INSTALLED, cause it is installed if I run the Default config ...
If someone out there has the solution ... well ... I'd like to share it with you, LOL
Thanks
Have a nice day !!!