java.sql.SQLException: No suitable driver found for jdbc:sqlite using Ubuntu and InteliJ

Question

There so many aked this, nearly simular, here i Stackoverlow. i read twenty of them. But i need ask anyway.

I created a db successful so:

cd ~/ ..... /resources
sudo apt-get install sqlite3 libsqlite3-dev
sqlite3 mydatabase.db

In Java (inteliJ) i get Error:

java.sql.SQLException: No suitable driver found for jdbc:sqlite:resources:mydatabase.db

    String url = "jdbc:sqlite:resources:mydatabase.db";
    Connection conn = null;
    try {
        conn = DriverManager.getConnection(url);
    } catch (SQLException e) {
        System.out.println(e.getMessage());
    }
    return conn;

mydatabase.db

@rkosegi i could access sqlite3 from everywhere. example: `cd ~ $ sqlite3` — SL5net, Mar 05 '21 at 13:23
@SL5net that doesn't mean you have the correct jar in your classpath. Just that you installed the sqlite client. — Federico klez Culloca, Mar 05 '21 at 13:24
@rkosegi thanks i added dependencies to pom.xml get errors. its red: https://i.imgur.com/Sr0ITRw.png — SL5net, Mar 05 '21 at 13:30

score 2 · Accepted Answer · answered Mar 05 '21 at 13:23

2

Please add the following entry to dependencies of pom.xml of your project

<!-- https://mvnrepository.com/artifact/org.xerial/sqlite-jdbc -->
<dependency>
    <groupId>org.xerial</groupId>
    <artifactId>sqlite-jdbc</artifactId>
    <version>3.34.0</version>
</dependency>

Check here for more specific version

answered Mar 05 '21 at 13:23

silentsudo

6,730
6
39
81

java.sql.SQLException: No suitable driver found for jdbc:sqlite:resources:mydatabase.db – SL5net Mar 05 '21 at 13:26
1

did you do clean build? – silentsudo Mar 05 '21 at 13:27
i using the menus from inteliJ for build. Build, run or debug. yes i rebuld there – SL5net Mar 05 '21 at 13:33

score 1 · Answer 2 · answered Mar 05 '21 at 13:45

1

Please make sure that you have downloaded the sqlite-jdbc jar file and added it as a library for this module. Here is a link to the driver on GitHub with step-by-step instructions to implement it into your module.

answered Mar 05 '21 at 13:45

Cory Dorfner

81
5

thanks its solved already: here https://stackoverflow.com/a/66493660/2891692 . – SL5net Mar 05 '21 at 13:49

score -1 · Answer 3 · answered Mar 05 '21 at 13:43

Very thanks to silentsudo answer. I tried edit his answer, add a little, and ask him, but he was not available anymore for me like so.

Now his very good answer with little needet modification:

Please add the following entry to `dependencies` of pom.xml of your project

<!-- https://mvnrepository.com/artifact/org.xerial/sqlite-jdbc -->
<dependency>
    <groupId>org.xerial</groupId>
    <artifactId>sqlite-jdbc</artifactId>
    <version>3.34.0</version>
</dependency>

probalby the its red in inetliJ.

press then: File > invalid cache > and restart intellij

then pom should not look red. and and it should work

Check here for more specific version

in inteliJ you need also to in last step invalid cache and restart intellij

java.sql.SQLException: No suitable driver found for jdbc:sqlite using Ubuntu and InteliJ

3 Answers3