[jboss-user] [JBoss Portal] - Re: WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: 01
rkusetty
do-not-reply at jboss.com
Wed Sep 26 10:09:36 EDT 2007
Hi Peter,
I tried with the another user 'sqlusr at localhost'. I gave all the privileges as below:
mysql> GRANT ALL ON *.* TO 'sqlusr at localhost' IDENTIFIED BY 'pwd';
Query OK, 0 rows affected (0.06 sec)
But after this also, I am getting the below error at the jboss AS console:
19:32:37,250 INFO [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca:service=DataSourceB
inding,name=PortalDS' to JNDI name 'java:PortalDS'
19:32:37,609 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection:
null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sq
l.SQLException: Access denied for user 'sqlusr'@'localhost' (using password: YES))
Please let me know if you have any solution for this.
Thanks,
Ramana
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4088864#4088864
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4088864
More information about the jboss-user
mailing list