ofbiz与mysql_怎么使ofbiz连接Mysql

Ofbiz自带的数据库是Derby，Derby是测试系统的数据库，不适合开发用。

1. 找到文件并打开 \framework\entity\config\entityengine.xml，

2. 把所有的delagator 的mysql的注释去掉，然后把相应的derby的设置注释掉。

3. 修改mysql数据库源信息

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-

alias-view-columns="false"

drop-fk-use-foreign-key-keyword="true"

table-type="InnoDB"

character-set="utf8"

collate="utf8_general_ci">

jdbc-driver="com.mysql.jdbc.Driver"

jdbc-uri="jdbc:mysql://localhost:3306/ofbiz?autoReconnect=true"

jdbc-username="

root

"

jdbc-password="root"

isolation-level="ReadCommitted"

pool-minsize="2"

pool-maxsize="250"

time-between-eviction-runs-millis="600000"/$amp;>amp;$lt;!-- Please note that at least one person has experienced a problem with this value with MySQL

and had to set it to -1 in order to avoid this issue.

For more look at ;

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-

alias-view-columns="false"

drop-fk-use-foreign-key-keyword="true"

table-type="InnoDB"

character-set="utf8"

collate="utf8_general_ci">

jdbc-driver="com.mysql.jdbc.Driver"

jdbc-uri="jdbc:mysql://localhost:3306/ofbizolap autoReconnect=true"

jdbc-username="root"

jdbc-password=""

isolation-level="ReadCommitted"

pool-minsize="2"

pool-maxsize="250"

time-between-eviction-runs-millis="600000"/$amp;>amp;$lt;!-- Please note that at least one person has experienced a problem with this value with MySQL

and had to set it to -1 in order to avoid this issue.

For more look at ;

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-

alias-view-columns="false"

drop-fk-use-foreign-key-keyword="true"

table-type="InnoDB"

character-set="utf8"

collate="utf8_general_ci">

jdbc-driver="com.mysql.jdbc.Driver"

jdbc-uri="jdbc:mysql://localhost:3306/ofbiztenant autoReconnect=true"

jdbc-username="root"

jdbc-password=""

isolation-level="ReadCommitted"

pool-minsize="2"

pool-maxsize="250"

time-between-eviction-runs-millis="600000"/$amp;>amp;$lt;!-- Please note that at least one person has experienced a problem with this value with MySQL

and had to set it to -1 in order to avoid this issue.

For more look at ;

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-

alias-view-columns="false"

drop-fk-use-foreign-key-keyword="true"

table-type="InnoDB"

character-set="utf8"

collate="utf8_general_ci">

jdbc-driver="com.mysql.jdbc.Driver"

jdbc-uri="jdbc:mysql://localhost:3306/ofbiz_odbc autoReconnect=true"

jdbc-username="root"

jdbc-password=""

isolation-level="ReadCommitted"

pool-minsize="2"

pool-maxsize="250"

time-between-eviction-runs-millis="600000"/>

4. 把mysql的驱动包放入 framework\entity\lib\jdbc 下