[CONJ-808] Unable to connect to server with version 2.6.1 Created: 2020-07-16  Updated: 2020-07-22  Resolved: 2020-07-22

Status: Closed
Project: MariaDB Connector/J
Component/s: configuration
Affects Version/s: 2.6.1
Fix Version/s: 2.6.2

Type: Bug Priority: Critical
Reporter: Alex Assignee: Diego Dupin
Resolution: Fixed Votes: 0
Labels: regression
Environment:

java 11, spring boot, mariadb 10.3


Issue Links:
Duplicate
duplicates CONJ-804 2.6.1 fails to connect with "Variable... Closed

 Description   

Upgrading to latest version of the connector makes my app unable to connect to the database with the following error:

java.sql.SQLSyntaxErrorException: Could not connect to address=(host=localhost)(port=3306)(type=master) : (conn=409) Variable 'character_set_client' can't be set to the value of 'utf32'

at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[mariadb-java-client-2.6.1.jar!/:na]

I tried to change the connection url (adding CharSet=utf8) and also configuring default client and server charset on mariadb (running on debian buster), but without luck.

Since I was unable to find a way to fix this problem I had to revert to the old version (2.6.0 is fine)



 Comments   
Comment by Alex [ 2020-07-16 ]

I suppose this is a duplicate of CONJ-804

Comment by Diego Dupin [ 2020-07-17 ]

That's strange, because only utf8* collation are set by connectors.
could you send the result of "SELECT @@character_set_server, @@collation_server, @@version;" on your server?

Comment by Diego Dupin [ 2020-07-17 ]

forget that, found the issue

Generated at Thu Feb 08 03:18:27 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.