Java – the ideal data source for stand-alone applications?
Suppose I create a standalone application in Java and distribute it through my website
What I need to know is what ideal database solution I can use so that all users can use the application without installing anything else
For example, if I use SQL server or MySQL database, the downloader will need to install those so that I can dump the database onto it Another solution I see is to use database files, such as Microsoft Access Mdb file However, this also requires Microsoft office.com to be installed on the client XML files are platform independent, but anyone can open and change them
What is the solution used by most applications?
Solution
H2 is a very strong candidate you need We use it as the default RDBMS in all demo applications and also for database - driven unit testing