Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

mysql as DefaultDS in jboss

6 views
Skip to first unread message

moo...@wp.pl

unread,
Jun 20, 2006, 9:46:08 AM6/20/06
to
hi!
I have huge problem configuring jboss to use mysql as a default
database.
I've made a lot of researches on how to do it but something is still
wrong.
I work with Jboss 4.0.4, mysql 5.0, connector/j 3.1.13
Following the instruction on the ONjava web site
http://www.onjava.com/pub/a/onjava/2004/02/25/jbossjdbc.html
I'm occuring such a results by starting up server from eclipse:


14:55:30,414 INFO [Server] Starting JBoss (MX MicroKernel)...
14:55:30,414 INFO [Server] Release ID: JBoss [Zion] 4.0.4.CR2 (build:
CVSTag=JBoss_4_0_4_CR2 date=200603311500)
14:55:30,424 INFO [Server] Home Dir: C:\j2eeServer
14:55:30,424 INFO [Server] Home URL: file:/C:/j2eeServer/
14:55:30,424 INFO [Server] Patch URL: null
14:55:30,424 INFO [Server] Server Name: default
14:55:30,424 INFO [Server] Server Home Dir:
C:\j2eeServer\server\default
14:55:30,424 INFO [Server] Server Home URL:
file:/C:/j2eeServer/server/default/
14:55:30,424 INFO [Server] Server Log Dir:
C:\j2eeServer\server\default\log
14:55:30,424 INFO [Server] Server Temp Dir:
C:\j2eeServer\server\default\tmp
14:55:30,424 INFO [Server] Root Deployment Filename: jboss-service.xml
14:55:31,015 INFO [ServerInfo] Java version: 1.5.0_06,Sun Microsystems
Inc.
14:55:31,015 INFO [ServerInfo] Java VM: Java HotSpot(TM) Client VM
1.5.0_06-b05,Sun Microsystems Inc.
14:55:31,015 INFO [ServerInfo] OS-System: Windows XP 5.1,x86
14:55:32,197 INFO [Server] Core system initialized
14:55:34,640 INFO [WebService] Using RMI server codebase:
http://moor2:8083/
14:55:34,681 INFO [Log4jService$URLWatchTimerTask] Configuring from
URL: resource:log4j.xml
14:55:35,081 INFO [NamingService] JNDI bootstrap JNP=/0.0.0.0:1099,
RMI=/0.0.0.0:1098, backlog=50, no client SocketFactory, Server
SocketFactory=class org.jboss.net.sockets.DefaultSocketFactory
14:55:39,247 INFO [Embedded] Catalina naming disabled
14:55:39,407 INFO [ClusterRuleSetFactory] Unable to find a cluster
rule set in the classpath. Will load the default rule set.
14:55:39,407 INFO [ClusterRuleSetFactory] Unable to find a cluster
rule set in the classpath. Will load the default rule set.
14:55:39,918 INFO [Http11BaseProtocol] Initializing Coyote HTTP/1.1 on
http-0.0.0.0-8080
14:55:39,918 INFO [Catalina] Initialization processed in 511 ms
14:55:39,918 INFO [StandardService] Starting service jboss.web
14:55:39,928 INFO [StandardEngine] Starting Servlet Engine: Apache
Tomcat/5.5.16
14:55:40,018 INFO [StandardHost] XML validation disabled
14:55:40,078 INFO [Catalina] Server startup in 160 ms
14:55:40,309 INFO [TomcatDeployer] deploy, ctxPath=/invoker,
warUrl=.../deploy/http-invoker.sar/invoker.war/
14:55:40,839 INFO [WebappLoader] Dual registration of jndi stream
handler: factory already defined
14:55:41,480 INFO [TomcatDeployer] deploy, ctxPath=/,
warUrl=.../deploy/jbossweb-tomcat55.sar/ROOT.war/
14:55:42,962 INFO [TomcatDeployer] deploy, ctxPath=/jbossws,
warUrl=.../tmp/deploy/tmp5407jbossws-exp.war/
14:55:43,263 INFO [SubscriptionManager] Bound event dispatcher to
java:comp/env/EventDispatcher
14:55:43,573 INFO [TomcatDeployer] deploy, ctxPath=/jbossmq-httpil,
warUrl=.../deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
14:55:46,377 INFO [TomcatDeployer] deploy, ctxPath=/web-console,
warUrl=.../deploy/management/console-mgr.sar/web-console.war/
14:55:47,479 INFO [MailService] Mail Service bound to java:/Mail
14:55:47,769 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/jboss-ha-local-jdbc.rar
14:55:47,849 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/jboss-ha-xa-jdbc.rar
14:55:47,940 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar
14:55:48,020 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/jboss-xa-jdbc.rar
14:55:48,120 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/jms/jms-ra.rar
14:55:48,200 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/mail-ra.rar
14:55:48,661 INFO [ConnectionFactoryBindingService] Bound
ConnectionManager
'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name
'java:JmsXA'
14:55:48,941 INFO [ConnectionFactoryBindingService] Bound
ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS'
to JNDI name 'java:DefaultDS'
14:55:49,963 WARN [ServiceController] Problem starting service
jboss.mq:service=PersistenceManager
org.jboss.mq.SpyJMSException: Could not resolve uncommited
transactions. Message recovery may not be accurate; - nested
throwable: (java.sql.SQLException: Every derived table must have its
own alias)
at
org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:442)
at
org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1571)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:260)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
at $Proxy0.start(Unknown Source)
at
org.jboss.system.ServiceController.start(ServiceController.java:417)
at
org.jboss.system.ServiceController.start(ServiceController.java:435)
at
org.jboss.system.ServiceController.start(ServiceController.java:435)
at
org.jboss.system.ServiceController.start(ServiceController.java:435)
at
org.jboss.system.ServiceController.start(ServiceController.java:435)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:260)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:190)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:260)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at
org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:287)
at $Proxy41.start(Unknown Source)
at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:198)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1007)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:808)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:771)
at sun.reflect.GeneratedMethodAccessor50.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:260)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:190)
at $Proxy8.deploy(Unknown Source)
at
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:334)
at
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:522)
at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:207)
at
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:280)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:260)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at
org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
at $Proxy0.start(Unknown Source)
at
org.jboss.system.ServiceController.start(ServiceController.java:417)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:260)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:190)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1007)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:808)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:771)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:755)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at
org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:260)
at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:190)
at $Proxy5.deploy(Unknown Source)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
at org.jboss.Main.boot(Main.java:200)
at org.jboss.Main$1.run(Main.java:464)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Every derived table must have its own
alias
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3004)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1128)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1222)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
at
org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:403)
... 111 more
14:55:50,133 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console,
warUrl=.../deploy/jmx-console.war/
14:55:50,333 ERROR [URLDeploymentScanner] Incomplete Deployment
listing:

--- MBeans waiting for other MBeans ---
ObjectName: jboss.mq:service=PersistenceManager
State: FAILED
Reason: org.jboss.mq.SpyJMSException: Could not resolve uncommited
transactions. Message recovery may not be accurate; - nested
throwable: (java.sql.SQLException: Every derived table must have its
own alias)
I Depend On:
jboss.jca:service=DataSourceBinding,name=DefaultDS
Depends On Me:
jboss.mq:service=DestinationManager

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.mq:service=PersistenceManager
State: FAILED
Reason: org.jboss.mq.SpyJMSException: Could not resolve uncommited
transactions. Message recovery may not be accurate; - nested
throwable: (java.sql.SQLException: Every derived table must have its
own alias)
I Depend On:
jboss.jca:service=DataSourceBinding,name=DefaultDS
Depends On Me:
jboss.mq:service=DestinationManager


14:55:50,553 INFO [Http11BaseProtocol] Starting Coyote HTTP/1.1 on
http-0.0.0.0-8080
14:55:51,585 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
14:55:51,625 INFO [JkMain] Jk running ID=0 time=0/130 config=null
14:55:51,645 INFO [Server] JBoss (MX MicroKernel) [4.0.4.CR2 (build:
CVSTag=JBoss_4_0_4_CR2 date=200603311500)] Started in 21s:211ms

Please, Can anyone help me?
Marek

JScoobyCed

unread,
Jun 20, 2006, 9:26:59 PM6/20/06
to
moo...@wp.pl wrote:
> hi!
> I have huge problem configuring jboss to use mysql as a default
> database.
> I've made a lot of researches on how to do it but something is still
> wrong.
> I work with Jboss 4.0.4, mysql 5.0, connector/j 3.1.13
> Following the instruction on the ONjava web site
> http://www.onjava.com/pub/a/onjava/2004/02/25/jbossjdbc.html

This website is fine, but not complete for the task you want to do.

> I'm occuring such a results by starting up server from eclipse:

> [...]


> 14:55:48,941 INFO [ConnectionFactoryBindingService] Bound
> ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS'
> to JNDI name 'java:DefaultDS'

Here it seems your datasource is correctly bound. Is DefaultDS a MySQL
database or a HyperSonic SQL database?

> 14:55:49,963 WARN [ServiceController] Problem starting service
> jboss.mq:service=PersistenceManager
> org.jboss.mq.SpyJMSException: Could not resolve uncommited
> transactions. Message recovery may not be accurate; - nested
> throwable: (java.sql.SQLException: Every derived table must have its
> own alias)

If you have modified the DefaultDS to connect a MySQL database, it won't
work. Here your stack trace shows there is a problem with JMS. If you
look at the folder (if you run the 'default' configuration):
<path-to-jboss>\server\default\deploy\jms
there is a file 'hsqldb-jdbc-state-service.xml'
you need to replace it with the file:
<path-to-jboss>\docs\examples\jms\mysql-jdbc2-service.xml

But this file uses the MySQLDS datasource, not DefaultDS, so you need to
edit it and change MySQLDS by DefaultDS to follow you settings.

There might have other files needing similar changes in other services
deployed by JBoss.
Good luck.

--
JSC

moo...@wp.pl

unread,
Jun 21, 2006, 9:21:50 AM6/21/06
to
hi there!!!
Thanks for Your quick answer

> Here it seems your datasource is correctly bound. Is DefaultDS a MySQL
> database or a HyperSonic SQL database?

HyperSonic was default. Now, I deleted Hsqldb-ds.xml from the deploy
folder.

> If you have modified the DefaultDS to connect a MySQL database, it won't
> work. Here your stack trace shows there is a problem with JMS. If you
> look at the folder (if you run the 'default' configuration):
> <path-to-jboss>\server\default\deploy\jms
> there is a file 'hsqldb-jdbc-state-service.xml'
> you need to replace it with the file:
> <path-to-jboss>\docs\examples\jms\mysql-jdbc2-service.xml

there are two similar files:
1. 'hsqldb-jdbc-state-service.xml' --> this I replaced with the mysql
one from examples
and changed MySQLDS to DefaultDS.

2. hsqldb-jdbc2-service.xml --> Am I supouse to get rid of that or
leave it?

> But this file uses the MySQLDS datasource, not DefaultDS, so you need to
> edit it and change MySQLDS by DefaultDS to follow you settings.
>
> There might have other files needing similar changes in other services
> deployed by JBoss.

I changed all the 'MySQLDS' entries in mysql-ds.xml,
standardjbosscmp-jdbc.xml, standardjaws.xml and login-config.xml to the
' DefaultDS'
==============================
I decided to remove file hsqldb-jdbc2-service.xml and after I run the
server I get such a results:

14:58:58,559 INFO [Server] Starting JBoss (MX MicroKernel)...
14:58:58,559 INFO [Server] Release ID: JBoss [Zion] 4.0.4.CR2 (build:
CVSTag=JBoss_4_0_4_CR2 date=200603311500)
14:58:58,569 INFO [Server] Home Dir: C:\j2eeServer
14:58:58,569 INFO [Server] Home URL: file:/C:/j2eeServer/
14:58:58,569 INFO [Server] Patch URL: null
14:58:58,569 INFO [Server] Server Name: default
14:58:58,569 INFO [Server] Server Home Dir:
C:\j2eeServer\server\default
14:58:58,569 INFO [Server] Server Home URL:
file:/C:/j2eeServer/server/default/
14:58:58,579 INFO [Server] Server Log Dir:


C:\j2eeServer\server\default\log

14:58:58,579 INFO [Server] Server Temp Dir:


C:\j2eeServer\server\default\tmp

14:58:58,579 INFO [Server] Root Deployment Filename: jboss-service.xml
14:58:59,180 INFO [ServerInfo] Java version: 1.5.0_06,Sun Microsystems
Inc.
14:58:59,180 INFO [ServerInfo] Java VM: Java HotSpot(TM) Client VM
1.5.0_06-b05,Sun Microsystems Inc.
14:58:59,180 INFO [ServerInfo] OS-System: Windows XP 5.1,x86
14:59:00,642 INFO [Server] Core system initialized
14:59:03,376 INFO [WebService] Using RMI server codebase:
http://moor2:8083/
14:59:03,426 INFO [Log4jService$URLWatchTimerTask] Configuring from
URL: resource:log4j.xml
14:59:03,887 INFO [NamingService] JNDI bootstrap JNP=/0.0.0.0:1099,


RMI=/0.0.0.0:1098, backlog=50, no client SocketFactory, Server
SocketFactory=class org.jboss.net.sockets.DefaultSocketFactory

14:59:08,554 INFO [Embedded] Catalina naming disabled
14:59:08,724 INFO [ClusterRuleSetFactory] Unable to find a cluster


rule set in the classpath. Will load the default rule set.

14:59:08,724 INFO [ClusterRuleSetFactory] Unable to find a cluster


rule set in the classpath. Will load the default rule set.

14:59:09,335 INFO [Http11BaseProtocol] Initializing Coyote HTTP/1.1 on
http-0.0.0.0-8080
14:59:09,335 INFO [Catalina] Initialization processed in 611 ms
14:59:09,335 INFO [StandardService] Starting service jboss.web
14:59:09,345 INFO [StandardEngine] Starting Servlet Engine: Apache
Tomcat/5.5.16
14:59:09,485 INFO [StandardHost] XML validation disabled
14:59:09,545 INFO [Catalina] Server startup in 210 ms
14:59:09,836 INFO [TomcatDeployer] deploy, ctxPath=/invoker,
warUrl=.../deploy/http-invoker.sar/invoker.war/
14:59:10,446 INFO [WebappLoader] Dual registration of jndi stream
handler: factory already defined
14:59:11,178 INFO [TomcatDeployer] deploy, ctxPath=/,
warUrl=.../deploy/jbossweb-tomcat55.sar/ROOT.war/
14:59:12,780 INFO [TomcatDeployer] deploy, ctxPath=/jbossws,
warUrl=.../tmp/deploy/tmp61127jbossws-exp.war/
14:59:13,090 INFO [SubscriptionManager] Bound event dispatcher to
java:comp/env/EventDispatcher
14:59:13,421 INFO [TomcatDeployer] deploy, ctxPath=/jbossmq-httpil,
warUrl=.../deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
14:59:16,485 INFO [TomcatDeployer] deploy, ctxPath=/web-console,
warUrl=.../deploy/management/console-mgr.sar/web-console.war/
14:59:17,757 INFO [MailService] Mail Service bound to java:/Mail
14:59:18,107 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/jboss-ha-local-jdbc.rar
14:59:18,178 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/jboss-ha-xa-jdbc.rar
14:59:18,258 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar
14:59:18,338 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/jboss-xa-jdbc.rar
14:59:18,468 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/jms/jms-ra.rar
14:59:18,548 INFO [RARDeployment] Required license terms exist, view
META-INF/ra.xml in .../deploy/mail-ra.rar
14:59:19,129 INFO [ConnectionFactoryBindingService] Bound
ConnectionManager


'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name
'java:JmsXA'

14:59:19,409 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console,
warUrl=.../deploy/jmx-console.war/
14:59:19,660 ERROR [URLDeploymentScanner] Incomplete Deployment
listing:

--- MBeans waiting for other MBeans ---
ObjectName:

jboss.ejb:service=EJBTimerService,persistencePolicy=database
State: CONFIGURED


I Depend On:
jboss.jca:service=DataSourceBinding,name=DefaultDS

ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
State: CONFIGURED
I Depend On:
jboss.mq:service=Invoker
jboss.web:service=WebServer

ObjectName: jboss:service=KeyGeneratorFactory,type=HiLo
State: CONFIGURED
I Depend On:
jboss:service=TransactionManager
jboss.jca:service=DataSourceBinding,name=DefaultDS

ObjectName: jboss.mq.destination:service=Topic,name=testTopic
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

ObjectName: jboss.mq.destination:service=Queue,name=testQueue
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager
jboss.mq:service=SecurityManager

ObjectName: jboss.mq.destination:service=Queue,name=A
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager

ObjectName: jboss.mq.destination:service=Queue,name=B
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager

ObjectName: jboss.mq.destination:service=Queue,name=C
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager

ObjectName: jboss.mq.destination:service=Queue,name=D
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager

ObjectName: jboss.mq.destination:service=Queue,name=ex
State: CONFIGURED
I Depend On:
jboss.mq:service=DestinationManager

ObjectName: jboss.mq:service=Invoker
State: CONFIGURED
I Depend On:
jboss.mq:service=TracingInterceptor
jboss:service=Naming
Depends On Me:
jboss.mq:service=InvocationLayer,type=HTTP
jboss.mq:service=InvocationLayer,type=JVM
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=Topic,name=testTopic
jboss.mq.destination:service=Topic,name=securedTopic
jboss.mq.destination:service=Topic,name=testDurableTopic
jboss.mq.destination:service=Queue,name=testQueue
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

ObjectName: jboss.mq:service=InvocationLayer,type=JVM
State: CONFIGURED
I Depend On:
jboss.mq:service=Invoker

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=Topic,name=testTopic
jboss.mq.destination:service=Topic,name=securedTopic
jboss.mq.destination:service=Topic,name=testDurableTopic
jboss.mq.destination:service=Queue,name=testQueue
jboss.mq.destination:service=Queue,name=A
jboss.mq.destination:service=Queue,name=B
jboss.mq.destination:service=Queue,name=C
jboss.mq.destination:service=Queue,name=D
jboss.mq.destination:service=Queue,name=ex
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=DefaultDS
Depends On Me:
jboss.mq:service=DestinationManager

ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
State: CONFIGURED
I Depend On:
jboss.mq:service=Invoker

ObjectName: jboss.jca:service=DataSourceBinding,name=DefaultDS
State: CONFIGURED
I Depend On:
jboss.jca:service=LocalTxCM,name=DefaultDS

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---

ObjectName: jboss.jca:service=DataSourceBinding,name=DefaultDS
State: NOTYETINSTALLED
Depends On Me:
jboss.ejb:service=EJBTimerService,persistencePolicy=database
jboss:service=KeyGeneratorFactory,type=HiLo
jboss.mq:service=PersistenceManager

ObjectName: jboss.jca:service=LocalTxCM,name=DefaultDS
State: NOTYETINSTALLED
Depends On Me:
jboss.jca:service=DataSourceBinding,name=DefaultDS


14:59:19,860 INFO [Http11BaseProtocol] Starting Coyote HTTP/1.1 on
http-0.0.0.0-8080
14:59:20,170 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
14:59:20,200 INFO [JkMain] Jk running ID=0 time=0/120 config=null
14:59:20,211 INFO [Server] JBoss (MX MicroKernel) [4.0.4.CR2 (build:
CVSTag=JBoss_4_0_4_CR2 date=200603311500)] Started in 21s:632ms
========================================================
Is that mean there is still something wrong.
Before deleting the mentioned file I received totally different errors
+ some dependencies errors like here.
I don't see anymore the DefaultDS=Hypersonic entry in jmx console
anymore(that is caused by deleting hsqldb-ds.xml from /deploy), but
thought this should be replaced by mysql. Now there's no DefaultDS at
all.
is anything still wrong?
Greetings,
Marek

moo...@wp.pl

unread,
Jun 21, 2006, 9:23:44 AM6/21/06
to

JScoobyCed napisal(a):

JScoobyCed

unread,
Jun 23, 2006, 6:29:51 AM6/23/06
to
moo...@wp.pl wrote:
> hi there!!!
> Thanks for Your quick answer

No problem :)

> I don't see anymore the DefaultDS=Hypersonic entry in jmx console

Yes, from you startup trace, it seems you don't have any jdbc connection
bound. Maybe you need to precise in some file that the jdbc XML should
be parsed before the dependent services. I'll look at my JBoss install
and let you know if I can find this setting.
Cheers,

--
JSC

JScoobyCed

unread,
Jun 23, 2006, 6:32:36 AM6/23/06
to
Ok, I just got an idea... Two ideas:
1. Did you try another JBoss or Java WebApps oriented newsgroup :) ?
2. Did you delete the content of <path-to-jboss>/server/default/tmp/deploy ?

Cheers

--
JSC

0 new messages