Service Virtualization

Issue
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

KB: https://support.ca.com/us/knowledge-base-articles.TEC1892356.html