why to close Database connection

Question

Why should we close a database connection? what can happen if a connection is left open? does the connection gets closed automatically when app exits?

score 1 · Answer 1 · answered Sep 18 '12 at 08:38

1) Open connections as late as possible

2) Close connections as soon as possible

The connection itself is returned to the connection pool. Connections are a limited resource. Any new connection you establish that has exactly the same connection string will be able to reuse the connection from the pool.

score 0 · Accepted Answer · edited May 23 '17 at 11:43

0

It's not really necessary to close your database connection. See this question on stackoverflow for a more detailed explanation.

edited May 23 '17 at 11:43

Community

1
1

answered Sep 18 '12 at 08:35

Ceetn

2,728
2
25
28

score 0 · Answer 3 · answered Sep 18 '12 at 08:35

0

To release the resourcess like handler,we should use DBHelper.close(); to close Database, if you not close database,its may arise problem when you try to reconnect to Database. So to overcome this problem , we must close Database.

answered Sep 18 '12 at 08:35

Rajendra

1,700
14
17

why to close Database connection

3 Answers3