JB3.0beta+mysql Config Question
dew_ Mar 12, 2002 8:35 PMI 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