What is the benifit for enabling oracle.net.keepAlive

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

What is the benifit for enabling oracle.net.keepAlive

Vinni
Hi,

First i want to congratulate you on starting a forum like this and i am glad to be associated with the same.

My question is when and why one should enable the below property within weblogic connection pool:

oracle.net.keepAlive=true


-Vinni
-Vinni
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: What is the benifit for enabling oracle.net.keepAlive

phcharbonneau
Administrator
This post was updated on .
Thanks Vinni,

Are you referring to the Oracle keepAlive for the JDBC thin driver? This is typically related to TCP IP keepAlive at the JDBC driver level.

Typically this is used for thin driver to keep the Socket alive and prevent closure from Oracle side.
You usually don't need to setup this property for type 4 JDBC driver as Java EE containers typically have built-in refresh and "test Connection on reserve" mechanisms which will ensure a JDBC Connection (from the pool) is healthy before using it for your application transaction.

Regards,
P-H
http://javaeesupportpatterns.blogspot.com
Loading...