Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

HikariCP Warning: "Driver does not support get/set network timeout for connections" #2196

Closed
xiaogc123 opened this issue Apr 29, 2024 · 1 comment

Comments

@xiaogc123
Copy link

We are experiencing a HikariCP warning: "Driver does not support get/set network timeout for connections" while attempting to use read-write separation based on ShardingSphere 5.4.0. We have explicitly specified to use the MySQL driver (mysql-connector-java 8.0.28).
Detailed steps to reproduce:
We added the dependency for mysql-connector-java 8.0.28 in our pom.xml file;
We explicitly specified the usage of the MySQL driver in ShardingSphere's configuration file (set driver-class-name property).However, the warning message persists.
From our understanding, HikariCP should be able to correctly set the network timeout when using the MySQL driver. We seek some assistance in resolving this issue.
Additional Information:

  • ShardingSphere Version: 5.4.0
  • MySQL Driver Version: mysql-connector-java 8.0.28
  • HikariCP Version: (if available)

Thank you for your assistance!

@linghengqian
Copy link

linghengqian commented May 29, 2024

  • As a Committer of Apache ShardingSphere, I recommend closing this issue and reopening it on the ShardingSphere git https://github.com/apache/shardingsphere to facilitate further investigation. This is a known issue particular to ShardingSphere JDBC's JDBC Driver implementation, present since two years ago, though the original issue report has unfortunately been misplaced.

  • It's necessary to replicate the fetching of this property within ShardingSphere due to ShardingSphere JDBC Driver being a virtual driver that serves as a proxy for multiple underlying real Drivers.

  • This should look like Fixes #638 Implement support for get/setNetworkTimeout(). pgjdbc/pgjdbc#849 .

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants