ClassNotFoundException: org.sqlite.JDBC

Question

I'm trying to set up a simple database for an Android app using sqlite but got the following error:

java.lang.ClassNotFoundException: org.sqlite.JDBC
    at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:171)
    at testDB.main(testDB.java:16)

Here is my code:

public class testDB {
    public static void main(String args[]) {
        Connection c = null;
        try {
            Class.forName("org.sqlite.JDBC");
            c = DriverManager.getConnection("jdbc:sqlite:/Users/Dropbox/csProject/test.db", "", "");
        } 
    }

I have added sqlite-jdbc4-3.8.2-SNAPSHOT.jar in the library and I also tried to create a path in my home directory but am still getting the same error..

sqlite-jdbc4-3.8.2-SNAPSHOT.jar is not in your classpath – lreeder Feb 08 '14 at 03:39 — lreeder, Feb 08 '14 at 03:39
http://stackoverflow.com/a/43234518/6756523 – Paul Apr 05 '17 at 14:46 — Paul, Apr 05 '17 at 14:46

score 1 · Answer 1 · edited Mar 17 '15 at 16:44

1

You have to add the .jar to your project. You can simply do that by opening Eclipse, right click the .jar files, then add to project.

edited Mar 17 '15 at 16:44

Erik Ghonyan

427
4
12

answered Feb 08 '14 at 05:02

safaiyeh

1,655
3
16
35

score 1 · Answer 2 · answered Mar 12 '21 at 10:23

1

You can directly add sqlite-jdbcXXX.jar to your tomcat/lib.

answered Mar 12 '21 at 10:23

Javu Man

11
1

score 0 · Answer 3 · answered Apr 28 '23 at 15:25

0

in my case I was using gradle and needed to add

dependencies {
    implementation 'org.sqlite:sqlite-jdbc:3.25.2'
}

answered Apr 28 '23 at 15:25

Calvin Taylor

664
4
15

ClassNotFoundException: org.sqlite.JDBC

3 Answers3