What is OfBiz
http://www.axzm.com/faq/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:
http://www.apache.org/dyn/closer.cgi/ofbiz/apache-ofbiz-12.04.05.zip
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 http://127.0.0.1:8080/ecommerce/control/main
- https://localhost:8443/webtools/control/main or https://127.0.0.1:8443/webtools/control/main
- https://localhost:8443/catalog/control/main or https://127.0.0.1:8443/catalog/control/main
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
https://cwiki.apache.org/confluence/display/OFBIZ/How+to+migrate+OfBiz+from+Derby+to+MySQL+database
Apache Derby supported data types:
http://db.apache.org/derby/docs/10.8/ref/crefsqlj31068.html
note: OfBiz came with embedded Derby.