Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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
Author

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
deepak


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="http://forums.hotjoe.com/forums/list.page" target="_blank" rel="nofollow">Java forums using Java software</a> - Come and help get them started.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Datasource and connection pooling