postgresql - Orbeon Forms Postgres DB connection

Question

I have tried to save the Orbeon forms in Postgres DB. I created data bases persistence layer but still forms are stored in the default eXist DB. I have created context(Data Base source) in the "Server.xml" from the tomcat7 and I have created "properties-local.xml" file in the Orbeon4.8 (orbeon/src/resources/config/properties-local.xml). My reference is this.

Some one help me how to save the orbeon forms in Postgres DB?

Answer 1

Once the database resource is configured, you can tell Orbeon to use it by adding a like like this to your properties-local.xml:

<property as="xs:string"  name="oxf.fr.persistence.provider.*.*.*" value="postgresql"/>

You can see the default configuration for the resource names Orbeon accepts out of the box in properties-form-runner.xml.

Exist will still be used for the example forms. But you can disable it with:

<property as="xs:boolean" name="oxf.fr.persistence.exist.active" value="false"/>

If you need to define a resource with a name other than the default names (e.g. postgresql), you will need to provide more information as shown below (remember to replace all occurances of pg_other_name with your resource name).

<property as="xs:string"  name="oxf.fr.persistence.provider.*.*.*" value="pg_other_name"/>
<property as="xs:anyURI"  name="oxf.fr.persistence.pg_other_name.uri" value="/fr/service/postgresql"/>
<property as="xs:string"  name="oxf.fr.persistence.pg_other_name.datasource" value="pg_other_name"/>
<property as="xs:boolean" name="oxf.fr.persistence.pg_other_name.create-flat-view" value="true"/>
<property as="xs:boolean" name="oxf.fr.persistence.pg_other_name.autosave" value="true"/>
<property as="xs:boolean" name="oxf.fr.persistence.pg_other_name.permissions" value="true"/>
<property as="xs:boolean" name="oxf.fr.persistence.pg_other_name.versioning" value="true"/>