Skip to Content
0
Aug 09, 2023 at 11:29 PM

SAP CAP Java - SAP Hana Cloud Connection Pool

256 Views Last edit Aug 10, 2023 at 10:24 AM 2 rev

Hi Team,

Just wanted to clarify the default settings connection pool for CAP JAVA using SAP Cloud Hana DB.

I understand the following. Please correct me if i am wrong

  1. Uses Hikari Connection Pool.
  2. Defaults to 10??

We would also like to know how you change this default. I found this in a blog. This is implemented in the application.yaml

spring:
config.activate.on-profile: cloud
datasource:
    hikari: 
       maximum-pool-size: 20 

But in the CAPIRE documentation the example is this

cds:<br>  dataSource:<br>    my-service-instance:<br>      hikari:<br>        maximum-pool-size: 20

Which on is the correct configuration??

Also the dataSource in the documentation has "S" in uppercase, not sure if this has any effect.

what value to we put in the "my-service-instance"???

Also, how do we check the changes have been applied??? is there any way we can see this??

Appreciate your help with this.

Cheers

D