1 Reply Latest reply on Jul 23, 2004 5:58 PM by Nick Gallardo

    Stumped trying to create MySQL datasource on 3.2.4

    Nick Gallardo Newbie

      I've configured the mysql-ds.xml and placed it in my deploy directory with the database information.


      <local-tx-datasource>
      <jndi-name>NGDataSource</jndi-name>
      <connection-url>jdbc:mysql://localhost:3306/ng</connection-url>
      <driver-class>org.gjt.mm.mysql.Driver</driver-class>
      <user-name>dbuser</user-name>
      abc123
      </local-tx-datasource>


      The DS is bound in the namespace and I can look it up successfully from my bean. Whenever I try to use the connection to do something like connection.prepareStatement(string) or anything like that, I get the following error:

      16:31:24,639 ERROR [STDERR] Caused by: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Server configuration denies access to data source)

      The only things that I've found on this forum and on the web point to the MySQL grant tables. I've updated and flushed both the db and global privileges. Also, I can log in from the command line successfully with the same username and password.

      Am I missing anything here? Any ideas as to where else I might be able to look?