Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-32109

Compatibility Broken with Mysql JDBC Connector

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 11.0.3
    • N/A
    • N/A
    • None

    Description

      The MySQL JDBC connector/driver (version 8.0.32) is encountering an issue when trying to connect to MariaDB 11.0.3, resulting in an error message stating "Unknown system variable 'transaction_isolation'".

      It appears that this error is related to the fact that 'transaction_isolation' has become a system variable in MariaDB 11.1.1, as indicated in MDEV-21921.

      Interestingly, the MySQL JDBC connector can establish a connection with MariaDB 10.11.5, even though 'transaction_isolation' is not a recognized system variable in that version.

      This suggests a potential bug or compatibility issue in MariaDB 11.0.3.

      Attachments

        Issue Links

          Activity

            danblack Daniel Black added a comment -

            In short, we didn't follow MySQL's changing of variable name to maintain compatibility with MySQL's Connector/J which changed to be compatible with MySQL-8.0.

            As MariaDB compatibility isn't a major consideration there is a major version gap of 11.0 where it is incompatible and as you see, 11.1 is might be back if nothing else changes on the MySQL Connector/J side.

            MariaDB Corporation does maintain a Connector/J that is compatible with MariaDB (and MySQL as we put in the effort - CONJ-604).

            Like the user in MDEV-31576 I hope that a simple replacement of Connector/J implementation will resolve this error and support your applications reliably and with the quality and performance you get from MariaDB Server.

            danblack Daniel Black added a comment - In short, we didn't follow MySQL's changing of variable name to maintain compatibility with MySQL's Connector/J which changed to be compatible with MySQL-8.0. As MariaDB compatibility isn't a major consideration there is a major version gap of 11.0 where it is incompatible and as you see, 11.1 is might be back if nothing else changes on the MySQL Connector/J side. MariaDB Corporation does maintain a Connector/J that is compatible with MariaDB (and MySQL as we put in the effort - CONJ-604 ). Like the user in MDEV-31576 I hope that a simple replacement of Connector/J implementation will resolve this error and support your applications reliably and with the quality and performance you get from MariaDB Server.

            People

              Unassigned Unassigned
              ndabhade Nikhil Dabhade
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.