Have been happily running an application with Pointbase DB for several months but need to switch to MySQL for compatibility. Have downloaded MySQL, have mysqld.exe running and put the jdbc jar in the lib directory of the JBoss server. Also set up the mysql-service.xml with the principal and user-name set to afcw@localhost and the password set appropriately.
When I run it, it appears to acquire the MySQL DataSource (or at least doesn't throw an exception) but when I go to get a connection it throws a "java.net.UnknownHostException: dell" wrapped in java.sql.Exception etc.
Have I forgotten to do something during the installation and set-up? BTW don't have a host called dell on the network.
Oops found that one - hadn't changed mysql-service.xml sufficiently. Now getting a "Wrong credentials passed to getConnection" but will investigate further before bothering folk.