6 Replies Latest reply on Mar 16, 2006 3:32 AM by cocofrance

    Problems using a mysql database - please help with configura

    destiny84

      Hello,
      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.