DevTest Registry crashing when configured with MariaDB (MySql)

Products

• CLOUDTEST
• CA Application Test
• CA Cloud Test Mobile
• MOBILECLOUD
• Service Virtualization

Issue/Introduction

Am trying to deploy DevTest 10.3 registry configured with MySQL connection and noticed below error:

Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

I have made the changes in site.properties as lisadb.pool.common.driverClass=com.mysql.jdbc.Driver. where should we bind this class file?

Cause

We  noticed that,  com.mysql.cj.jdbc.Driver class for MySQL version 8. Devtest 10.3 supports MySQL 5.5, 5.6, and 5.7 versions. 

    If you have placed MySQL 8 driver jar and trying to connect to MySQL 5 (com.mysql.jdbc.Driver) we will get this error.

Environment

Release : 10.3

Component : CA Service Virtualization

Registry configured with MySQL database

Resolution

Remove mysql connector jars of version 8 and place the supported mySql 5 driver jars in Devtest_home/lib/shared folder and restart the components.