problem with datasource + mysql + jboss

[rhinosystemsinc]

Hi,

I've configured two datasources in /server/default/deploy, as shown below, and one goes to oracle, and the other goes to mysql.

Problem is this... I can connect to mysql via a java test program, but it won't connect from jboss. Funny thing is that it is using a username that I've taken out of the datasource definitions all together... (It is one of my usernames, but just not in the ds config files).. Please help... Thanks!

Env:
MySQL: Server version: 5.0.32-Debian_7etch8-log
Connector: mysql-connector-java-5.1.7-bin.jar
jboss-4.2.2.GA
Debian/Unix

Error:

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
 at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:171)
 ... 158 more
Caused by: java.sql.SQLException: Access denied for user 'gs'@'localhost' (using password: YES)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:911)
 at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3953)
 at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1276)
 at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2198)
 ... 162 more

::::::::::::::
GSModel-ds.xml
::::::::::::::

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
 <local-tx-datasource>
 <jndi-name>GSModelDS</jndi-name>
 <connection-url>jdbc:oracle:thin:@localhost:1521:xe</connection-url>
 <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
 <user-name>gsora</user-name>
 <password>xxxxx</password>
 </local-tx-datasource>
</datasources>

::::::::::::::
GSMySQL-ds.xml
::::::::::::::

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
 <local-tx-datasource>
 <jndi-name>GSMySQLModelDS</jndi-name>
 <!--<connection-url>jdbc:mysql://localhost:3306/gsTemp</connection-url> -->
 <connection-url>jdbc:mysql://localhost/gstemp1</connection-url>
 <driver-class>com.mysql.jdbc.Driver</driver-class>
 <user-name>gs2</user-name>
 <password>xxxxx</password>
 <connection-property name="autoReconnect">true</connection-property>
 <!-- Typemapping for JBoss 4.0 -->
 <metadata>
 <type-mapping>mySQL</type-mapping>
 </metadata>
 </local-tx-datasource>

</datasources>

[peterj]

Are you sure you do not have another *-ds.xml file anywhere? And that the configuration you are running is the one in whose deploy folder you placed the above *-ds.xml files?

Another possibility: are you using hibernate or JPA? How are they configured? Are they using the datasource or going directly to the database?

[rhinosystemsinc]

so you got me thinking on the right track... it was due to a persistence.xml config that had hibernate login info overriding the datasource config. I removed the username/passwd from the persistence.xml and all it good now. Thanks!