mysql target: mysql-connector-j + waprgate issue

[clementmoulin]

Hi !

I'm using DBeaver (using mysql-connector-j) to access mySQL, and encoutering an issue when using warpgate.

Connecting directly => no issue.
Connecting through warpgate, i'm getting the following error: Unknown system variable 'query_cache_size'

After some research, I found this is probably because mysql-connector-j is not able to detect correct mySQL server version, and try to get an obsolete parameter "query_cache_size" (removed in 8.0.3).

Thanks for your work and your help !