share your understanding about Connection Pooling

[Rejin Chandran]

Hi All,

 

Please share your understanding about connection pooling. If some one is telling you to create a connection pooling mechanism using Java how you will create.  For storing connection objects widely hash tables are being used why?.

 

Some points that i know is elicited here

 

In an application taking database connection is a time consuming thing. The time takes for creating a connection is depnds on different factors like configuration, usage, network performance etc. In that case a separate mechanisam is provided which maintains the connection object in a pool. When we are saying maintaining conn object has different meaning. From your application you are closing the connection and at the same time a connection is created and pushed in to the pool.

 

 

 

Thanks and Regards

Rejin Chandran R