去年4月份原来写在sina上面的东西，技术文章以后都迁移至此处

?

Step1 、在 mysql 下建一个库 ofbiz10

?

Step2 、把 mysql 的驱动包拷到 framework\entity\lib\jdbc 下

?

Step3 、修改 framework\entity\config 下的 entityengine.xml ，如下：

?

a: 修改连接参数

?

<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="false"

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

            table-type="InnoDB"

            character-set="utf8"                ——改成你数据库的字符集

            collate="utf8_general_ci">     ——排序方式，其他字符集上网查找

        <read-data reader-name="seed"/>

        <read-data reader-name="seed-initial"/>

        <read-data reader-name="demo"/>

        <read-data reader-name="ext"/>

        <inline-jdbc

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

                jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz10?autoReconnect=true"   ——库名

                jdbc-username="root"              ——用户名

                jdbc-password=""                      ——密码

                isolation-level="ReadCommitted"

                pool-minsize="2"

                pool-maxsize="250"

                time-between-eviction-runs-millis="600000"/><!-- 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 http://markmail.org/thread/5sivpykv7xkl66px and http://commons.apache.org/dbcp/configuration.html-->

        <!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->

</datasource>

?

b: 修改实体引擎的数据库缺省配置

    <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="localmysql"/>

        <group-map group-name="org.ofbiz.tenant" datasource-name="localmysql"/>

    </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="localmysql"/>

        <group-map group-name="org.ofbiz.tenant" datasource-name="localmysql"/>

    </delegator>

 

    <!-- be sure that your default delegator (or the one you use) uses the same datasource for test. You must run "ant run-install" before running "ant run-tests" -->

    <delegator name="test" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main">

        <group-map group-name="org.ofbiz" datasource-name="localmysql"/>

        <group-map group-name="org.ofbiz.olap" datasource-name="localmysql"/>

        <g