 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / Databases / June 2006mysql as DefaultDS in jboss
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 > hi! > I have huge problem configuring jboss to use mysql as a default [quoted text clipped - 4 lines] > 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.  SignatureJSC 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 [quoted text clipped - 3 lines] > 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 > 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, SignatureJSC >> hi there!!! >> Thanks for Your quick answer [quoted text clipped - 8 lines] > and let you know if I can find this setting. > Cheers, 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 SignatureJSC JScoobyCed napisal(a): > > hi! > > I have huge problem configuring jboss to use mysql as a default [quoted text clipped - 37 lines] > deployed by JBoss. > Good luck. Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.