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

stackoverflow.com/questions/1683949/…

ares
– ares

2014-09-23 12:37:53 +00:00
Commented Sep 23, 2014 at 12:37 — ares
– ares, Commented Sep 23, 2014 at 12:37

Community · Accepted Answer · 2018-07-17 17:12:30Z

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, 2018 at 17:12

CommunityBot

11 silver badge

answered Sep 23, 2014 at 12:40

AlexR

116k16 gold badges137 silver badges216 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rami Del Toro Over a year ago

Thank you Alex. Will give this a whirl. Sounds like this should solve this issue.

Collectives™ on Stack Overflow

Timeout Database connection in Java

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related