java sqlite exception

Question

I made a Java application using netbeans and used sqlite as database Everything works in netbeans but when i export the program to jar file and run it on another machine, an exception appeared when i try to connect sqlite database

The exception is about this line: Class.forName("org.sqlite.JDBC"); and the exception is: java.lang.ClassNotFoundException: org.sqlite.JDBC

I looked at all related threads in stackoverflow and no pure answer about this.

Thanks in advanced,

You need to set the classpath and include all the Jar files you depend on. — NilsH, Apr 13 '13 at 16:06

score 0 · Answer 1 · answered Apr 13 '13 at 16:06

0

Just add the sqlite driver jar to your class path. You application can't find the class org.sqlite.JDBC so it means a jar is missing in your class path.

answered Apr 13 '13 at 16:06

TheEwook

11,037
6
36
55

how to add it? and when? before export to jar or after? – Zaid Altamimi Apr 13 '13 at 16:10

score 0 · Answer 2 · answered Apr 13 '13 at 16:07

0

Either include the sqlite jdbc driver in the jar file or make sure that you have it in your classpath. Add it as -classpath sqlite driver

answered Apr 13 '13 at 16:07

Seid.M

185
7

`java -cp "sqlite driver JAr" -jar YOURJARHERE` – Seid.M Apr 13 '13 at 16:13
make sure the sqlite driver jar is in the same directory as your jar file or give the full path – Seid.M Apr 13 '13 at 16:14
when i execute that command it run the application and display the same exception ! – Zaid Altamimi Apr 13 '13 at 16:18
Another option is to include in the jar itself. Look [here](http://stackoverflow.com/questions/9681876/how-to-create-a-jar-file-in-netbeans) how to do it in netbeans – Seid.M Apr 13 '13 at 16:21

score 0 · Answer 3 · answered Apr 14 '13 at 11:50

Problem Solved

I had import the sqlite jar file for both compile time and run time. From netbeans -> project properties -> Libraries.

and Then i moved the exported jar file from dist folder in addition to lib folder to another machine .. and worked smoothly .. Thanks Guys up

java sqlite exception

3 Answers3