(2024.2 2) Database Connection Parameters
- Jeremiah Sokolowski
Analytics
There are two database connections used for PCR-360, default and metadata. These two connections can be pointed at different databases or they can use the same database and schema. The following are examples of MySQL and Oracle versions of these connections.
MySQL Default Connection
resources.multidb.default.adapter = Pdo_Mysql
resources.multidb.default.host = mysql5.pcr.com
resources.multidb.default.username = dev360
resources.multidb.default.password = thisisapassword
MySQL Metadata Connection
resources.multidb.metadata.adapter = Pdo_Mysql
resources.multidb.metadata.host = mysql5.pcr.com
resources.multidb.metadata.username = dev360
resources.multidb.metadata.password = thisisapassword
Oracle Default Connection
resources.multidb.default.adapter = Oracle
resources.multidb.default.host = oracle.pcr.com
resources.multidb.default.username = pcr360
resources.multidb.default.password = thisisapassword
resources.multidb.default.schema = PCR360
resources.multidb.default.dbname = "//oracle.pcr.com:1521/pcr"
resources.multidb.default.caseInsensitive = true
Oracle Metadata Connection
resources.multidb.metadata.adapter = Oracle
resources.multidb.metadata.host = oracle.pcr.com
resources.multidb.metadata.username = pcr360meta
resources.multidb.metadata.password = thisisapassword
resources.multidb.metadata.schema = PCR360META
resources.multidb.metadata.dbname = "//oracle.pcr.com:1521/pcr"
resources.multidb.metadata.caseInsensitive = true