PostgreSQL Database Configuration
With the release of TIBCO Fulfillment Order Management 4.0, OCS now supports a PostgreSQL database instead of only an Oracle database. PostgreSQL is a powerful, open source object-relational database system which has support in Hibernate which is used by OCS to talk to the database. These configuration values have been updated to support switching from an Oracle database to a PostgreSQL database.
The following values can be configured in TIBCO FOM Configurator or in the ConfigValues_OCS.xml file.
| Name | Description |
|---|---|
| com.tibco.af.ocs.pooledDataSource.driverClassName | The pooled data source driver name. To switch from Oracle to PostgreSQL, move
selected=true from the Oracle line to the Postgres line:
<EnumValue value="org.postgresql.Driver"/> |
| com.tibco.af.ocs.pooledDataSource.host | The host name for the Postgres database. |
| com.tibco.af.ocs.pooledDataSource.port | The port number for the Postgres database. |
| com.tibco.af.ocs.pooledDataSource.database | The pooled data source database.
The value for this is the name of the database you create in postgres. To create a database, see Creating PostgreSQL Tables.The default database name in postgres is postgres. |
| com.tibco.af.ocs.pooledDataSource.username | The pooled data source database user name. |
| com.tibco.af.ocs.pooledDataSource.password | The pooled data source database password. |
| com.tibco.af.ocs.pooledDataSource.postgres.schema | This is a Postgres specific property that indicates the schema name. The default schema for Postgres is public. |
| com.tibco.af.ocs.pooledDataSource.url | The pooled data source URL. To switch from Oracle to PostgreSQL, move
selected=true from the Oracle line to the Postgres line:
<EnumValue value="jdbc:postgresql://${com.tibco.af.ocs.pooledDataSource.host}:${com.tibco.af.ocs.pooledDataSource.port}/${com.tibco.af.ocs.pooledDataSource.database}?currentSchema=${com.tibco.af.ocs.pooledDataSource.postgres.schema}"/> |
| com.tibco.af.ocs.pooledDataSource.validationQuery | The pooled data source validation query. To switch from Oracle to PostgreSQL, move
selected=true from the Oracle line to the Postgres line:
<EnumValue value="SELECT 1"/> |
| com.tibco.af.ocs.hibernate.dialect | Hibernate dialect. To switch from an Oracle database to a PostgreSQL database, move selected="true" from the Oracle line to the PostgreSQL line. |