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
– Vineet Reynolds, Commented Jul 29, 2011 at 11:20

Nico Huysamen · Accepted Answer · 2011-07-29 11:13:16Z

3

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.

answered Jul 29, 2011 at 11:13

Nico Huysamen

10.4k9 gold badges66 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:00:00Z

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, 2017 at 12:00

CommunityBot

11 silver badge

answered Jul 29, 2011 at 11:09

Jacob

43.6k6 gold badges81 silver badges81 bronze badges

1 Comment

user166390 Over a year ago

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.

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related