mySQL conflicts with org.hsqldb.* in JBoss 3
twhphan Dec 26, 2001 3:55 PMI'm using JBoss 3.0 (got the src from the CVS), My mysql-service.xml in the deploy directory:
ConnectionURL=jdbc:mysql://localhost/db
DriverClass=org.gjt.mm.mysql.Driver
UserName=root
mySQLDS
java:/TransactionManager
<depends optional-attribute-name="ResourceAdapterName">JCA:service=RARDeployment,name=Minerva JDBC LocalTransaction ResourceAdapter
<depends optional-attribute-name="ConnectionManagerFactoryLoaderName">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=root
I leave hsqldb-default-service.xml in the deploy directory, since the JMS is using it, but I get:
java.sql.SQLException: Table not found: MYTABLE in statement [select * from MyTable]
at org.hsqldb.Trace.getError(Trace.java:180)
at org.hsqldb.Result.(Result.java:175)
at org.hsqldb.jdbcConnection.executeHSQL(jdbcConnection.java:907)
at org.hsqldb.jdbcConnection.execute(jdbcConnection.java:718)
at org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:686)
at org.hsqldb.jdbcStatement.executeQuery(jdbcStatement.java:68)
at org.jboss.resource.adapter.jdbc.local.StatementInPool.executeQuery(StatementInPool.java:710)
at esb.ejb.GenericDAOBean.getRowSet(Unknown Source)
at java.lang.reflect.Method.invoke(Native Method)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:615)
Note that the container calls the wrong JDBC class. How may I correct this? I've an impression that the container ignore things within the tag
If I add the Password property in the tags , and , and restart JBoss, I get:
04:35:55,118 ERROR [mySQLDS] Unable to create ManagedConnection:
javax.resource.ResourceException: Unable to create DB connection for url: jdbc:mysql://localhost/db, user: myUser, exception: java.sql.SQLException: Invalid authorization specification: Access denied for user: 'myUser@localhost' (Using password: NO)
at org.jboss.resource.adapter.jdbc.local.JDBCManagedConnectionFactory.createManagedConnection(JDBCManagedConnectionFactory.java:392)
What's wrong? how may I change the above to "(Using password: YES)"? Is this due to a JDBC setting?
Thanks