Cisco Cisco Workload Automation 6.3 User Guide

Configuring the JDBC Adapter

Defining a Connection Using JDBC

If the query returns a result set, the connection is considered healthy (green). If an empty result set is returned, the 
connection is considered unavailable (red).

 - Queries the content of a stored procedure that is displayed in the 

 tab in the 

 dialog.

Use $1 as a placeholder for the stored procedure name, which is replaced by an actual procedure name when the 
adapter needs to get the help or text associated with the stored procedure.

Click 

.

JDBC Connection Status Light

If the connection using JDBC is not available to the master, the connection status light in the first column of the display 
is red, and the 

 status light at the bottom of the console is red (or yellow if other agents are connected to 

the master).

This light is relative to the status of the connection to the CWA master, not the connection to the client.

The status light indicates the health of the adapter connection to the database. If a health query has been provided on 
the 

 tab described previously in 

, it will also be used to determine 

the connection status.

If the CWA master cannot connect or loses its connection to a database, you will see a red status light next to your 
connection using JDBC in the 

 pane.

If the adapter connection using JDBC is not available, you will not be able to define JDBC jobs.