Close DBCP connection on application exit

Question

In out app we use Apache DBCP connector for Oracle DB. But every 30 or 40 minutes we get connection size leak error.

Is there any way to close all connections from pool before app is exit?
e.g. write a method, which can get close event and in that method we can close connections safely.

score 0 · Answer 1 · answered Aug 24 '15 at 07:53

In mysql there is a way to provide a timeout for sleeping connections (connections not closed properly). This helps a lot in cases where connections leak due to application not closing the connections properly.

There should be an alternative for the same in oracle as well.

score 0 · Answer 2 · answered Aug 24 '15 at 07:59

0

When you terminate your app, all the connections are freed after some particullary short time like few seconds. But if your app dosn't handle the closing connections it may not exit at all. You need to close any open connections after you use them in a finally block of try/catch statements.

if your app is a gui app, the JFrame will not exit by default, and not termiante your app.

try adding this invocation on your JFrame (if you use one) it will cause the app to exit permanently after you click the "X" to close the window;

frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

answered Aug 24 '15 at 07:59

Krzysztof Cichocki

6,294
1
16
32

I use connection.close statement in finally block. but after the app is terminated I see, that in oracle connections are not closed. even after few minutes. – Jack Daniel Aug 24 '15 at 08:02
and no, it's not a Swing or GUI app – Jack Daniel Aug 24 '15 at 08:02
Are you completly sure, that your app exited? Check it in a process manager, that there is no running instance of your application. – Krzysztof Cichocki Aug 24 '15 at 08:03
1

To add a hook on the exit event of VM, you can use Runtime.getRuntime().addShutdownHook(Thread hook) – Krzysztof Cichocki Aug 24 '15 at 08:07

Close DBCP connection on application exit

2 Answers2