Configuring OfBiz To Use A MySQL Database

OfBiz can easily be configured to use a variety of external database sources through fairly simple configuration changes. The entityengine.xml file will have to be edited and the appropriate JDBC connector will have to be installed.

Installing the JDBC Connector

For OfBiz to be able to connect to the database an appropriate JDBC connector must be installed into {ofbiz}/framework/entity/lib/jdbc/. JDBC connectors are usually provided by the database provider.

Install the mysql-java-connector

First download the connector from http://dev.mysql.com/downloads/connector/j/ and uncompress the archive. Then copy mysql-connector-java-X.X.X-bin.jar to {ofbiz}/framework/entity/lib/jdbc/.

Configuring OfBiz

Edit {ofbiz}/framework/entity/config/entityengine.xml.

Example MySQL datasource statement:

Next create the ofbiz declared in the datasource statements.

go to home folder

cd {ofbiz}

run command: ant run install


base seed data will be installed on success.

Let us start

First download source code from link below(new version).

Source Code : Download Apache OFBiz™

Once download completes , just extract zip to some folder.

What is Apache OFBiz?

Apache OFBiz (The Apache Open For Business Project) is an open source enterprise automation software project licensed under the Apache License Version 2.0. By open source enterprise automation we mean: Open Source ERP (Enterprise Resource Planning), Open Source CRM (Customer RelationShip Management), Open Source E-Business / E-Commerce, Open Source SCM (Supply Chain Management), Open Source MRP (Manufacturing Resources Planning), Open Source CMMS/EAM (Maintenance Management System/Enterprise Asset Management), Open Source POS (Point Of Sale), and so on.