I am currently working thorugh this book - what a breath of fresh air it is. On Chp 4 some time later today - will let you know how I get on.
I managed to get the database to switch from Hypersonic to MySql - it all worked fine. I can check through the JMX Managment Console that the new datasource is in use and connecting - and the web application works OK.
The only thing I did differently to the instructions in the book was to change the optional.dd property directly in the build.xml file as oppossed to the command line -D parameter (as I'm using ant from within eclipse). That ensured the correct jboxxcmp-jdbc.xml file was inlcuded in the generated jar file (from the etc/mysql folder). This file isn't needed in the jar for Hypersonic.
You may just want to check to ensure the correct settings are in this file in the genertaed jar file after you've run the build.
I'm in eclipse too. Could you tell me what you did in the build.xml file?
I don't understand what you are doing. Redeploying the application would not cause the JMS persistence manager to be redeployed or to fail. There has to be something else going on.
Could you please step back and repeat the process slowly and see if you get different results? I ran the example just now and had no problems.
My bad...I had been using mySQL with other tools and IDEs so I knew it was working. But JBoss didn't have a copy of the jdbc driver in its /lib folder.
DOH! But it is really odd that it would say it had a db table creation error when it could even communicate with the db!
Looks like something wasn't coming to the surface. Argh.
All fine now.
Ok, that's a relief. Since you are in Austin, if you have any questions/comments about the book, you can catch me at the Austin Java User's Group. (http://www.austinjug.org/) I'm there every month I'm in town, and I'm always eager to hear about what readers liked/disliked about the book.