The mysql-connector-java doesn't know to remove the 5.5.5- prefix sent by MariaDB and it thinks it's using an older MySQL version. To support connectors which do not understand the 5.5.5- prefix, an option to not automatically generate it would be needed.
Original title: cannot connect db through maxscale using mysql-connector-java
I could connect DB using mysql-connector-java, and could connect DB through maxscale using mysql cli.
But when using mysql-connector-java connect DB through maxscale it says "java.sql.SQLException: Unknown system variable 'query_cache_size'". This variables is abandoned by mysql 8.0.*. And all the answer about this question is said set the right version to mysql-connector-java could solve this problem. But to me it not works, I think it may could resoved by maxscale.
I catch the packet between client mysql-connector-java and maxscale shows as attachment. 10.197.0.34 is client and 10.197.49.34 is maxscale. The packet no 8 shows it use 8.0.16 mysql-connector-java but also ask query_cache_size info.