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.