Database Configuration Properties

The following OMS and OCS database properties are the database configurations specifically for an Oracle and a PostgreSQL database.

OMS Admin Data Source Configuration Properties
Property Name Oracle Database Property Value PostgreSQL Database Property Value
Pooled Data Source Driver Class Name oracle.jdbc.driver.OracleDriver org.postgresql.Driver
Pooled Data Source Port 1521 (default) 5432 (default)
Pooled Data Source Database orcl (default) admindb (default)
Pooled Data Source Username aff_admin (default) adminuser (default)
Pooled Data Source Schema N/A adminschema (default)
Pooled Data Source URL jdbc:oracle:thin:@//${com.tibco.af.oms.pooledDataSource.host}:${com.tibco.af.oms.pooledDataSource.port}/${com.tibco.af.oms.pooledDataSource.database} jdbc:postgresql://${com.tibco.af.oms.pooledDataSource.host}:${com.tibco.af.oms.pooledDataSource.port}/${com.tibco.af.oms.pooledDataSource.database}?currentSchema=${com.tibco.af.oms.pooledDataSource.postgres.schema}
Pooled Data Source Validation Query select 1 from dual SELECT 1
Pooled Database Connection Property oracle.jdbc.ReadTimeout=120000 N/A
OMS Default Tenant Data Source Configuration Properties
Property Name Oracle Database Property Value PostgreSQL Database Property Value
Pooled Data Source Driver Class Name oracle.jdbc.driver.OracleDriver org.postgresql.Driver
Pooled Data Source Port 1521 (default) 5432 (default)
Pooled Data Source Database orcl (default) fomdb (default)
Pooled Data Source Username aff_oms (default) fomuser (default)
Pooled Data Source Schema N/A fomschema (default)
Pooled Data Source URL jdbc:oracle:thin:@//${com.tibco.af.oms.pooledDataSource.host}:${com.tibco.af.oms.pooledDataSource.port}/${com.tibco.af.oms.pooledDataSource.database} jdbc:postgresql://${com.tibco.af.oms.pooledDataSource.host}:${com.tibco.af.oms.pooledDataSource.port}/${com.tibco.af.oms.pooledDataSource.database}?currentSchema=${com.tibco.af.oms.pooledDataSource.postgres.schema}
Pooled Data Source Validation Query select 1 from dual SELECT 1
Pooled Database Connection Property oracle.jdbc.ReadTimeout=120000 N/A
OMS Archive Data Source Configuration Properties
Property Name Oracle Database Property Value PostgreSQL Database Property Value
Pooled Data Source Driver Class Name oracle.jdbc.driver.OracleDriver org.postgresql.Driver
Pooled Data Source Port 1521 (default) 5432 (default)
Pooled Data Source URL jdbc:oracle:thin:@//${com.tibco.af.oms.pooledDataSource.host}:${com.tibco.af.oms.pooledDataSource.port}/${com.tibco.af.oms.pooledDataSource.database} jdbc:postgresql://${com.tibco.af.oms.pooledDataSource.host}:${com.tibco.af.oms.pooledDataSource.port}/${com.tibco.af.oms.pooledDataSource.database}?currentSchema=${com.tibco.af.oms.pooledDataSource.postgres.schema}
Pooled Data Source Validation Query select 1 from dual SELECT 1
OMS Data Persistence Configuration Properties
Property Name Oracle Database Property Value PostgreSQL Database Property Value
Database Type oracle postgres
com.tibco.af.hibernate.dialect org.hibernate.dialect.Oracle10gDialect org.hibernate.dialect.PostgreSQLDialect
Pooled Data Source URL jdbc:oracle:thin:@//${com.tibco.af.oms.pooledDataSource.host}:${com.tibco.af.oms.pooledDataSource.port}/${com.tibco.af.oms.pooledDataSource.database} jdbc:postgresql://${com.tibco.af.oms.pooledDataSource.host}:${com.tibco.af.oms.pooledDataSource.port}/${com.tibco.af.oms.pooledDataSource.database}?currentSchema=${com.tibco.af.oms.pooledDataSource.postgres.schema}
Pooled Data Source Validation Query select 1 from dual SELECT 1
OCS Data Source Configuration Properties
Property Name Oracle Database Property Value PostgreSQL Database Property Value
Pooled Data Source Driver Class Name oracle.jdbc.driver.OracleDriver org.postgresql.Driver
Pooled Data Source Port 1521 (default) 5432 (default)
Pooled Data Source Database orcl (default) ocsdb (default)
Pooled Data Source Username aff_ocs (default) ocsuser (default)
Pooled Data Source Schema for postgres N/A ocsschema (default)
Pooled Data Source URL jdbc:oracle:thin:@//${com.tibco.af.oms.pooledDataSource.host}:${com.tibco.af.oms.pooledDataSource.port}/${com.tibco.af.oms.pooledDataSource.database} jdbc:postgresql://${com.tibco.af.oms.pooledDataSource.host}:${com.tibco.af.oms.pooledDataSource.port}/${com.tibco.af.oms.pooledDataSource.database}?currentSchema=${com.tibco.af.oms.pooledDataSource.postgres.schema}
Pooled Data Source Validation Query select 1 from dual SELECT 1
Hibernate dialect org.hibernate.dialect.Oracle10gDialect org.hibernate.dialect.PostgreSQLDialect
Hibernate Default Catalog aff_ocs (default) Ocsuser (default)