How to Bind MySql Database inside a JAR file of any application?

Question

I have prepared an application that is a small demo of Student information manipulation. I have stored information related to students in a MySQL DB. Now my application is working 100% on my computer. But I want that work everywhere without depending on Database! I mean I just want "WHEREVER MY .JAR FILE GOES, DATABASE SHOULD ALSO GO ALONG WITH THAT INSIDE .JAR FILE "

So anyone who is using my application or trying it, they can realize exact result of this application.

How can I make this possible? Please someone help me.

Note - people here can read questions just fine. Please do away with the bold caps. — Vineet Reynolds, Jul 29 '11 at 11:20

score 3 · Accepted Answer · answered Jul 29 '11 at 11:13

You will probably need to look at something like HyperSQL, which is a in-memory database (which you will need to populate at application start-up). Or have a look at SQLite, which is an embedded databsase, which you can distribute as a resource in your jar.

score 2 · Answer 2 · edited May 23 '17 at 12:00

2

This doesn't work. MySQL is a full-blown RDBMS. You would have to install it on every computer if you want application to use it locally. An alternative would be using SQLite.

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

SQLite and Java

SQLite seems to be a good fit for your requirements.

edited May 23 '17 at 12:00

Community

1
1

answered Jul 29 '11 at 11:09

Jacob

41,721
6
79
81

It's actually a bit finicky to use a SQLite database with(in) a JAR ... this is because SQLite requires direct-file access. The actual distribution of the SQLite library is easy. – Dec 11 '11 at 06:23

How to Bind MySql Database inside a JAR file of any application?

2 Answers2

Linked