Db Jdbc Class (collection.cfg)

Description

This parameter specifies the 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/

Note: Older versions of Funnelback required JDBC drivers to be installed in <install_root>/lib/java/. This will no longer be supported from Funnelback 9.0 onwards i.e. the driver files are now required to be in the dbgather directory.

Common drivers

DatabaseDriverSite
MySQLcom.mysql.jdbc.DriverConnector/J
Oracleoracle.jdbc.OracleDriverOracle JDBC
PostgreSQLorg.postgresql.DriverPostgres JDBC (included with Funnelback)
SQLiteorg.sqlite.JDBCSQLite JDBC
SQL Servercom.microsoft.sqlserver.jdbc.SQLServerDriverSQL Server JDBC
IBM DB2com.ibm.db2.jcc.DB2DriverIBM

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)

Example

db.jdbc_class=oracle.jdbc.OracleDriver

top