search

chrdebru / r2rml

MIT License
30 stars 20 forks source link

No suitable driver found for jdbc:sqlite #5

Open vemonet opened 5 years ago

vemonet commented 5 years ago

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 commented 5 years ago

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();};