CODEWITHSUNDEEP
javamysqlmysql-connectorsinglestore
mindhunt3r
mindhunt3r

Reputation: 201

Error connecting to memsql with mysql J connector

I have memsql server version 6.7. I am able to connect to it using mysql java connector version 5.1.47 from my spring boot application.

But when i upgrade connector version to 8.0.16 I get below 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'.

Can i change datasource.url string to ignore this variable? Any other latest version of driver is supported?

Upvotes: 1

Views: 1811

Answers (2)

Adam Prout
Adam Prout

Reputation: 739

If your concern is the security issue in the 8.0.15 mysql driver you could use the mariaDb drivers instead. We generally recommend folks use them with MemSQL: https://docs.memsql.com/client-downloads/

MySQL 8 made a number of breaking changes (i.e., you will have issues with MySQL 8 drivers connecting to older versions of MySQL as well : https://bugs.mysql.com/bug.php?id=90994)

Upvotes: 2

Andreas
Andreas

Reputation: 159114

From https://github.com/spring-projects/spring-boot/issues/17090:

A relevant change in Spring Boot 2.1.5 would appear to be that it upgraded MySQL's Java connector from 8.0.15 to 8.0.16. The 8.0.x driver should be compatible with MySQL 5.6, 5.7, and 8.0 so this would either appear to be a problem with your configuration or, probably more likely, a regression in the driver. If you would like to pursue this, I would recommend asking for some help on the MySQL forums and providing sufficient information to allow someone to reproduce the problem.

Try version 8.0.15 to see if that works better.

Upvotes: 0

Related Questions