Cisco Cisco Workload Automation 6.3 Guia Do Utilizador

Configuring the JDBC Adapter

Defining a Connection Using JDBC

The driver class entered here must be found in the CLASSPATH on the master machine. For information, see 

.

In the 

 field, enter the user that is used to connect to the database from the drop-down menu.

You must enter a user to specify a database in the 

 field.

(Optional) In the 

 field, select from the drop-down menu or enter the name of the database for 

this connection. 

The drop-down menu only lists databases for connections where a database name is optional; otherwise, if a 
database name is required to make a JDBC connection, you must type in the name.

In the 

 field, enter the JDBC driver connection URL as specified in your driver’s 

documentation.

Click the 

 tab.

In the 

 field, enter the number of seconds between successive poll checks of an event monitor that the 

adapter uses to check whether it should raise an event.

Enter queries specific to your database platform in the 

 pane.

If you had selected a JDBC template previously, queries for the selected database will populate automatically in 
many cases. Optionally, you can override these queries or provide your own custom queries.

 – Queries the version number of the database.

 – Queries the time of the database’s server.

 – Queries the UTC time for the database server. 

The local time and the UTC is used to get the time zone and calculate the time difference between the database 
server and the scheduling master.

 – Queries the health of the database based on any custom SQL select statement.