Java Desktop Application using SQLite installed by a single installer
installation, java, portability, sqlite
Solution
I think the easyest for you is to use the database in `embedded` mode. Different databases could be use in this way :
- Derby
- SQLLite and for more details you could at this answer
- HSQLDB
The database is packaged with your application jar, so you don't need to install it.
Problem
I am a beginner in programming Java Desktop Application interacting with databases. My goal is to make a simple java application which uses a database to store it's data locally. After some googling I found that SQLite/Derby would cover my needs. I've googled SQLite and Derby and I found that in order to use them I need to install them on the computer through commands in terminal. My question is how the application could be done so that at the end the client will be given a simple installer file which installs both Java Application and the SQLite/Derby Database avoiding doing any installations before. Is that possible?