1 Reply Latest reply on Mar 16, 2002 1:21 AM by Hao Wu

    JB3.0beta+mysql Config Question

    Doug Newbie

      I have JBoss3.0beta and mysql. I have the appropriate driver jar and the following mysql-server.xml:
      ------------------------------------------------------------------------------
      <?xml version="1.0" encoding="UTF-8"?>
      <!-- $Id: mysql-service.xml,v 1.3 2002/03/01 00:02:00 d_jencks Exp $ -->


      <!-- ===================================================================== -->
      <!-- -->
      <!-- Example configuration for the mysql database. -->
      <!-- Put the driver jar mm.mysql-2.0.4-bin.jar in lib/ext -->
      <!-- Contributed by Ignacio Coloma icoloma@iverdino.com -->
      <!-- ===================================================================== -->




      ConnectionURL=jdbc:mysql://localhost/titan
      DriverClass=org.gjt.mm.mysql.Driver
      UserName=user@localhost
      Password=PASSWORD-REMOVED
      DefaultDS
      java:/TransactionManager
      <depends optional-attribute-name="ResourceAdapterName">jboss.jca:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter
      <depends optional-attribute-name="ConnectionManagerFactoryLoaderName">jboss.jca:service=ConnectionManagerFactoryLoader,name=MinervaSharedLocalCMFactory
      #
      #Wed Aug 15 16:17:29 EDT 2001
      BlockingTimeoutMillis=500000
      IdleTimeoutMinutes=30
      MaxSize=10
      CleanupIntervalMinutes=10
      MinSize=0
      MaxIdleTimeoutPercent=1.0


      org.jboss.resource.security.ManyToOnePrincipalMapping

      UserName=



      ------------------------------------------------------------------------------
      All goes well until I attempt to deploy a bean wishing to use the DefaultDS. I receive the following exception:
      ------------------------------------------------------------------------------
      18:24:47,325 ERROR [DefaultDS] Unable to create ManagedConnection:
      javax.resource.ResourceException: Unable to create DB connection for url: jdbc:mysql://localhost/titan, user: , exception: java.sql.SQLException: General error: Access denied for user: '@localhost.localdomain' to database 'titan'
      at org.jboss.resource.adapter.jdbc.local.JDBCManagedConnectionFactory.createManagedConnection(JDBCManagedConnectionFactory.java:392)
      at org.jboss.resource.connectionmanager.ManagedConnectionPoolFactory.createObject(ManagedConnectionPoolFactory.java:97)
      at org.jboss.pool.ObjectPool.createNewObject(ObjectPool.java:1013)
      at org.jboss.pool.ObjectPool.getObject(ObjectPool.java:672)
      at org.jboss.resource.connectionmanager.SharedLocalConnectionManager.allocateConnection(SharedLocalConnectionManager.java:124)
      ...------------------------------------------------------------------------------

      As shown above, I have specified a UserName and Password (removed for this post) in the service file, however, they are not being used to connect to the DB.

      Any suggestions?

      TIA

        • 1. Re: JB3.0beta+mysql Config Question
          Hao Wu Newbie

          Instead of
          ConnectionURL=jdbc:mysql://localhost/titan
          DriverClass=org.gjt.mm.mysql.Driver
          UserName=user@localhost
          Password=PASSWORD-REMOVED

          ...
          UserName=
          ...


          Try this:
          ConnectionURL=jdbc:mysql://localhost/titan
          DriverClass=org.gjt.mm.mysql.Driver
          UserName=user@localhost
          ...
          UserName=user@localhost
          Password=PASSWORD-REMOVED

          ...


          --Hao