Verify Agent DB Plugin is Configured for MS SQL

Document ID : KB000101851
Last Modified Date : 15/06/2018
Show Technical Document Details
Issue:
Installed the database plug-in today but having difficulty running a DB job successfully.
Environment:
CA Workload Automation Agent for Databases
CA Workload Automation EE (ESP Edition)
Cause:
The DB_MON job is failing with the SQL database exception like below;
java.sql.SQLException: No suitable driver found for xxxxxxxxxx.xxxxxx.com,3232
 
Resolution:
The DB_URL specified in the job definition is not a valid database URL. The format of the DB_URL statement should be as below;
For Microsoft SQL Server database:
DB_URL 'jbdc:sqlserver://host:port;DatabaseName=dbname'

Notes:
- Ensure that the database driver JAR files for your SQL Server database are in the <Agent_Installdir>/jars/ext directory.
- The jdbc.drivers property in the agent's agentparm.txt file should include the database driver type.
Example:
jdbc.drivers=oracle.jdbc.driver.OracleDriver:net.sourceforge.jtds.jdbc.Driver