JDBC Detector
The JDBCDetector connects to a JDBC-enabled database and tries to fetch its catalog.
If the fetch is successful, it returns the detected
value.
If it is not successful, it returns the not detected
value.
Configuration and use
The JDBCDetector uses the common configuration parameters.
Parameter | Description | Default value |
---|---|---|
Required |
||
dbDriver |
Database driver class name. |
org.postgresql.Driver |
password |
JDBC password. |
Empty String object. |
url |
JDBC URL to query. Note: this URL can differ based on JDBC drivers, databases, and so on. |
|
user |
JDBC username. |
postgres |
Optional |
||
port |
Port to query. |
3306 |
Database driver
The JDBCDetector requires a JDBC driver to communicate with any database.
Meridian uses a PostgreSQL database, so the PostgreSQL JDBC driver is included out of the box.
For all other database systems, you must provide a compatible JDBC driver as a .jar
file.
To provide a JDBC driver, place the driver-jar in your ${OPENNMS_HOME}/lib
folder.
Examples
<detector name="MySQL-JDBC" class="org.opennms.netmgt.provision.detector.jdbc.JdbcDetector">
<parameter key="password" value="borkborkbork"/>
<parameter key="user" value="opennms"/>
<parameter key="dbDriver" value="com.mysql.jdbc.Driver"/>
<parameter key="url" value="jdbc:mysql://OPENNMS_JDBC_HOSTNAME:3306/test"/>
<parameter key="timeout" value="5000"/>
</detector>
This example assumes you have loaded the MySQL driver file (see Install JDBC Driver).