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>
1 Comment
Sharan Foga
This page is now linked to the Technical Production Setup Guide so please try to keep this information up to date. Thanks