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:
|
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
|
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:
|
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:
|
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.
|