File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes BEA/Weblogic and the fly likes Datasource and connection pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "Datasource and connection pooling" Watch "Datasource and connection pooling" New topic

Datasource and connection pooling

Frank Sikuluzu
Ranch Hand

Joined: Dec 16, 2003
Posts: 116
I'm new to weblogic server. If I create a datasource and specify that I want to use connection pooling, and I set initially there are 30 connections. When users finish using these 30 connections they will be returned to the pool. Now, after that, what if NO user ever requests for any connection for a long time, how does the Weblogic server handle this situation ? will it always keep those 30 connections open in the pool ?
Deepak Dew
Ranch Hand

Joined: Mar 29, 2004
Posts: 79
I am not very sure about it but it depends how have you configured your connection pool.
It has parameters like maxm connections, min connections so it can increase/decrease on the demand.

Hope this helps

IBM Certified Advance WAS Administrator on 6.1, BEA Certified WebLogic Server 81 Administrator, Vitria Certified BusinessWorks Administrator, SCJP 2
Scott Dunbar
Ranch Hand

Joined: Sep 23, 2004
Posts: 245
Connection pools have an option to allow shrinking. You can set the "Shrink Period" to be when you want the pool to shrink. In 8.1 this is under the "Advanced Options" in the console.

<a href="" target="_blank" rel="nofollow">Java forums using Java software</a> - Come and help get them started.
I agree. Here's the link:
subject: Datasource and connection pooling
It's not a secret anymore!