How to change c3p0DataSource.maxPoolSize parameter in container gateway image

Products

• CA API Gateway

Issue/Introduction

We are trying to upgrade container gateway from v9.4 to v10.1. For higher performance, we want to set c3p0DataSource.maxPoolSize parameter from its default value to 4500. How can we add this parameter to the container gateway 10.1 image?

 

 

 

Environment

Release : 10.1

Resolution

The 10.1 container gateway is not reading the node.properties file so the suggestion to use derived image is not accurate anymore and we will correct this in the docs.

You can set this in the values file under the system properties section 

https://github.com/CAAPIM/apim-charts/tree/0d677b0aaf7c3f8831f22fea8680911ae1853643/charts/gateway#system-properties

  com.l7tech.server.clusterStaleNodeCleanupTimeoutSeconds=86400    # Additional properties go here

After this you can add for example 

c3p0.maxPoolSize=2150  
c3p0.DataSource.minPoolSize=48

You have to restart the gateway pod to apply the setting as it is only set on boot