Index SQLite database
Managed by | Updated .
JDBC driver
JDBC driver is available from: https://github.com/xerial/sqlite-jdbc https://bitbucket.org/xerial/sqlite-jdbc/downloads
eg. https://bitbucket.org/xerial/sqlite-jdbc/downloads/sqlite-jdbc-3.8.11.2.jar
- Download the JDBC driver and copy it to $SEARCH_HOME/lib/java/dbgather/
Driver class
When configuring the DB collection the driver class needs to be set to
collection.cfg
db.jdbc_class=org.sqlite.JDBCJDBC connection URI
The JDBC connection URL should look like the URL below. Replace $SEARCH_HOME/data/$COLLECTION_NAME/chinook.db with the path to the sqlite DB file.
collection.cfg
db.jdbc_url=jdbc:sqlite:$SEARCH_HOME/data/$COLLECTION_NAME/chinook.db
Was this artcle helpful?