File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JBoss/WildFly and the fly likes Cannot conect to mySql DB after changing DB from HSQL to mySql in JBOSS 5 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "Cannot conect to mySql DB after changing DB from HSQL to mySql in JBOSS 5" Watch "Cannot conect to mySql DB after changing DB from HSQL to mySql in JBOSS 5" New topic
Author

Cannot conect to mySql DB after changing DB from HSQL to mySql in JBOSS 5

arturo nunez
Greenhorn

Joined: Jan 16, 2012
Posts: 7

I am trying to run the EJB in Action Chapter 2 application.

I want to use mySql database instead of the default hsqldb. I have changed the JBOSS 5 configuration to use mySql. I have not succeed in getting the ear file deployed. I can't connect to the database.
The first error I see in the server log is :

12:40:59,456 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Access is denied)


Although there are many other eros in the log, since this is the first error in the log, I am assuming that subsequent error messages releated to this first error.

The database is : localDB, the userid id : SA the password is : password
I have reviewed the login and password I submit and it looks fine. I have tweaked the files I thought I needed to changed but I can't progress.
I build the ear file with apache ant.

Any advice would be welcome as I've spent about 9 hours trying tp get this to work.

I have pasted at the bottom of this post the server log. I have pasted immediatedly below this sentence the files :
msSQL-ds.xml
login_config.xml
Messaging-jboss-beans.xml
mysql-persistence-service.xml (I created and use this file instead of hsqldb-persistence-service.xml)
persistence.xml




persistence.xml





msSQL-ds.xml




login_config.xml


mysql-persistence-service.xml (replaced hsql-persistence-service.xml


messaging-jboss-beans.xml



THE JBOSS LOG (part of log not posted)


Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18570
    
    8

But that message doesn't come from MySQL. It comes from HSQL, as you can tell by the next line in the log:

Caused by: java.sql.SQLException: Access is denied
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

Sachin Pachari
Ranch Hand

Joined: Jan 16, 2012
Posts: 56

there are two possiblities,

1.You must have forgot to remove the hsql instance from your code, its running somewhere.
2.Check your user name ans password, or try it with a new user name and password.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Cannot conect to mySql DB after changing DB from HSQL to mySql in JBOSS 5