SocketException trigger by MySQL 5.6.22 using Java-5.0.8 connector

Question

I am using facing a SocketException: connection reset problem after 60sec of idle.

My meaning of idle is that I open a connection but do not do anything exception after 60sec (say 61sec) to person a insert/update/select.

Do I need to change the SQL configuration file or can I change some setting to JDBC in my code during connection. If yes, what should I change?

Thanks for any help.

update question with stack trace – V__ Feb 27 '15 at 10:03 — V__, Feb 27 '15 at 10:03
stacktrace in another PC, unable to copy and paste – chj Feb 27 '15 at 10:05 — chj, Feb 27 '15 at 10:05
stacktrace not provided, unable to answer question – Stephen C Feb 27 '15 at 10:20 — Stephen C, Feb 27 '15 at 10:20

score 0 · Answer 1 · edited May 23 '17 at 10:24

0

I guess you have the idle time out set too low.

You can adjust the time out or tell the connection to auto-reconnect.

edited May 23 '17 at 10:24

Community

answered Feb 27 '15 at 10:24

ISparkes

1 Answers1