db.jdbc_class
The name of the Java JDBC driver to connect to a database.
Key: db.jdbc_class
Type: String
Can be set in: collection.cfg
Description
This parameter specifies the database JDBC driver class which should be used to connect to the database. The value should be a fully qualified class name, which must have been installed as described below.
Installing JDBC drivers
Most JDBC drivers ship as a .jar
(java archive) file. Funnelback is configured to automatically make
all .jar
files installed in certain locations available to the database gathering components.
To install a JDBC driver, simply copy the .jar
file to the following directory (where <install_root>
is the directory that Funnelback has been installed in):
<install_root>/lib/java/dbgather/
When installing drivers be careful to install only one version of any particular driver to avoid any Java errors relating to duplicate class definitions.
Common drivers
Database | Driver | Site |
---|---|---|
MySQL | com.mysql.jdbc.Driver |
Connector/J |
Oracle | oracle.jdbc.OracleDriver |
Oracle JDBC |
PostgreSQL | org.postgresql.Driver |
Postgres JDBC (included with Funnelback) |
SQLite | org.sqlite.JDBC |
SQLite JDBC (included with Funnelback) |
SQL Server | com.microsoft.sqlserver.jdbc.SQLServerDriver |
SQL Server JDBC |
IBM DB2 | com.ibm.db2.jcc.DB2Driver |
IBM |
Testing the driver
The create collection page for database collections provide a check connection button to test that
the driver is correctly installed. If this connection test doesn't return any useful information you
can try to run the database gatherer on the command line with the --test_connection
option:
$SEARCH_HOME/bin/dbgather.pl /path/to/collection.cfg --test_connection
Default Value
(none)
Examples
db.jdbc_class=oracle.jdbc.OracleDriver