JBossMQ using MySQL
mailaxl May 4, 2005 1:24 PMI am trying to change the database used by jbossMQ to mysql. I have taken the following steps.
1.Copied $JBOSS_HOME/server/default directory to $JBOSS_HOME/server/jbossmq_mysql;
2.Added mysql-connector-java-3.1.8-bin.jar to jbossmq_mysql/lib
3.Copied /docs/examples/jca/mysql-ds.xml to jbossmq_mysql/deploy/
4.Copied /docs/examples/jms/mysql-jdbc2-service.xml to jbossmq_mysql/deploy/jms/
5.Removed hsqldb-jdbc2-service.xml
6.Renamed jbossmq_mysql/deploy/jms/hsql-jdbc2-state-service.xml to mysql-jdbc2-state-service.xml
7.Modified mysql-ds.xml. Changed connection-url,username and password.
8.Modified DefaultDS to MySqlDS(jndi-name in mysql-ds.xml) in:
jbossmq_mysql/conf/standardjaws.xml
jbossmq_mysql/conf/standardjbosscmp-jdbc.xml
jbossmq_mysql/conf/login-config.xml
jbossmq_mysql/deploy/jms/mysql-jdbc2-state-service.xml
9.Also modified type mapping to mySQL(type-mapping in mysql-ds.xml) in
jbossmq_mysql/conf/standardjaws.xml
When I do a ./run.sh -c jbossmq_mysql i get the following error
11:28:53,743 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
MBeans waiting for other MBeans:
ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
state: CONFIGURED
I Depend On: jboss:service=TransactionManager
jboss.jca:name=DefaultDS,service=DataSourceBinding
Depends On Me:
MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
ObjectName: jboss.jca:name=DefaultDS,service=DataSourceBinding
state: NOTYETINSTALLED
I Depend On:
Depends On Me: jboss:service=KeyGeneratorFactory,type=HiLo
I did not find this line anywhere in the jbossmq_mysql directory ?jboss:service=KeyGeneratorFactory? . May be it's in rar file or something. Can anyone tell me what i might be missing or point to some resources where i can read about this service.
The datasource works fine and jboss successfully created the following tables on startup:
| jms_messages | jms_roles | jms_subscriptions | jms_transactions |
| jms_users | timers |
The complete output for ./run.sh -c jbossmq_mysql:
=========================================================================
JBoss Bootstrap Environment
JBOSS_HOME: /services/jboss
JAVA: /services/support/java/bin/java
JAVA_OPTS: -server -Xms512m -Xmx512m -Dprogram.name=run.sh
CLASSPATH: /services/jboss/bin/run.jar:/services/support/java/lib/tools.jar
=========================================================================
11:28:37,233 INFO [Server] Starting JBoss (MX MicroKernel)...
11:28:37,234 INFO [Server] Release ID: JBoss [Zion] 4.0.1sp1 (build: CVSTag=JBoss_4_0_1_SP1 date=200502160314)
11:28:37,235 INFO [Server] Home Dir: /services/jboss-4.0.1sp1
11:28:37,235 INFO [Server] Home URL: file:/services/jboss-4.0.1sp1/
11:28:37,235 INFO [Server] Library URL: file:/services/jboss-4.0.1sp1/lib/
11:28:37,236 INFO [Server] Patch URL: null
11:28:37,236 INFO [Server] Server Name: jbossmq_mysql
11:28:37,236 INFO [Server] Server Home Dir: /services/jboss-4.0.1sp1/server/jbossmq_mysql
11:28:37,237 INFO [Server] Server Home URL: file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/
11:28:37,237 INFO [Server] Server Data Dir: /services/jboss-4.0.1sp1/server/jbossmq_mysql/data
11:28:37,237 INFO [Server] Server Temp Dir: /services/jboss-4.0.1sp1/server/jbossmq_mysql/tmp
11:28:37,237 INFO [Server] Server Config URL: file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/conf/
11:28:37,237 INFO [Server] Server Library URL: file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/lib/
11:28:37,238 INFO [Server] Root Deployment Filename: jboss-service.xml
11:28:37,241 INFO [Server] Starting General Purpose Architecture (GPA)...
11:28:37,648 INFO [ServerInfo] Java version: 1.4.2_07,Sun Microsystems Inc.
11:28:37,648 INFO [ServerInfo] Java VM: Java HotSpot(TM) Server VM 1.4.2_07-b05,Sun Microsystems Inc.
11:28:37,648 INFO [ServerInfo] OS-System: Linux 2.4.21-27.0.4.ELsmp,i386
11:28:38,012 INFO [Server] Core system initialized
11:28:40,110 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resource:log4j.xml
11:28:40,207 INFO [WebService] Using RMI server codebase: http://myndi.net.ku.edu:8083/
11:28:40,452 INFO [NamingService] Started jndi bootstrap jnpPort=1099, rmiPort=1098, backlog=50, bindAddress=/0.0.0.0, Client SocketFactory=null, Server SocketFactory=org.jboss.net.sockets.DefaultSocketFactory@ad093076
11:28:44,654 INFO [Embedded] Catalina naming disabled
11:28:45,498 INFO [Http11Protocol] Initializing Coyote HTTP/1.1 on http-0.0.0.0-8080
11:28:45,538 INFO [Catalina] Initialization processed in 760 ms
11:28:45,540 INFO [StandardService] Starting service jboss.web
11:28:45,546 INFO [StandardEngine] Starting Servlet Engine: Apache Tomcat/5.0.28
11:28:45,581 INFO [StandardHost] XML validation disabled
11:28:45,608 INFO [Catalina] Server startup in 69 ms
11:28:45,824 INFO [TomcatDeployer] deploy, ctxPath=/invoker, warUrl=file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/http-invoker.sar/invoker.war/
11:28:46,810 INFO [TomcatDeployer] deploy, ctxPath=/ws4ee, warUrl=file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/tmp/deploy/tmp54004jboss-ws4ee.war/
11:28:46,931 INFO [TomcatDeployer] deploy, ctxPath=/, warUrl=file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/jbossweb-tomcat50.sar/ROOT.war/
11:28:47,101 INFO [TomcatDeployer] deploy, ctxPath=/jbossmq-httpil, warUrl=file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
11:28:49,146 INFO [MailService] Mail Service bound to java:/Mail
11:28:49,595 INFO [RARDeployment] Required license terms exist view the META-INF/ra.xml: file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/jboss-local-jdbc.rar
11:28:49,807 INFO [RARDeployment] Required license terms exist view the META-INF/ra.xml: file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/jboss-xa-jdbc.rar
11:28:50,020 INFO [RARDeployment] Required license terms exist view the META-INF/ra.xml: file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/jms/jms-ra.rar
11:28:50,335 INFO [RARDeployment] Required license terms exist view the META-INF/ra.xml: file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/mail-ra.rar
11:28:50,875 INFO [ConnectionFactoryBindingService] Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:name=JmsXA,service=ConnectionFactoryBinding to JNDI name 'java:JmsXA'
11:28:51,193 INFO [WrapperDataSourceService] Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:name=MySqlDS,service=DataSourceBinding to JNDI name 'java:MySqlDS'
11:28:52,427 INFO [A] Bound to JNDI name: queue/A
11:28:52,431 INFO [B] Bound to JNDI name: queue/B
11:28:52,435 INFO [C] Bound to JNDI name: queue/C
11:28:52,439 INFO [D] Bound to JNDI name: queue/D
11:28:52,443 INFO [ex] Bound to JNDI name: queue/ex
11:28:52,493 INFO [testTopic] Bound to JNDI name: topic/testTopic
11:28:52,498 INFO [securedTopic] Bound to JNDI name: topic/securedTopic
11:28:52,502 INFO [testDurableTopic] Bound to JNDI name: topic/testDurableTopic
11:28:52,508 INFO [primaryCDR] Bound to JNDI name: topic/primaryCDR
11:28:52,513 INFO [gnr] Bound to JNDI name: topic/gnr
11:28:52,518 INFO [testQueue] Bound to JNDI name: queue/testQueue
11:28:52,619 INFO [UILServerILService] JBossMQ UIL service available at : /0.0.0.0:8093
11:28:52,707 INFO [DLQ] Bound to JNDI name: queue/DLQ
11:28:52,758 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/jmx-console.war/
11:28:52,976 INFO [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=file:/services/jboss-4.0.1sp1/server/jbossmq_mysql/deploy/management/web-console.war/
11:28:53,743 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
MBeans waiting for other MBeans:
ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
state: CONFIGURED
I Depend On: jboss:service=TransactionManager
jboss.jca:name=DefaultDS,service=DataSourceBinding
Depends On Me:
MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM:
ObjectName: jboss.jca:name=DefaultDS,service=DataSourceBinding
state: NOTYETINSTALLED
I Depend On:
Depends On Me: jboss:service=KeyGeneratorFactory,type=HiLo
11:28:53,866 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
11:28:54,007 INFO [ChannelSocket] JK2: ajp13 listening on /0.0.0.0:8009
11:28:54,013 INFO [JkMain] Jk running ID=0 time=0/48 config=null
11:28:54,031 INFO [Server] JBoss (MX MicroKernel) [4.0.1sp1 (build: CVSTag=JBoss_4_0_1_SP1 date=200502160314)] Started in 16s:586ms