How long does a JDBC connection live if not closed in java code?

Question

If I open up a JDBC connection in my java code and forget to close it, will it remain open for ever? Or is there a default time out value that I can specify somewhere?

`finally` clauses are your friend. – Marvo Apr 24 '12 at 21:43 — Marvo, Apr 24 '12 at 21:43

score 4 · Accepted Answer · answered Apr 23 '12 at 14:35

In first place, you really need to fix the code to close it. No excuses.

As to the concrete question, that depends on the DB server used. It's the DB server who will timeout and reclaim it. Refer the DB server specific administration manual for defaults and how to change it. In case of for example MySQL, it's the wait_timeout setting which defaults to 28800 seconds (8 hours).

score 0 · Answer 2 · answered Apr 24 '12 at 21:42

0

It depends on the specifics of the JDBC driver implementation. Some might have a timeout. Some might close when the connection object is garbage collected and finalize is called, but (1) you don't know how long after you stopped referencing the object it gets garbage collected, and (2) the finalize is not reliably called.

answered Apr 24 '12 at 21:42

Marlin Pierce

9,931
4
30
52

(1) is valid. But assuming (1) happens, finally IS reliably called. – Cruncher Jul 09 '14 at 11:28
Some Java implementations do not guarantee calling finally. – Marlin Pierce Jul 14 '14 at 14:24

How long does a JDBC connection live if not closed in java code?

2 Answers2

Linked