Sessions are Reconnected After 10 Minutes

book

Article ID: 103815

calendar_today

Updated On:

Products

STARTER PACK-7 CA Rapid App Security CA API Gateway

Issue/Introduction

According the following documentation, sessions should remain active indefinitely (maxIdleTime = 0 and maxConnectionAge = 0) and they should test connectivity every 10 minutes with the following request "select 1 from dual" (preferredTestQuery) to check if BD is alive. 

Currently, we see that all the sessions are reconnected in 10 minutes (600 seconds). 

We also checked the link : https://docops.ca.com/ca-api-gateway/9-3/en/reference/troubleshoot#Troubleshoot-Problem:JDBCconnectionfailures 
And this link : https://docops.ca.com/ca-api-gateway/9-3/en/security-configuration-in-policy-manager/tasks-menu-security-options/manage-jdbc-connections/jdbc-connection-properties. 

Environment

Release: L7SGA299000-9.2-API Gateway SOA Gateway-HARDWARE APPLIANCE DUAL CPU
Component:

Resolution

We normally recommend that our customers set their JDBC connection configurations to look like the following:

<Please see attached file for image>

User-added image

NOTE: For each thread in the pool size, the Gateway will use 8MB of RAM to hold this connection - so for the example 8X15=120MB 

Attachments

1558699125991000103815_sktwi1f5rjvs16jm6.jpeg get_app