Apache OfBiz

What is OfBiz


Download and Install OfBiz

Following steps in https://cwiki.apache.org/confluence/display/OFBIZ/Demo+and+Test+Setup+Guide

Install Java JDK.  Check appropriate version with the version of OfBiz you are downloading.  Don’t forget to reset %JAVA_HOME% to point to the latest version you installed.

Go to the Apache OfBiz page, click on the first link under “other downloads”.  Click on the first link to the zip file. Very counterintuitive.  They should just have a large button marked “download the latest version!”.  Here’s the link I used:


After download and extraction, run ant load-demo in command prompt in the install directory. (The download includes Apache ant under the framework directory.  There is an ant batch file in the install directory.  In my case: c:\apache-ofbiz-12.04.05\apache-ofbiz-12.04.05).  This step will take about 20-40 minutes. The build will, among other things, generate Java byte code from the source code and set up Derby, the embedded database used by OfBiz.  (I didn’t find any .class files in the initial download, just xml and .java files).

Start embedded tomcat by issuing ant start command.

If you are running XAMPP, you can check in the XAMPP manager page (browser http:\\locahost, click on status) to see that tomcat service is running.

Access OfBiz via browser at:

  • http://localhost:8080/ecommerce/control/main or
  • https://localhost:8443/webtools/control/main or
  • https://localhost:8443/catalog/control/main or

Note:  I am getting security error accessing https.  I’m in the process of clearing this up.

Note:  I reinstalled a newer version of XAMPP.  OfBiz stopped working.  Tomcat will not start.  I cannot find any error messages in the logs.  I reinstalled OfBiz and reload the demo data.  Now it is up and running.


Start OfBiz by Command Prompt

Use ${OfBiz install directory}/tools/startofbiz.bat to start Ofbiz on Windows.  The output of the batch file can be redirected to the console log file for debugging purposes.

In startofbiz.bat add > runtime\logs\console.log to the line “%JAVA_HOME%\bin\java” -Xms128M -Xmx512M -XX:MaxPermSize=512m -jar ofbiz.jar

How to migrate from Derby to MYSQL



Apache Derby supported data types:


note:  OfBiz came with embedded Derby.