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

Updated to 3.5.0 and "java.sql.SQLException: The connection property 'autoReconnect'" #30

Open
TomLewis opened this issue Aug 3, 2021 · 3 comments

Comments

@TomLewis
Copy link

TomLewis commented Aug 3, 2021

https://gist.github.com/TomLewis/ca99cbb0a12e9193eebe53ed24afc198

In my config, I use;
database: 'Database_Name?autoReconnect=true'

This worked perfectly fine before as this caused database issues when it randomly disconnected before.

@milkwalk
Copy link
Owner

milkwalk commented Aug 5, 2021

@TomLewis why are u using that? I've checked it and its not actually recommended to use https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-connp-props-high-availability-and-clustering.html

The use of this feature is not recommended, because it has side effects related to session state and data consistency when applications don't handle SQLExceptions properly,

XPBoost internally uses HikariCP and it renews and manages connections automatically within some period.

@TomLewis
Copy link
Author

TomLewis commented Aug 6, 2021

I set it years ago, I cant remember why, there was an issue with XPBoost SQL connection breaking other things, and adding that fixed it.

@milkwalk
Copy link
Owner

milkwalk commented Aug 6, 2021

@TomLewis are u able to check if issue still persists?

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