Orbeon Forms Postgres DB connection

by

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"/>

More Related Contents:

  1. Insert, on duplicate update in PostgreSQL?
  2. How does the search_path influence identifier resolution and the “current schema”
  3. How do you find the row count for all your tables in Postgres
  4. Run batch file with psql command without password
  5. invalid byte sequence for encoding “UTF8”
  6. Postgresql: Conditionally unique constraint
  7. How do you use variables in a simple PostgreSQL script?
  8. Rownum in postgresql
  9. How to switch databases in psql?
  10. Postgresql: Scripting psql execution with password
  11. dynamic sql query in postgres
  12. Is there a timeout for idle PostgreSQL connections?
  13. Postgresql Truncation speed
  14. Buffers (Circle) in PostGIS
  15. docker postgres pgadmin local connection
  16. How to customize the configuration file of the official PostgreSQL Docker image?
  17. Does a Postgres UNIQUE constraint imply an index?
  18. SELECT raises exception in PL/pgSQL function
  19. Dynamically generate columns for crosstab in PostgreSQL
  20. PSQLException: current transaction is aborted, commands ignored until end of transaction block
  21. Postgresql insert trigger to set value
  22. postgres autoincrement not updated on explicit id inserts
  23. Retrieving Comments from a PostgreSQL DB
  24. Docker – How can run the psql command in the postgres container?
  25. Postgis installation: type “geometry” does not exist
  26. How do I change a Crystal Report’s ODBC database connection at runtime?
  27. Postgres default sort by id – worldship
  28. Best way to install hstore on multiple schemas in a Postgres database?
  29. Loop through columns of RECORD
  30. How to drop PostgreSQL database through command line [closed]

Leave a Comment