First impressions count as they say. My application - however fool proof I make the install still requires the user to install and configure a database environment. Currently I support mySQL, MS SQL and Oracle. In theory mySQL is the easiest to setup - but the current versions of the SQL Workbench are buggy and problematic.
What I would like to do is to be able to bundle some kind of sql database in the form of jar files which would allow my application to create a database itself for local use - but also support remote connections for network usage if required. I was wondering if Java DB / Derby might fulfil this requirement.
The sort of thing I would like to offer during setup would be :-
Create a Java DB database.
Connect to a remote Java DB database
Connect to a remote my SQl database.
Connect to a remote..... etc
If anyone who has experience with Java DB (or similar alternatives) could comment I would be grateful.
I would need to know if I could accomplish this setup without any user interaction or technical knowledge. Does it require a special JVM version.
My application runs with Windows, Linux and OSX so any DB solution would ideally work on all 3.
I don't envisage the DB solution to be a "heavyweight" solution - but mainly a simple way of letting the user try the application out with minimal effort. They can always migrate to one of the more established db vendors once they are happy the application does what they want.