[MDEV-31576] Unknown system variable 'transaction_isolation' Created: 2023-06-29  Updated: 2023-09-06  Resolved: 2023-06-30

Status: Closed
Project: MariaDB Server
Component/s: N/A
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: 徐美尧 Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None

Attachments: JPEG File 1688027304259.jpg     JPEG File 1688027462256.jpg     JPEG File 1688027520583.jpg    
Issue Links:
Duplicate
is duplicated by MDEV-32109 Compatibility Broken with Mysql JDBC ... Closed
Relates
relates to MDEV-21921 Make transaction_isolation into a sys... Closed

 Description   

The system variable 'transaction_isolation' is not present in the MariaDB version 11.0.2. When connecting the Java application, an error is reported stating "Unknown system variable 'transaction_isolation'." However, even in versions 10.11 and below, where 'transaction_isolation' system variable is also absent, the application does not encounter an error. The 'transaction_isolation' system variable is present in version 11.1.1. Is there an issue with the 11.0.2 installation package?

 Comments   
Comment by Daniel Black [ 2023-06-29 ]

I saw this for another user using mysql-connector-j which is making assumptions based on a MySQL server which it isn't. Your exceptions appear that this is the case for you too.

Can you drop in replace this with MariaDB-Connector/J?

Comment by 徐美尧 [ 2023-06-30 ]

I used the Mariadb-java-client driver and solved the problem. Thank you very much.

Comment by Daniel Black [ 2023-06-30 ]

Glad to hear it. Thanks for providing the feedback and using MariaDB. Happy SQLing.

Generated at Thu Feb 08 10:24:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.