ClassNotFoundException: org.sqlite.JDBC [duplicate]

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
– lreeder

2014-02-08 03:39:29 +00:00
Commented Feb 8, 2014 at 3:39 — lreeder
– lreeder, Commented Feb 8, 2014 at 3:39
stackoverflow.com/a/43234518/6756523

Paul
– Paul

2017-04-05 14:46:34 +00:00
Commented Apr 5, 2017 at 14:46 — Paul
– Paul, Commented Apr 5, 2017 at 14:46

Erik Ghonyan · Accepted Answer · 2015-03-17 16:44:23Z

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, 2015 at 16:44

Erik Ghonyan

4314 silver badges12 bronze badges

answered Feb 8, 2014 at 5:02

safaiyeh

1,7053 gold badges16 silver badges35 bronze badges

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

Comments

Javu Man · Accepted Answer · 2021-03-12 10:23:26Z

1

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

answered Mar 12, 2021 at 10:23

Javu Man

111 bronze badge

Comments

Calvin Taylor · Accepted Answer · 2023-04-28 15:25:04Z

0

in my case I was using gradle and needed to add

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

answered Apr 28, 2023 at 15:25

Calvin Taylor

7044 silver badges17 bronze badges

Comments

6006604 · Accepted Answer · 2024-03-27 12:35:51Z

-1

I followed these steps for adding the path to a .jar file in intelliJ:

Go to File->Prject Structure->SDKs
Select Classpath tab
Select Your SDK (probably first in a list)
Click "+" icon and add your .jar

And this was no longer need to add some code like, all works properly

    try{
        Class.forName("org.sqlite.JDBC");
    } catch (Exception e){
        ...
    }

I think the problem was caused by problems in jar registration, not by lazy package load

edited Mar 27, 2024 at 12:35

6006604

7,7991 gold badge25 silver badges39 bronze badges

answered Mar 27, 2024 at 8:19

Mysterious Cat

1

Collectives™ on Stack Overflow

ClassNotFoundException: org.sqlite.JDBC [duplicate]

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Related