wood burning stoves 2.0*
The moose likes BEA/Weblogic and the fly likes Connection pool InactiveconnectionTimeout value Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "Connection pool InactiveconnectionTimeout value" Watch "Connection pool InactiveconnectionTimeout value" New topic

Connection pool InactiveconnectionTimeout value

MadanMohan Bolla

Joined: Nov 02, 2007
Posts: 19
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

Joined: Jan 06, 2001
Posts: 977
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.

MadanMohan Bolla

Joined: Nov 02, 2007
Posts: 19
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

Joined: Dec 18, 2006
Posts: 95
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.


He who asks a question is a fool for five minutes; he who does not ask a question remains a fool forever - Chinese proverb
MadanMohan Bolla

Joined: Nov 02, 2007
Posts: 19
Thanks Shikhar.

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

Thanks in advance.
I agree. Here's the link: http://aspose.com/file-tools
subject: Connection pool InactiveconnectionTimeout value
Similar Threads
How to resolve the "All threads (500) are currently busy" issue in Tomcat.
String objects
connection pooling in struts
When to close connection?
Weblogic 8.1: Configure a new JDBC Connection Pool