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?
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3843129#3843129
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3843129
-------------------------------------------------------
This SF.Net email is sponsored by BEA Weblogic Workshop
FREE Java Enterprise J2EE developer tools!
Get your free copy of BEA WebLogic Workshop 8.1 today.
http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
