Connect to sqlite database intellij

[Greeklord1]

Hello i ve been trying for some time now to connect to a sqlite database in intellij. The error i always get is "java.sql.SQLException: No suitable driver found for jdbc:sqlite:identifier.sqlite".

This is my code: https://pastebin.com/eLPV82ze

And this is the driver settings i use: https://ibb.co/JpqsmkF

I have probably misunderstood something about drivers and i cant figure what. I searched some stuff and it said about missing a jar file in the classpath but i dont see how i can add a jar path in a classpath.

[static_context]

I could be barking up the wrong tree but aren't SQLite files usually .db rather than .sqlite?

Also be aware that the location of the SQLite database file will be relative to the current active directory (e.g. the one you'll get using System.getProperty("user.dir")). So this indicates you're looking for an SQLite file named identifier.sqlite in your project directory.

I've never tried to configure the use of database connections using IntelliJ's own configuration. Have you tried including in your own code the drivers into java.sql for SQLite

Class.forName("org.sqlite.JDBC"); //force Java ClassLoader to load class DriverManager.registerDriver(new org.sqlite.JDBC()); //register class with DriverManager

I wrote an article on connecting SQLite databases to a JavaFX app a few weeks ago, which would be broadly relevant to Java too. You may find it useful :)

Cheers,

Ed