Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Understanding count of minimum idle connections to zero in connection pool

26111982Apr 25 2013 — edited Oct 15 2014
Hi,

I would like to understand if there is any overhead of creating connections if we keep the minIdle to zero in a connection pool where the eviction thread is configured.

As per the understanding I have, it's the initial creation of connection to the database is expensive operation.In the case of connection pool,this is being done when the data source is instantiated initially and the connection objects are maintained till the data source is destroyed.

Please help me understand the behavior when the minIdle is made 0. Will it try to create a new connection when all the connections are evicted and cause an overhead than making minIdle >0.

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 23 2013
Added on Apr 25 2013
3 comments
1,679 views