Timeout Database connection in Java

Question

What options are available in Java to timeout a database connection at a specific period of time?

For example, an application creates a database connection from a data source, then it executes a SQL query which might take 5,15 or even over 60 minutes to return results. This behavior is causing other issues.

What I am asking is regarding this scenario, how can we have the application make the database call and after 15 minutes if the query is still running, then stop query, close connection and continue with the application execution?

Thank you

http://stackoverflow.com/questions/1683949/connection-timeout-for-drivermanager-getconnection — ares, Sep 23 '14 at 12:37

score 2 · Accepted Answer · edited Jul 17 '18 at 17:12

2

This can be achieved by setting transaction timeout. Exception will be thrown if transaction exceeds the preconfigured timeout.

The transaction timeout configuration depends on your environment but it is easy to find instraction for each application server or framework. For example in Spring this can be controlled by attribute of annotation @Transactional (documentation link).

edited Jul 17 '18 at 17:12

Community

1
1

answered Sep 23 '14 at 12:40

AlexR

114,158
16
130
208

Thank you Alex. Will give this a whirl. Sounds like this should solve this issue. – Rami Del Toro Sep 23 '14 at 12:50

Timeout Database connection in Java

1 Answers1