SimYeJu opened a new issue #16516:
URL: https://github.com/apache/shardingsphere/issues/16516
## Enviroment
ShardingSphere
- proxy 5.0.0
- mysql-connector/J 5.1.47
DBMS
- MySQL 5.7.22
- MySQL 8.0.22
Application
- Spring Boot 2.5.5
Could I connect MySQL other version(both 5.7.22 and 8.0.22) as DS to
ShardingSphere-proxy 5.0.0?
I run that enviroment but returned under error message.
> WARN [com.zaxxer.hikari.pool.PoolBase:checkDefaultIsolation:491] PORT:6481
[main] HikariPool-4 - Default transaction isolation level detection failed
(Could not map transaction isolation '1' to a valid JDBC level.).
ERROR [com.zaxxer.hikari.pool.HikariPool:createPoolEntry:498] PORT:6481
[main] HikariPool-4 - Error thrown while acquiring connection from data source
java.sql.SQLException: Could not map transaction isolation '1' to a valid
JDBC level.
So, I query 'SELECT @@SESSION.tx_isolation' at MySQL client with
ShardingSphere-proxy 5.0.0, and I receive result 1.
<img width="324" alt="image"
src="https://user-images.githubusercontent.com/55989240/160995334-e7d4a943-6efe-4aa1-b87a-e2468565933f.png";>
I know tx_isolation is deprecated at MySQL 8 version.
though... How Can I use other MySQL version with ShardingSphere-proxy?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
![https://user-images.githubusercontent.com/55989240/160995334-e7d4a943-6efe-4aa1-b87a-e2468565933f.png"](https://user-images.githubusercontent.com/55989240/160995334-e7d4a943-6efe-4aa1-b87a-e2468565933f.png"){kind=link}