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

Document ID : KB000008800
Last Modified Date : 14/02/2018
Show Technical Document Details
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