Let's tackle one problem at a time. The DefaultDS data source is used by various JBoss AS services and by default uses the HSQL database. Do you really want to replace HSQLDB with MySQL so that the JBoss AS services are using MySQL? Or are you more concerned with setting up a database for your application? Pick one, and only on,e and we will work on that first.
You have right. I do not want to replace entirely HSQLDB (my intent was just in
testing purpose), so I would like to set my application to use mysql, or whatever other db server.
I try it just as I described in previous post, placing mysql-ds.xml file at the top level of .ear, and referencing it from jboss-web.ml file, inside META-INF.
One more thing - the table "system_sequences" does not belong to any of the JBoss AS services. I suspect that you have deployed an app and that app is not properly configured, hence this problem. If you are really trying to replace DefaultDS, remove this app and see if startup works ok.
Nothing is wrong with application. It is simple testing apps. used just to store simple entity in mysql (no messaging, no timers). When I remove it, the server start-up fine. When I exclude mysql-ds.xml file, and use Hypersonic database, the application also works fine.
Since you have the book, do you also have the book's source code? If so, can you run target 03 in jbia-src/ch15, and does that work for you?
Yes, I have source code, but have a problem deploying your example.I got this error :
I tried to modify build.properties file, to reference to my jboss-5.0.0.GA.zip, but I get the same error, just like it never read again.
However, can you figure out what goes wrong when I try to use mysql just for storing simple entity?
And, can you advice me about best practice when should I use different database but Hypersonic (should I leave Hypersonic for messaging, timer, etc.)?