r2rml
r2rml copied to clipboard
No suitable driver found for jdbc:sqlite
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)
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();};