Home > technology > MySQL server connection drop

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 ?

So :

  • try add autoReconnect=true to url
  • try setting wait_timeout and others on server –
  • try c3po instead of dbcp, if using dbcp

 

Advertisements
Categories: technology Tags: , ,
%d bloggers like this: