CA WA Agent: How to change or upgrade JDBC driver

Document ID : KB000115595
Last Modified Date : 21/09/2018
Show Technical Document Details
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.
Question:
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
Answer:
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.

Download the drivers directly from the DB vendor site. Remove the old JDBC jar file from this directory:
<agent_install_directory>/jars/ext/<some_jdbc>.jar
Note: Do not rename, remove or delete the JDBC jar file from agent directory

Copy the <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
Additional Information:
Note: CA does not write or maintain the JDBC drivers.  The drivers must be downloaded from the database vendor website.