Java - SQLite connection (No suitable driver found for JDBC:sqlite:main.db)

Question

I have problem with SQLite connection on my Java project. Error looks like this :

No suitable driver found for JDBC:sqlite:main.db

That's my code:

public static void main(String[] args)  {

    Connection c = null;
    try {
      //  Class.forName("org.sqlite.JDBC");
        String url = "JDBC:sqlite:main.db";
        c = DriverManager.getConnection(url);
        System.out.println("Connection to sql");
    } catch ( SQLException e ) {
        System.err.println( e.getMessage() );
    } finally {
        try{
            if( c!= null ) {
                c.close();
            }
        }catch( SQLException ex )
        {
            System.out.println(ex.getMessage());
        }
    }
}

Can You help me please?

Babatunde Adeyemi · Accepted Answer · 2017-06-23 15:24:44Z

6

If you're using maven, ensure that the scope isn't specified as test.i.e.

<dependency>
        <groupId>org.xerial</groupId>
        <artifactId>sqlite-jdbc</artifactId>
        <version>3.18.0</version>
</dependency>

answered Jun 23, 2017 at 15:24

Babatunde Adeyemi

14.5k4 gold badges38 silver badges26 bronze badges

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

Comments

duffymo · Accepted Answer · 2017-04-01 19:56:11Z

3

"No suitable driver" means that the connection URL is incorrect for the JDBC driver JAR that was loaded.

Case matters: it should be jdbc:sqlite:main.db. Please read the tutorial.

answered Apr 1, 2017 at 19:56

duffymo

310k46 gold badges376 silver badges571 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:18:10Z

0

I think you have not added the SQLITE JDBC driver to your classpath. Just download the jar FROM HERE and add it to your classpath. Your error would be resolved.

You should also have a look on This answer and This resource. By reading both of them you will learn more about SQLITE as well as how to make a connection with JDBC.

edited May 23, 2017 at 12:18

CommunityBot

11 silver badge

answered Apr 1, 2017 at 19:27

Anant666

41611 silver badges28 bronze badges

4 Comments

Mark Rotteveel Over a year ago

Please include the relevant parts in your answer, don't only rely on links only. On top of that, it doesn't even address the actual problem: the wrong case of "JDBC:..." instead of "jdbc:...".

Anant666 Over a year ago

@Mark honestly I didn't knew the actual answer. Hence I gave the working examples links so that the questioner will benefit from some extra details given on those links, and that might give an extra edge to his knowledge and expertise. Thanks for pointing out, I will take care from the next time.

Mark Rotteveel Over a year ago

In that case it is better to leave a comment, instead of answering.

Anant666 Over a year ago

yeah sure, I was not fully aware of these stackoverflow rules. Thanks,

Collectives™ on Stack Overflow

Java - SQLite connection (No suitable driver found for JDBC:sqlite:main.db)

3 Answers 3

Comments

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related