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

Issue

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

href="https://i.stack.imgur.com/akiiN.png" rel="nofollow noreferrer">

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

Solution

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 By - silentsudo
Answer Checked By - David Marino (JavaFixing Volunteer)