**************************************************
*** How to run OFBiz with MySQL ***
**************************************************
##################################################
### Download ofbiz source with svn
##################################################
Anonymous (Guest) Access
To connect to the OFBiz SVN Respository for anonymous checkout use your SVN client command line tool:
$ svn co http://svn.ofbiz.org/svn/ofbiz/trunk ofbiz
##################################################
### Create Database&User for OFBiz
##################################################
mysql>create database ofbiz_mysql;
mysql>grant all on *.* to ofbiz_mysql@localhost identified by 'ofbiz_mysql' with grant option;
mysql>create database ofbiz_odbc_mysql;
mysql>grant all on *.* to ofbiz_odbc_mysql@localhost identified by 'ofbiz_odbc_mysql' with grant option;
##################################################
### Set OFBiz Environment
##################################################
----------------------------------------------------------------------------------------------------
set JAVA_HOME=C:\j2sdk1.4.2_04
set CLASSPATH=C:\j2sdk1.4.2_04\lib\dt.jar;C:\j2sdk1.4.2_04\lib\tools.jar;.
----------------------------------------------------------------------------------------------------
#############################################################################
### Modify the [%OFBIZ_HOME%\framework\entity\config\entityengine.xml] file
#############################################################################
----------------------------------------------------------------------------------------------------
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
modify the follow segment:
<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.odbc" datasource-name="localderbyodbc"/>
</delegator>
to:
<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.odbc" datasource-name="odbcmysql"/>
</delegator>
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
addition,modify the follow segment:
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
<datasource name="localmysql"
helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
field-type-name="mysql"
check-on-start="true"
add-missing-on-start="true"
check-pks-on-start="false"
use-foreign-keys="true"
join-style="ansi-no-parenthesis"
alias-view-columns="true"
drop-fk-use-foreign-key-keyword="true"
table-type="InnoDB"
character-set="latin1"
collate="latin1_general_cs">
<read-data reader-name="seed"/>
<read-data reader-name="demo"/>
<read-data reader-name="ext"/>
