SingleConnectionDataSource connection closed after about 40 minutes inactivity

Question

We have a problem with org.springframework.jdbc.datasource.SingleConnectionDataSource?

We expect that the connection is never closed while the application is running, even if there is no traffic between application and db.

We configured datasource with <property name="suppressClose" value="true"/> what should solve the problem.

And the problem is that the connection is closed after about 30-40 minutes of inactivity (when there is no traffic between db and application).

Maybe someone with experience with SingleConnectionDataSource can help how to solve this bug or feature.

Could the connection be closed from the db side? Have you set any timeout value in your code? — Michael W, Feb 01 '13 at 16:49
which database are you using, mysql for eg has a wait_timeout property after completion of which the connection drops. — Anugoonj, Feb 01 '13 at 17:22
finally seems to be not java a problem. but anyway thanks for the help. — Łukasz Rzeszotarski, Feb 02 '13 at 21:17
And what the problem was? I have that same. I added setSuppressClose(true); but problably does not help. How did you do?Oh.... 6 years :D — profiler, Jun 20 '19 at 17:01

score 1 · Answer 1 · answered Jan 03 '14 at 15:37

If underneath SimpleConnectionDataSource, a MySql connection is used, then it will usually be dropped after 30-40 minutes of inactivity. Even if you use straight JDBC and create connection via:

Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager
                 .getConnection("jdbc:mysql://localhost/mydatabase?user=username&password=pass");

It will also be dropped after 30-40 mins.

SingleConnectionDataSource connection closed after about 40 minutes inactivity

1 Answers1

Linked