MySQL server connection drop
September 7, 2010
After 8 hours MySQL server side drops idle connections. I don’t want to just allow recovery and have to run a ping every few hours, want driver to handle it. What is this, 1970 still ?
- try add autoReconnect=true to url
- try setting wait_timeout and others on server –
- try c3po instead of dbcp, if using dbcp