2 Replies Latest reply on Jan 28, 2009 5:27 PM by Joel Thompson

    problem with datasource + mysql + jboss

    Joel Thompson Newbie

      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>