r2rml icon indicating copy to clipboard operation
r2rml copied to clipboard

No suitable driver found for jdbc:sqlite

Open vemonet opened this issue 7 years ago • 1 comments

We are trying to convert a SQLite database (the chinook.db example) but r2rml is having trouble finding the driver

2018-12-06 15:16:46 ERROR R2RMLProcessor:98 - Error connecting to database.
java.sql.SQLException: No suitable driver found for jdbc:sqlite:/data/chinook.db
	at java.sql.DriverManager.getConnection(DriverManager.java:689)
	at java.sql.DriverManager.getConnection(DriverManager.java:208)
	at r2rml.engine.R2RMLProcessor.createDatabaseConnection(R2RMLProcessor.java:90)
	at r2rml.engine.R2RMLProcessor.execute(R2RMLProcessor.java:39)
	at r2rml.Main.main(Main.java:59)

vemonet avatar Dec 06 '18 15:12 vemonet

If anyone needs it, we use

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

And import in Main class:

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

vemonet avatar Sep 27 '19 08:09 vemonet