Job failed with java.sql.SQLException: No suitable driver found
search cancel

Job failed with java.sql.SQLException: No suitable driver found

book

Article ID: 4447

calendar_today

Updated On:

Products

Workload Automation Agent CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation DE - Business Agents (dSeries)

Issue/Introduction

When executing a  DBMON job for DB2 we are getting error like below, while running the job.

java.sql.SQLException: No suitable driver found for jdbc:db2://host.example.com:port/database

 

Environment

CA Workload Automation Agent for Databases

Cause

The agent's agentparm.txt is missing jdbc driver class for DB2.

Resolution

Ensure that the jdbc.drivers property in the agentparm.txt file includes the driver for DB2, and restart the agent;

Example:
jdbc.drivers=oracle.jdbc.OracleDriver:net.sourceforge.jtds.jdbc.Driver:com.ibm.db2.jcc.DB2Driver

Also, make sure that the jdbc driver is installed, see link for detailed.