xunyard opened a new issue #8736: URL: https://github.com/apache/shardingsphere/issues/8736
## Feature Request During use loadbalnce in jdbc url configuration, it will cause problem (related to bug #5531 [fail to switch schema] ). ## Conditions - Spring boot application (v2.1.6) - @Transicational annotaion(optional) - sharding proxy(v4.1.1) - mysql-connector-java (v8.0.19) ## Other stuff jdbc url config example like: `url: jdbc:mysql:loadbalance://127.0.0.1:3307,127.0.0.1:3407/db?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF8&serverTimezone=Asia/Shanghai&tcpKeepAlive=true&autoReconnect=true` key code in jdbc will cause problem: `com.mysql.cj.jdbc.ha.MultiHostConnectionProxy#syncSessionState(com.mysql.cj.jdbc.JdbcConnection, com.mysql.cj.jdbc.JdbcConnection)` `com.mysql.cj.jdbc.ha.LoadBalancedConnectionProxy#pickNewConnection` ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected]
