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

Document created by MarcyNunns Employee on Nov 27, 2017
Version 1Show Document
  • View in full screen mode

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

Attachments

    Outcomes