Add CRDB pool details

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