Versions Compared

Old Version 7

changes.mady.by.user Jacques Le Roux

Saved on

compared with

New Version Current

changes.mady.by.user Jacques Le Roux

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

Tables of content

External Files
entityengine.xml
fieldtypepostgresql.xml



Anchor
Files
Files

Files

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

Anchor
Datasource
Datasource

framework/entity/config/entityengine.xml

Find the localpostgres inline-jdbc element:

Code Block
 <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:

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


 

Anchor
FieldType
FieldType

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)

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