Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Datasource and connection pooling

 
Frank Sikuluzu
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Scott Dunbar
Ranch Hand
Posts: 245
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic