MySQL JDBC Error Preventing Login - Cannot load JDBC driver class 'com.mysql.jdbc.Driver'

Products

• CA Release Automation - Release Operations Center (Nolio)
• CA Release Automation - DataManagement Server (Nolio)

Issue/Introduction

After installing Release Automation (RA), using MySQL as the back end, upon starting the server, no users are able to login.
Upon checking the installation log, the following error is found:

[localhost-startStop-1] WARN (com.nolio.platform.server.dataservices.services.upgrade.UpgradeServiceImpl:1142) - Could not retrieve version info from DB. org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver' 

(Note: Installation logs include <RA SERVER HOME>\.install4j\installation.log and <RA SERVER HOME>\logs\center_upgrade.log.)

Cause

This issue occurs when Release Automation does not have the required MySQL driver.

Environment

Any Release Automation environment configured to run on MySQL.

Resolution

1.  Get the correct JDBC driver for your MySQL database.  Please work with your MySQL database admin to ensure you have the correct driver files. For example: "mysql-connector-java-5.1.49.jar"

2.  Copy the "mysql-connector-java-5.1.49.jar", obtained from MySQL, to the following locations: 

     <RA SERVER HOME>\lib\ 

     <RA SERVER HOME>\webapps\datamanagement\WEB-INF\lib\

3.  Restart Release Automation.   

The driver should now be loaded correctly and allow Release Automation to start and be accessible to end users.

Additional Information