About Manage JDBC Connections

book

Article ID: 195025

calendar_today

Updated On:

Products

CA API Gateway API SECURITY CA API Gateway Precision API Monitoring Module for API Gateway (Layer 7) CA API Gateway Enterprise Service Manager (Layer 7) STARTER PACK-7 CA Microgateway

Issue/Introduction

There are two Gateway nodes in a cluster environment.
Configured Manage JDBC Connections: 
  Minimum Pool Size:  15
        Maximum Pool Size:  15
        idleConnectionTestPeriod : 600

Result:
Node1 has 15 connections.
Node2 had no connected.

So, click the Test button on the JDBC Connection Properties screen on node2
Node2 had 3 connections.
odd.

How can  connect to Node 2 up to the number of Minimum Pool Size?

Environment

Component : API GATEWAY

Resolution

Setting the JDBC connection does not mean that the connection will start immediately.
As for the actual connection, when the assertion using JDBC connection is used, the number of connections equal to the value of Minimum Pool Size is set.

It seems the corresponding assertion is still being used only from Node1 
If the corresponding assertion is used on Unit 2, the connection from Node2 will be established.

Also, If executed the Test button on the JDBC Connection Properties screen, 3 connections will be created regardless of the value of Minimum Pool Size.