JDBC connections to API Gateway "ssg" database
search cancel

JDBC connections to API Gateway "ssg" database

book

Article ID: 139678

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

The JDBC configuration for OTK can be managed with the "Manage JDBC Connections" task in the Policy Manager, but the task cannot manage the number of connections the API Gateway to load and save policies and settings.
Are the Cluster-wide properties "jdbcConnection.pooling.maxPoolSize.defaultValue" and "jdbcConnection.pooling.minPoolSize.defaultValue" effective for the latter connections?

JDBC Cluster properties:
 https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-api-management/api-gateway/9-3/reference/gateway-cluster-properties/jdbc-cluster-properties.html

Environment

Release : 9.4

Component : API GATEWAY

Resolution

Cluster-wide properties such as jdbcConnection.pooling.maxPoolSize.defaultValue aren't applied to the Gateway database (default name: ssg) connections because they are stored in the Gateway database for sharing among the Gateway nodes in the Cluster.
They aren't available when the Gateway is starting up.