How to configure a TCP Keep-alive in JDBC connection string

User_9ET42

Hello,

I am using a JDBC connection string to connect to an oracle database, I am having idle connections because the response time is greater than 350 seg. therefore I am trying to add in the JDBC connection new network parameters but in my test identified that I have not sent a keep-alive packed I have doubts about the configuration, Could you help me with an example ?

My JDBC connection:

jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.4.50)(PORT=1522)))(CONNECT_DATA=(SERVICE_NAME=GTRPRSVCOS)))

New parameters:

ENABLE=BROKEN, SO_KEEPALIVE, TCP_KEEPIDLE, TCP_KEEPINTVL, TCP_KEEPCNT

jdbc:oracle:thin:@(DESCRIPTION=(FAILOVER=on)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.4.50)(PORT=1522)))(CONNECT_DATA=(SERVICE_NAME=GTRPRSVCOS))(ENABLE=BROKEN)(SO_KEEPALIVE=true)(TCP_KEEPIDLE=60)(TCP_KEEPINTVL=30)(TCP_KEEPCNT=15)) 

I appreciate your help,

Nirmala Sundarappa-Oracle

Can you check out the KEEPALIVE connection parameters and their definitions and use the ones that are suitable for your requirement? Please look under 'Network Connection Properties' under OracleConnection.html

oracle.net.keepAlive Enables TCP keep alive

oracle.net.TCP_KEEPIDLE Specifies the amount of time for a connection to remain idle before sending keep alive probes

oracle.net.TCP_KEEPINTERVAL Specifies the frequency at which keep alive probes are retransmitted oracle.net.TCP_KEEPCOUNT Specifies the maximum number of keep alive probes to send before terminating the connection