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


Article ID: 8492


Updated On:


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


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 ( - 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.)


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


Any Release Automation environment configured to run on MySQL.


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