JBoss comes with an embedded database Hypersonic, what are the advantages and disadvantages of using that ? How does the embedded database compare with MySQL. Can Hypersonic be used for a production database ?
Is there any article or book that explains the pros and cons of the embedded DB ? Also are there any known limitations of mySQL ? Does hybernate work with Hypersonnic ?
MySQL just came out with a new release - it looks like they now have stored procedures and decent transaction support. I'm sure MySQL has limitations, but I don't know where you'd find an article that covers this. Maybe you could google for "Open Source Database" and find something that way.