OFBiz Study Notes

Latest stable version apache-ofbiz-13.07.02

Latest Source Code ofbiz-release14.12

Change the default database derby to MySQL

STEP1, build Database OFBiz, Ofbizolap, ofbiztenant in MySQL, create database user name, the password is ofbiz,ofbiz respectively.

STEP2, copy the MySQL driver package to OFBIZ_HOME\FRAMEWORK\ENTITY\LIB\JDBC.

STEP3, modify the Entityengine.xml under the Ofbiz_home\framework\entity\config,

First, find the following code in the file:

<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= "Localderby"/>
<group-map group-name= "Org.ofbiz.olap" datasource-name= "Localderbyolap"/>
<group-map group-name= "org.ofbiz.tenant" datasource-name= "Localderbytenant"/>
</delegator>
<delegator name= "Default-no-eca" entity-model-reader= "main" entity-group-reader= "main" entity-eca-reader= "main" Entity-eca-enabled= "false" distributed-cache-clear-enabled= "false" >
<group-map group-name= "org.ofbiz" datasource-name= "Localderby"/>
<group-map group-name= "Org.ofbiz.olap" datasource-name= "Localderbyolap"/>
<group-map group-name= "org.ofbiz.tenant" datasource-name= "Localderbytenant"/>
</delegator>

Put the above codeRepairSwitch
<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= "Localmysql"/>
<group-map group-name= "Org.ofbiz.olap" datasource-name= "Localmysqlolap"/>
<group-map group-name= "org.ofbiz.tenant" datasource-name= "Localmysqltenant"/>
</delegator>
<delegator name= "Default-no-eca" entity-model-reader= "main" entity-group-reader= "main" entity-eca-reader= "main" Entity-eca-enabled= "false" distributed-cache-clear-enabled= "false" >
<group-map group-name= "org.ofbiz" datasource-name= "Localmysql"/>
<group-map group-name= "Org.ofbiz.olap" datasource-name= "Localmysqlolap"/>
<group-map group-name= "org.ofbiz.tenant" datasource-name= "Localmysqltenant"/>

STEP4 the DOS command line, execute the command under the Ofbiz_home directory:

Ant Load-demo

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

OFBiz Learning Notes