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 :
mysql-persistence-service.xml (I created and use this file instead of hsqldb-persistence-service.xml)