CODEWITHSUNDEEP
javadatabasejdbcdatabase-connection
Suhail Gupta
Suhail Gupta

Reputation: 23216

Reusing the connection to the database

Until now, whenever I query the database I open a fresh connection to the database. How do I implement the property that once I open the connection I can reuse that?

With this done, please tell me if I could leak the resources.

Upvotes: 3

Views: 2299

Answers (2)

Tomasz Nurkiewicz
Tomasz Nurkiewicz

Reputation: 340733

Basically you need JDBC connection pool, typically implementing DataSource interface. Have a look at and . Chances are you container/server already provides an implementation of connection pooling.

When you use a connection pool every time you open a connection you are actually taking one from the pool (or opening if pool is empty). When closing the connection, it is actually returned to the pool. The leak can only occur if you forget the latter. (or forget closing ResultSet, Statement...)

Upvotes: 7

Hakan Serce
Hakan Serce

Reputation: 11256

You can (and should) reuse db connections. Connection pooling is one of the techniques for this. A thorough tutorial on connection pooling can be read here : http://java.sun.com/developer/onlineTraining/Programming/JDCBook/conpool.html

Upvotes: 1

Related Questions