Add below CRDB pool details to customer_overrides.properties
#CRDB property files
customer_jdbcService.crdbPool.driver=org.postgresql.Driver
customer_jdbcService.crdbPool.url=jdbc:postgresql://<CRDB_HOST>:26257/amf?sslmode=disable
customer_jdbcService.crdbPool.user=<user for accessing ccrdb>
customer_jdbcService.crdbPool.password=
customer_jdbcService.crdbPool.catalog=amf
customer_jdbcService.crdbPool.type=local
customer_jdbcService.crdbPool.testOnReserve=true
customer_jdbcService.crdbPool.testOnReserveQuery=select 1
customer_jdbcService.crdbPool.dbvendor=PostgreSQl
customer_jdbcService.crdbPool.buffersize=500
customer_jdbcService.crdbPool.maxsize=100
customer_jdbcService.crdbPool.initsize=1
customer_jdbcService.crdbPool.behaviour=2
customer_jdbcService.crdbPool.waittime=1000
customer_jdbcService.crdbPool.storedProcClassName=com.sterlingcommerce.woodstock.util.frame.jdbc.SybaseStoredProcQuery
customer_jdbcService.crdbPool.varDataClassName=com.sterlingcommerce.woodstock.util.frame.jdbc.JConnectVarData
customer_jdbcService.crdbPool.factory=com.sterlingcommerce.woodstock.util.frame.jdbc.ConnectionFactory
Note: Restart of SFG is required to make the above changes effective
Last updated