Not able to connect to MemSQL 6.7 with MySQL J Connector 8.0.16


#1

Getting error - Caused by: java.sql.SQLException: Unknown system variable ‘performance_schema’

Ran query SHOW VARIABLES; on my memsql instance and I do not see system variable ‘performance_schema’. But seems like MySQL JDBC Connector 8.0.16 expects it.

It works fine with MySQL JDBC connector 5.1.47 but its too old and I want to upgrade driver. Any suggestions?


#2

Hello Vitthalkumar,

I would suggest using MySQL JDBC Connector 8.0.13 and make appropriate changes on settings file, it should resolve the problem.
Please find the link to download the same:
http://central.maven.org/maven2/mysql/mysql-connector-java/8.0.13/mysql-connector-java-8.0.13.jar

Thanks!

Regards,
Nithin