CA WA Agent: How to change or upgrade JDBC driver

Products

• Workload Automation Agent
• DSERIES- SERVER
• CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

Several CA WA Business Agents use JDBC driver to connect to the database.  The following require the JDBC drivers, the install package (pak file) comes with appropriate drivers.

• CA Workload Automation Agents (Plug-Ins) Documentation
  • Agent for Databases
  • Agent for Informatica
  • Agent for Microsoft MS SQL
  • Agent for Oracle E-business Suite
  • Agent for PeopleSoft
  • Agent for Remote Execution
  • Agent for SAP
• Advanced Integrations
  • CA Workload Automation Advanced Integration for SAP

How to upgrade the JDBC drivers?

Environment

CA WA Agent Plugins

• Agent for Databases
• Agent for Informatica
• Agent for Microsoft MS SQL
• Agent for Oracle E-business Suite
• Agent for PeopleSoft
• Agent for Remote Execution
• Agent for SAP

Resolution

The JDBC driver may be upgraded if a newer version has been made available by the database vendor.  The driver may need to be updated if the vendor recommends new driver or if the database has been upgraded.

Follow these steps:

1. Download the drivers directly from the DB vendor site.

2. Remove the old JDBC jar file from <agent_install_directory>/jars/ext/ directory:

<agent_install_directory>/jars/ext/<some_jdbc>.jar

Note: Remove or delete the old JDBC jar file. Do not rename it. 

3. Copy the new <jdbc_file_name>.jar to the following directory.

<agent_install_directory>/jars/ext/

Each vendor names the files differently.  Refer to DB vendor for exact filename and version.  Here are filenames of commonly used drivers (names may change):

 Oracle :             ojdbc[N].jar           E.g.  ojdbc7.jar
 MS-SQL:           sqljdbc[NN].jar     E.g.  sqljdbc42.jar
 IBM DB2:          db2jcc.jar and db2jcc_license_cu.jar (two files)
 PostgreSQL:     postgresql.jar

4. Restart the Agent for the change to take effect.

Additional Information

Note: Broadcom (CA) does not write or maintain the JDBC drivers.  The drivers must be downloaded from the database vendor website.