Robert Lor's Weblog

OFBiz and PostgreSQL

There are a quite number of Open Source ERP apps out there, but only a few (Compiere/Adempiere, OpenBravo, xTuple, OFBiz) seem to have gained traction. Recently, I tried out OFBiz and getting it to work with PostgreSQL was quite simple. OFBiz is actually shipped with an embedded Java DB (Derby), so for testing or development, you probably don't need an external DB.

I did my test on OpenSolaris 2008.05, so if you use a different version of Solaris or a different OS, the instructions below may vary.

First, check out the source, compile, and run with the embedded database to make sure everything works properly.

1. Create a directory where you want OFBiz to reside, and run "svn co http://svn.apache.org/repos/asf/ofbiz/trunk ofbiz"
2. Go to the OFBiz directory (now referred to as $OFBIZDIR), and run "./ant run-install"
3. In $OFBIZDIR, run "java -jar ofbiz.jar"
4. Once OFBiz is started, check out the sample app by pointing the browser to http://localhost:8080/ecommerce/

Once your have it working with Derby, follow the steps below to switch to PostgreSQL. I use version 8.3.x.

1. Assuming you have Postgres installed and ready to go, run:
   
   postgres $ createuser -S -D -R -P -E ofbiz
postgres $ createdb -O ofbiz ofbizdb



2. Edit the OFBiz DB config file in $OFBIZDIR/framework/entity/config/entityengine.xml
   
   <delegator name="default" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="localpostnew"/>
...
</delegator>

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



3. Copy PostgreSQL JDBC driver to $OFBIZDIR/framework/entity/lib/jdbc. Make sure to use the JDBC4 driver.
4. Go to $OFBIZDIR, and run "./ant run-install" to populate the data in PostgreSQL
5. Re/start OFBiz by running "java -jar ofbiz.jar"
6. Once OFBiz is up and running, you should be able to access http://localhost:8080/ecommerce/

That's all there is to it.

Jignesh has a post on setting up OpenBravo with Postgres on OpenSolaris 2008.05.

Posted at 05:15PM Oct 31, 2008 by Robert Lor in PostgreSQL  |  Comments[2]