Connection pool InactiveconnectionTimeout value

[MadanMohan Bolla]

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]

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]

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]

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]

Thanks Shikhar.

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

Thanks in advance.