PostgreSQL Database Configuration

With the release of TIBCO Order Management 5.0, the Order Capture System 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 the Order Capture System 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 the 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 PostgreSQL line:

<EnumValue value="org.postgresql.Driver"/>

com.tibco.af.ocs.pooledDataSource.host The hostname for the PostgreSQL database.
com.tibco.af.ocs.pooledDataSource.port The port number for the PostgreSQL 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 PostgreSQL. To create a database, see Creating PostgreSQL Tables. The default database name in PostgreSQL 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 PostgreSQL specific property that indicates the schema name. The default schema for PostgreSQL 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 PostgreSQL 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 PostgreSQL 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.