Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection pool InactiveconnectionTimeout value

 
MadanMohan Bolla
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Based on which condition we need to specify connectio pool InactiveConnectionTimeout parameter value. We are using oracle database.
what is the dependency of the Database on setting this value.

Thanks in advance.
 
Marcos Maia
Ranch Hand
Posts: 977
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
From admin console help:

The number of inactive seconds on a reserved connection before WebLogic Server reclaims the connection and releases it back into the connection pool.

You can use the Inactive Connection Timeout feature to reclaim leaked connections - connections that were not explicitly closed by the application. Note that this feature is not intended to be used in place of properly closing connections.


So I believe it's self explanatory, let us know if you need some more light on this.

regards
 
MadanMohan Bolla
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think this is the way to follow while setting connection timeout value.


Application level connection timeout should be less than weblogic level connection timeout should be less than Database level connection timeout.

Correct me if i am wrong.
 
Shikhar Madhok
Ranch Hand
Posts: 95
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Generally (or possibly I should say the applications I have worked on), a connection is obtained from a connection pool created on the weblogic server. So it would not be necessary to handle the database connection timeout in your application. Let weblogic handle the connection timeout and make sure that you handle a timeout scenario in our application gracefully.
You are right about the second part, your weblogic connection time out should be lesser than your database connection timeout.

HTH
Shikhar
 
MadanMohan Bolla
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Shikhar.

Do any one know what will be the default connection timeout value for oracle 10g ?

Thanks in advance.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic