Dashboard > The Open For Business Project Wiki > ... > Misc Pages - Technical > Connecting OFBiz to PostGIS spatially-enabled database
  The Open For Business Project Wiki Log In | Sign Up   View a printable version of the current page.  
  Connecting OFBiz to PostGIS spatially-enabled database
 Browse Space
Added by Chris Howe, last edited by Jacques Le Roux on Aug 10, 2008  (view change)
Labels: 
(None)

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>
Site powered by a free Open Source Project / Non-profit License (more) of Confluence - the Enterprise wiki.
Learn more or evaluate Confluence for your organisation.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.2.10 Build:#528 Nov 29, 2006) - Bug/feature request - Contact Administrators

Hosting and maintenance for this site brought to you by:

With both OFBiz project creators on our executive team, and by leading teams comprised of many of the most talented OFBiz developers anywhere, HotWax Media is uniquely positioned to help our clients succeed with Open For Business. From large multinational public companies to a variety of smaller businesses, we expertly support our clients as they harness the world-class systems in OFBiz.

Contegix keeps your servers running all day, every day. Intelligent Routing, secure power supplies, and a 100% uptime guarantee give you peace of mind for your complete managed hosting solution. More than hosting. More than application support. Our engineers support your business.