ofbiz之二--將ofbiz從derby遷移MySQL

標籤：

【步驟一】

在MySQL資料庫中建立三個資料庫ofbiz、ofbizolap、ofbiztenant，統一全部常用UTF-8編碼

【步驟二】

 開啟實體引擎設定檔

/framework/entity/config/entityengine.xml

修改datasource、delegator 節點

 添加以下資料來源：

  <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="tenant"/>        <read-data reader-name="seed"/>        <read-data reader-name="seed-initial"/>        <read-data reader-name="demo"/>        <read-data reader-name="ext"/>        <read-data reader-name="ext-test"/>        <read-data reader-name="ext-demo"/>        <inline-jdbc                jdbc-driver="com.mysql.jdbc.Driver"                jdbc-uri="jdbc:mysql://localhost/ofbiz?autoReconnect=true"                jdbc-username="root"                jdbc-password="root"                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>    <datasource name="localmysqlolap"            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="tenant"/>        <read-data reader-name="seed"/>        <read-data reader-name="seed-initial"/>        <read-data reader-name="demo"/>        <read-data reader-name="ext"/>        <read-data reader-name="ext-test"/>        <read-data reader-name="ext-demo"/>        <inline-jdbc                jdbc-driver="com.mysql.jdbc.Driver"                jdbc-uri="jdbc:mysql://localhost/ofbizolap?autoReconnect=true"                jdbc-username="root"                jdbc-password="root"                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>    <datasource name="localmysqltenant"            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="tenant"/>        <read-data reader-name="seed"/>        <read-data reader-name="seed-initial"/>        <read-data reader-name="demo"/>        <read-data reader-name="ext"/>        <read-data reader-name="ext-test"/>        <read-data reader-name="ext-demo"/>        <inline-jdbc                jdbc-driver="com.mysql.jdbc.Driver"                jdbc-uri="jdbc:mysql://localhost/ofbiztenant?autoReconnect=true"                jdbc-username="root"                jdbc-password="root"                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>

 

   將資料來源從預設的derby切換至MySQL

<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"/></delegator> <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="localmysqlolap"/>    <group-map group-name="org.ofbiz.tenant" datasource-name="localmysqltenant"/></delegator>

 儲存，重新用ant運行，則成功切換至MySQL

【參考】

https://cwiki.apache.org/confluence/display/OFBIZ/How+to+migrate+OfBiz+from+Derby+to+MySQL+database

ofbiz之二--將ofbiz從derby遷移MySQL