which connection parameter hybris supports and which connection pool hybris use

[Former Member]

We are using Oracle db . We want to use below connection param. Can we use it in local.properties or we need to do any special configuration for that. Could you please exaplin which connection pool hybris use and how the below connection param can be supported by it.

db.connectionparam.oracle.jdbc.ReadTimeout=60000

[former_member760554]

Addition to answer of Anton Gavazyuk.

In Hybris, below method is responsible to create the actual data source object using the configured properties. There it reads all the customParams which are mentioned in specific pattern ["db.connectionparam\\.(.*)"]

de.hybris.platform.core.AbstractTenant.HybrisDataSourceBuilder#createMasterDataSource

You can try this 
db.connectionparam.oracle.jdbc.ReadTimeout=50000
db.connectionparam.oracle.net.CONNECT_TIMEOUT=50000

[former_member537989]

We want to use below connection param. Can we use it in local.properties or we need to do any special configuration for that.

yes, the configuration file is correct place to specify the db.connectionparam.* properties

Could you please exaplin which connection pool hybris use

Apache Commons pool

how the below connection param can be supported by it

the existing logic responsible for creating connections will propagate the db.connectionparam.{property name} key and value as parameter (without db.connectionparam prefix) towards a driver connection creation method.