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

  1. 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.JDBC

JDBC 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?

Comments