Issue Installing and Configuring PeopleSoft Plug-in

Products

• Workload Automation Agent

Issue/Introduction

I am trying to configure the PeopleSoft plug-in for my DE scheduler Agent. The log contains error similar to this:
- java.sql.SQLException: No suitable driver found for jdbc:sqlserver://XXXXXXXX:1433;DatabaseName=XXXXXX

Environment

CA Workload Automation Agent for PeopleSoft (PeopleSoft plugin)

Cause

The Workload Automation Agent for PeopleSoft (PeopleSoft plugin) requires the JDBC driver and driver class name for the PeopleSoft database you are using.

Resolution

Ensure that the driver JAR files are in the <agent>/jars/ext directory.
Also ensure that the jdbc.drivers property in the agentparm.txt file includes the driver or drivers you are using.
Example:
jdbc.drivers=oracle.jdbc.driver.OracleDriver:net.sourceforge.jtds.jdbc.Driver

 

Additional Information

IMPORTANT:
The agent requires JDBC drivers for the database you are using.
Before starting the agent, obtain the necessary drivers from your database provider, and place them in the following directory: <agent>/jars/ext subdirectory.

Troubleshooting