Couldn't find JDBC drivers for Microsoft SQL Server in ./lib directory.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Couldn't find JDBC drivers for Microsoft SQL Server in ./lib directory.

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

Detailed Description and Symptoms

When you run Admin.bat using the latest SQL Server Driver (sqljdbc4.jar) the following error:

Couldn't find JDBC drivers for Microsoft SQL Server in ./lib directory

Investigation

The admin.bat doesn't include a entry for the latest SQL Server driver:

java -classpath clearview_admin.jar;lib\commons-logging-1.1.jar;lib\crypt.jar;lib\uc4.jar;lib\ojdbc5.jar;lib\ojdbc6.jar;lib\sqljdbc.jar;lib\sqljdbc4.jar;lib\db2jcc.jar;lib\db2jcc4.jar com.uc4.gwa.admin.Main -r -w
pause

Solution

?Add 'lib\sqljdbc4.jar' to the path and run the admin.bat again.