(2024.2) Database Connection Parameters

1 MySQL Default Connection
2 MySQL Metadata Connection
3 Oracle Default Connection
4 Oracle Metadata Connection

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