Jar executable with sqlite driver

Question

I made a code that connects to my sqlite driver which is in the CLASSPATH and reads some database file. I want to create an executable which can be used on computers that don't have the sqlite driver.

If I do:

jar cvfe exec.jar main_class

I will get "class not found: org.sqlite.JDBC" when running with

java -jar exec.jar

What should I do to make the executable work?

Edit: I don't know if it makes any difference, but this is the JDBC driver I use:

https://bitbucket.org/xerial/sqlite-jdbc

Can't I do this from command line? It should be easy, but I can't find it anywhere — user3653831
– user3653831, Commented Sep 15, 2014 at 16:16
You should include the driver inside the JAR. Are you doing that? — Zenadix
– Zenadix, Commented Sep 15, 2014 at 16:27

Zenadix · Accepted Answer · 2014-09-15 18:30:08Z

2

You need to include the library inside the JAR. Maybe you don't know this, but JAR files are just ZIP files, so you can change their contents easily. Here are some quick instructions on how to do it. Assuming your JAR file is named exec.jar, and the JAR of the library you want to include (the JAR you downloaded) is driver.jar

Change your file name from exec.jar to exec.zip.
Extract all the contents of exec.zip into folder exec/
Change your library file name from driver.jar to driver.zip
Extract all the contents of driver.zip into folder driver/
Copy the contents of driver/ into exec/, but do not copy the META-INF folder. If a pop-up asks if it's ok to merge the folders, click yes.
Compress all files in exec/ into exec.zip
Rename exec.zip to exec.jar (replace the original).

You can include any java library inside a JAR using this method.

edited Sep 15, 2014 at 18:30

answered Sep 15, 2014 at 17:03

Zenadix

16.4k5 gold badges29 silver badges41 bronze badges

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

5 Comments

user3653831 Over a year ago

Just a few questions. The driver has only one jar file. Is that what should be in the org/sqlite folder? Or do I have to extract the driver.jar? I've done both, but when I try to use the final exec.jar file it says it's corrupted.

Zenadix Over a year ago

Extract the driver.jar. Inside, you will find a folder named org. Inside org you will find a folder named sqlite. Copy all the contents of sqlite into your exec.jar/org/sqlite.

Zenadix Over a year ago

I updated the answer, hopefully making it more clear. Actually all you need to do is merge the library jar with your jar.

user3653831 Over a year ago

It does work now. The corruption was not an serious issue. Thanks.

user3653831 Over a year ago

Also works if I add org/sqlite to my java directory after compilation and type jar cvfe exec.jar main_class *.class org

djangofan · Accepted Answer · 2014-09-15 14:43:03Z

0

Here is the doc:

C:\Windows\System32>jar /?
Illegal option: /
Usage: jar {ctxui}[vfmn0Me] [jar-file] [manifest-file] [entry-point] [-C dir] files ...

And so I think the command you need is:

jar cvfe exec.jar main_class main_class

answered Sep 15, 2014 at 14:43

djangofan

29.9k62 gold badges211 silver badges308 bronze badges

2 Comments

user3653831 Over a year ago

But how do I get the SQLite to work with the executable?

djangofan Over a year ago

I suppose you just pass a -classpath arg to the above command that includes the location of the SQLite.jar file. of course, this is a problem because you aren't extracting the executable .jar and so you wont be able to load the resource. There is a way to handle it, just don't know the exact way. There is a Maven plugin that will do it.

Collectives™ on Stack Overflow

Jar executable with sqlite driver

2 Answers 2

5 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related