jeudi 8 octobre 2015

Connect to SQlite (Spiceworks) database from ireports (Jaspersoft)

I'm trying to connect to SQLite db from Jaspersoft ireports. I was able to create a datasource successfully but when I create a report using the datasource it gives me below error message.

java.sql.SQLException: file is encrypted or is not a database

I'm using below JDBC drivers: JDBC Driver: org.sqlite.JDBC JDBC URL: jdbc:sqlite:C:\Users\IT\Desktop\sqllitejdbc\spiceworks_prod.sqlite

Any help is greatly appreciated.

Thanks.

Aucun commentaire:

Enregistrer un commentaire