Page History

These steps have been successfully tested with Tomcat but may require additional testing. This text and configuration are a draft version, the community should take this space over and feel free to improve it with additional documentation and corrections.

Generate postgres scripts

With the current version of the liquibase plugin we can only generate with an active database (postgresql:offline doesn't work).

Steps required:

1. Upgrade to the latest version of Liquibase required
2. Manually changed binary_data from BYTEA to BIGINT.
3. Manually changed the _ID_PK and _KEY column names.
4. Update postgresql.conf: uncomment max_prepared_transactions and set it to a value > 0. Changing max_prepared_transactions requires a server restart.

domibus-datasource.xml

Apply these changes

<property name="xaDataSourceClassName">
<value>org.postgresql.xa.PGXADataSource</value>
</property>
<property name="xaProperties">
<props>
<prop key="serverName">localhost</prop>
<prop key="portNumber">5432</prop>
<prop key="user">postgres</prop>
<prop key="password">postgres</prop>
<prop key="databaseName">domibus_dev_c3</prop>
</props>
</property>

<property name="databasePlatform"
value="org.hibernate.dialect.PostgreSQLDialect"/>

msh-config.xml

Change the driver:

<prop key="org.quartz.jobStore.driverDelegateClass">
org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
</prop>

Below In this page it is possible for the community members to upload documentation, patches or binary files that are deemed pertinent to assist the community using this particular DB.