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> View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4205388#4205388 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4205388 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user