MySQL JDBC Error Preventing Login

book

Article ID: 8492

calendar_today

Updated On:

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 can login to ROC or Automation Studio. 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

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

 

<RA SERVER HOME>\lib\ 

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

 

Restart the NAC aftward, then the driver should be recognized by RA and enable connection to the MySQL database.