This Confluence has been LDAP enabled, if you are an ASF Committer, please use your LDAP Credentials to login. Any problems file an INFRA jira ticket please.

Child pages
  • Connecting OFBiz to PostGIS spatially-enabled database

Access to add and change pages is restricted. See: https://cwiki.apache.org/confluence/display/OFBIZ/Wiki+access

Skip to end of metadata
Go to start of metadata

Tables of content

External Files
entityengine.xml
fieldtypepostgresql.xml



Files

PostGIS JDBC - place in framework/entity/lib/jdbc/

framework/entity/config/entityengine.xml

Find the localpostgres inline-jdbc element:

 <inline-jdbc
                jdbc-driver="org.postgresql.Driver"
                jdbc-uri="jdbc:postgresql://127.0.0.1/ofbiz"
                jdbc-username="ofbiz"
                jdbc-password="ofbiz"
                isolation-level="ReadCommitted"
                pool-minsize="2"
                pool-maxsize="250"/>


 And change it to read:

 <inline-jdbc
                jdbc-driver="org.postgis.DriverWrapper"
                jdbc-uri="jdbc:postgresql_postGIS://127.0.0.1/ofbiz"
                jdbc-username="ofbiz"
                jdbc-password="ofbiz"
                isolation-level="ReadCommitted"
                pool-minsize="2"
                pool-maxsize="250"/>


 

framework/entity/fieldtype/fieldtypepostgres.xml

Add a definition for the geometry type (and any other types you may need to accomodate your likely imported dataset)

    <field-type-def type="geometry" sql-type="geometry" java-type="geometry"></field-type-def>




  • No labels

1 Comment

  1. This page is now linked to the Technical Production Setup Guide so please try to keep this information up to date. Thanks