MySQL Error: Table name pattern can not be NULL or empty. java.sql.SQLException: Table name pattern can not be NULL or empty

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)

Issue/Introduction

When I start Registry, I have this error:

ERROR com.itko.lisa.utils.JpaUtil    - Exception raised checking table existence: Table name pattern can not be NULL or empty.
java.sql.SQLException: Table name pattern can not be NULL or empty.
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:545)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)

Environment

Supported DevTest releases and platforms.

Resolution

In the site.properties file:

lisadb.pool.common.url=jdbc:mysql://<Host>:3306/<DB>?nullNamePatternMatchesAll=true

I added this parameter ?nullNamePatternMatchesAll=true

Example:
lisadb.pool.common.url=jdbc:mysql://localhost:3306/RegDB?nullNamePatternMatchesAll=true

Verify you are using a MySQL Connector/J version that supports MySQL 5.5, 5.6 or 5.7 

Additional Information

https://stackoverflow.com/a/43039214/4587961

https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-versions.html