Problems using a mysql database - please help with configura
destiny84 Mar 14, 2006 12:50 PMHello,
I want to use a mysql database with jboss (4.0.4 RC1), but somehow I can't get it configured.
I put the mysql-connector-java-3.1.12-bin.jar in the server/default/lib directory, and I have the mysql-ds.xml in the server/default/deploy directory.
It looks as follows:
<datasources> <local-tx-datasource> <jndi-name>DefaultDS</jndi-name> <connection-url>jdbc:mysql://localhost:3306/isep</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>root</user-name> <password>mypassword</password> <connection-property name="autoReconnect">true</connection-property> <!-- Typemapping for JBoss 4.0 --> <metadata> <type-mapping>mySQL</type-mapping> </metadata> </local-tx-datasource> </datasources>
isep is the database I want to use, so I think the connection url should be okay. Also I deleted the hsqldb-ds.xml from the deploy directory because mysql is the default database.
Now when I am starting my server, I get:
=============================================================================== . JBoss Bootstrap Environment . JBOSS_HOME: C:\isep\jboss\bin\\.. . JAVA: C:\Programme\Java\jdk1.5.0_06\bin\java . JAVA_OPTS: -Dprogram.name=run.bat -Xms128m -Xmx512m . CLASSPATH: C:\Programme\Java\jdk1.5.0_06\lib\tools.jar;C:\isep\jboss\bin\\run. jar . =============================================================================== . 18:47:13,202 INFO [Server] Starting JBoss (MX MicroKernel)... 18:47:13,202 INFO [Server] Release ID: JBoss [Zion] 4.0.4RC1 (build: CVSTag=JBo ss_4_0_4_RC1 date=200602071519) 18:47:13,212 INFO [Server] Home Dir: C:\isep\jboss 18:47:13,212 INFO [Server] Home URL: file:/C:/isep/jboss/ 18:47:13,212 INFO [Server] Patch URL: null 18:47:13,212 INFO [Server] Server Name: default 18:47:13,212 INFO [Server] Server Home Dir: C:\isep\jboss\server\default 18:47:13,212 INFO [Server] Server Home URL: file:/C:/isep/jboss/server/default/ 18:47:13,212 INFO [Server] Server Temp Dir: C:\isep\jboss\server\default\tmp 18:47:13,212 INFO [Server] Root Deployment Filename: jboss-service.xml 18:47:13,582 INFO [ServerInfo] Java version: 1.5.0_06,Sun Microsystems Inc. 18:47:13,582 INFO [ServerInfo] Java VM: Java HotSpot(TM) Client VM 1.5.0_06-b05 ,Sun Microsystems Inc. 18:47:13,582 INFO [ServerInfo] OS-System: Windows XP 5.1,x86 18:47:14,023 INFO [Server] Core system initialized 18:47:15,165 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resour ce:log4j.xml 18:47:16,907 INFO [SocketServerInvoker] Invoker started for locator: InvokerLoc ator [socket://192.168.1.102:3873/] 18:47:17,278 INFO [AspectDeployer] Deployed AOP: file:/C:/isep/jboss/server/def ault/deploy/ejb3-interceptors-aop.xml 18:47:18,199 INFO [WebService] Using RMI server codebase: http://destiny:8083/ 18:47:18,319 WARN [EJBTimerServiceImpl] Cannot obtain TransactionManager from J NDI, using TxManager.getInstance(): javax.naming.NameNotFoundException: Transact ionManager not bound 18:47:20,102 INFO [NamingService] Started jndi bootstrap jnpPort=1099, rmiPort= 1098, backlog=50, bindAddress=/0.0.0.0, Client SocketFactory=null, Server Socket Factory=org.jboss.net.sockets.DefaultSocketFactory@ad093076 18:47:20,182 INFO [EJB3Deployer] Default persistence.properties: {hibernate.tra nsaction.flush_before_completion=true, hibernate.cglib.use_reflection_optimizer= false, hibernate.transaction.auto_close_session=false, hibernate.jndi.java.namin g.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces, hibernate.cache.provider _class=org.hibernate.cache.HashtableCacheProvider, hibernate.transaction.manager _lookup_class=org.hibernate.transaction.JBossTransactionManagerLookup, hibernate .jndi.java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, hiber nate.query.factory_class=org.hibernate.hql.ast.ASTQueryTranslatorFactory, hibern ate.connection.release_mode=after_statement} 18:47:20,923 INFO [Embedded] Catalina naming disabled 18:47:21,334 INFO [Http11BaseProtocol] Initializing Coyote HTTP/1.1 on http-0.0 .0.0-8080 18:47:21,334 INFO [Catalina] Initialization processed in 351 ms 18:47:21,334 INFO [StandardService] Starting service jboss.web 18:47:21,344 INFO [StandardEngine] Starting Servlet Engine: Apache Tomcat/5.5.1 2 18:47:21,384 INFO [StandardHost] XML validation disabled 18:47:21,404 INFO [Catalina] Server startup in 70 ms 18:47:21,554 INFO [TomcatDeployer] deploy, ctxPath=/, warUrl=.../deploy/jbosswe b-tomcat55.sar/ROOT.war/ 18:47:21,894 INFO [WebappLoader] Dual registration of jndi stream handler: fact ory already defined 18:47:22,475 INFO [RARDeployment] Required license terms exist, view META-INF/r a.xml in .../deploy/jboss-local-jdbc.rar 18:47:22,595 INFO [RARDeployment] Required license terms exist, view META-INF/r a.xml in .../deploy/jms/jms-ra.rar 18:47:22,896 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jb oss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA' 18:47:23,036 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jb oss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS' 18:47:23,797 WARN [ServiceController] Problem starting service jboss.mq:service =PersistenceManager org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Messag e recovery may not be accurate; - nested throwable: (java.sql.SQLException: Ever y derived table must have its own alias) at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(Pers istenceManager.java:442) at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceMana ger.java:1571) at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanS upport.java:289) at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMB eanSupport.java:245) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch er.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(ServiceControl ler.java:974) 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.GeneratedMethodAccessor6.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch er.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(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch er.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept or.java:133) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM BeanOperationInterceptor.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.ja va:287) at $Proxy18.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.GeneratedMethodAccessor14.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch er.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept or.java:133) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM BeanOperationInterceptor.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 $Proxy6.deploy(Unknown Source) at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymen tScanner.java:334) at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentS canner.java:522) at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread. doScan(AbstractDeploymentScanner.java:207) at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(A bstractDeploymentScanner.java:280) at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanS upport.java:289) at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMB eanSupport.java:245) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch er.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(ServiceControl ler.java:974) at $Proxy0.start(Unknown Source) at org.jboss.system.ServiceController.start(ServiceController.java:417) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch er.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(DelegatingMethodAcces sorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch er.java:155) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94) at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept or.java:133) at org.jboss.mx.server.Invocation.invoke(Invocation.java:88) at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM BeanOperationInterceptor.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:477) at org.jboss.system.server.ServerImpl.start(ServerImpl.java:357) 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:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja va:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java: 1030) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery (WrappedPreparedStatement.java:236) at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(Pers istenceManager.java:403) ... 113 more 18:47:23,827 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../dep loy/jmx-console.war/ 18:47:23,957 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 transaction s. Message recovery may not be accurate; - nested throwable: (java.sql.SQLExcep tion: 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 transaction s. Message recovery may not be accurate; - nested throwable: (java.sql.SQLExcep tion: Every derived table must have its own alias) I Depend On: jboss.jca:service=DataSourceBinding,name=DefaultDS Depends On Me: jboss.mq:service=DestinationManager 18:47:23,987 INFO [Http11BaseProtocol] Starting Coyote HTTP/1.1 on http-0.0.0.0 -8080 18:47:24,158 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009 18:47:24,168 INFO [JkMain] Jk running ID=0 time=0/40 config=null 18:47:24,178 INFO [Server] JBoss (MX MicroKernel) [4.0.4RC1 (build: CVSTag=JBos s_4_0_4_RC1 date=200602071519)] Started in 10s:966ms
I do not even have any projects trying to use mysql, it's a clean jboss install with only the mentioned changes.
Any ideas?
If there is anything else I need to configure, please let me know.