jdbc mysql自动断开,java jdbc mysql连接器：如何在很长的空闲时间后解决断开连接问题...

最新推荐文章于 2023-03-13 16:58:45 发布

weixin_39963744

最新推荐文章于 2023-03-13 16:58:45 发布

阅读量203

点赞数

文章标签： jdbc mysql自动断开

I'm using red5 1.0.0rc1 to create an online game.

I'm connecting to a MySQL database using a jdbc mysql connector v5.1.12

it seems that after several hours of idle my application can continue running queries because the connection to the db got closed and i have to restart the application.

how can I resolve the issue ?

Kfir

解决方案

The MySQL JDBC driver has an autoreconnect feature that can be helpful on occasion; see Driver/Datasource Class Names, URL Syntax and Configuration Properties for Connector/J, and read the caveats.

In my experience the best solution is to change the MySQL configuration properties to set the session idle timeout to a really large number.