Details
- 
    
Bug
 - 
    Status: Closed (View Workflow)
 - 
    
Minor
 - 
    Resolution: Fixed
 - 
    2.4.6
 - 
    None
 - 
    mysql 8.0.16
maxscale 2.4.6
mysql-connector-java 8.0.16 
Description
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.
Attachments
Issue Links
- relates to
 - 
                    
MXS-4865 5.5.5- prefix should not be added if all backends are MariaDB 11
-         
 - Closed
 
 -