MariaDB 11 is broken with the MySQL connector

[dcelasun]

Describe the bug Commafeed 3.8.1 fails to start with the following error:

WARN  [2023-07-11 06:51:28,297] org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator: HHH000342: Could not obtain connection to query metadata
! com.mysql.cj.exceptions.CJException: Unknown system variable 'transaction_isolation'
! at jdk.internal.reflect.GeneratedConstructorAccessor20.newInstance(Unknown Source)
! at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
! at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
! at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
! at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
! at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150)
! at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:128)
! at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:849)
! at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:771)
! at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:701)
! at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:156)
! at com.mysql.cj.NativeSession.loadServerVariables(NativeSession.java:445)
! at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1269)
! at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:858)
! ... 41 common frames omitted

To Reproduce Try to start Commafeed using the MySQL connector and MariaDB>=11.

Additional context It seems other projects have run into the same issue and the solution is to support the MariaDB connector directly.