Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

User_9ET42Jan 13 2023

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,

Comments

The best advice I can give is to upgrade PHP, either to the free Zend Server edition or to a stock PHP distribution (http://www.oracle.com/technetwork/articles/technote-php-instant-084410.html).

Other than that, try to identify how the crash is triggered and see if you can work around it.

Since this is a Zend Core issue you could contact Zend, but I expect they will also want you to upgrade.
1 - 1

Post Details

Added on Jan 13 2023
#java-database-connectivity-jdbc, #jdbc, #network
2 comments
15,075 views