You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by "arvind.kumar.avinash" <ar...@hcl.com> on 2012/04/27 08:54:46 UTC
Re: Error - Migrating from Derby to MySQL
If you are still stuck, do as instructed below:
I have used the following versions for this topic:
1. MySQL: mysql-5.5.23-winx64 (zip) - the topic is still valid for 32 bit
version
2. MySQL JDBC driver: mysql-connector-java-5.1.14-bin.jar - to be placed in
<ofbiz-dir>/framework/entity/lib/jdbc
3. OfBiz: apache-ofbiz-10.04
Step - I
C:\mysql-5.5.23-winx64\bin>mysql -u root
mysql>create database ofbiz;
mysql>create database ofbizolap;
mysql>create database ofbiztenant;
mysql>use mysql;
mysql>select database();
mysql>create user ofbiz@localhost;
mysql>create user ofbizolap@localhost;
mysql>create user ofbiztenant@localhost;
mysql>update user set password=PASSWORD("ofbiz") where User='ofbiz';
mysql>update user set password=PASSWORD("ofbizolap") where User='ofbizolap';
mysql>update user set password=PASSWORD("ofbiztenant") where
User='ofbiztenant';
mysql>grant all privileges on *.* to 'ofbiz'@localhost identified by
'ofbiz';
mysql>grant all privileges on *.* to 'ofbizolap'@localhost identified by
'ofbizolap';
mysql>grant all privileges on *.* to 'ofbiztenant'@localhost identified by
'ofbiztenant';
Step - II
Use webtools to export all data to XML:
a. Start OfBiz
b. Navigate to http://localhost:8080/catalog/
c. Go to Applications>WebTools
d. Go to section 'Entity XML Tools' and click the link 'XML Data Export All'
- export the data to a directory of your choice
Step - III
Stop OfBiz server
Create a backup of <ofbiz-dir>/framework/entity/config/entityengine.xml
Edit entityengine.xml as follows:
1. Add the following datasources below the datasource 'localmysql'
<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="latin1"
collate="latin1_general_cs">
<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/ofbiz?autoReconnect=true"
jdbc-username="ofbizolap"
jdbc-password="ofbizolap"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="250"
time-between-eviction-runs-millis="600000"/>
</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="latin1"
collate="latin1_general_cs">
<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/ofbiz?autoReconnect=true"
jdbc-username="ofbiztenant"
jdbc-password="ofbiztenant"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="250"
time-between-eviction-runs-millis="600000"/>
</datasource>
2. Replace derby with mysql in default, default-no-eca and test delegators
as follows:
<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>
3. Save this file
Step -IV
1. Open ofbiz/framework/entity/src/org/ofbiz/entity/jdbc/DatabaseUtil.java
in eclipse and replace sqlBuf.append(" TYPE ") with sqlBuf.append(" ENGINE
")
2. Save the file and run ofbiz/build.xml
Note: This is required because TYPE was deprecated in MySQL 4.0 and removed
in MySQL 5.5. The older TYPE option was synonymous with the new option
ENGINE
Step -V
1. Run the following command from command prompt:
ofbiz-dir>java -jar ofbiz.jar -install
2. Start OfBiz
3. Use webtools to import all data from XML:
a. Navigate to http://localhost:8080/catalog/
b. Go to Applications>WebTools
c. Go to section 'Entity XML Tools' and click the link 'XML Data Import Dir'
-> In the 'Absolute directory path:' enter the full path of the directory
where you exported the data in Step - II
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Error-Migrating-from-Derby-to-MySQL-tp2339328p4591905.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Error - Migrating from Derby to MySQL
Posted by "arvind.kumar.avinash" <ar...@hcl.com>.
Thanks Jacques! I have added the topic at
https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo
as suggested by you
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Error-Migrating-from-Derby-to-MySQL-tp2339328p4592359.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Error - Migrating from Derby to MySQL
Posted by Jacques Le Roux <ja...@les7arts.com>.
Maybe you could add this as a tip at
https://cwiki.apache.org/confluence/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo
Jacques
From: "arvind.kumar.avinash" <ar...@hcl.com>
> If you are still stuck, do as instructed below:
>
> I have used the following versions for this topic:
>
> 1. MySQL: mysql-5.5.23-winx64 (zip) - the topic is still valid for 32 bit
> version
> 2. MySQL JDBC driver: mysql-connector-java-5.1.14-bin.jar - to be placed in
> <ofbiz-dir>/framework/entity/lib/jdbc
> 3. OfBiz: apache-ofbiz-10.04
>
> Step - I
> C:\mysql-5.5.23-winx64\bin>mysql -u root
> mysql>create database ofbiz;
> mysql>create database ofbizolap;
> mysql>create database ofbiztenant;
> mysql>use mysql;
> mysql>select database();
> mysql>create user ofbiz@localhost;
> mysql>create user ofbizolap@localhost;
> mysql>create user ofbiztenant@localhost;
> mysql>update user set password=PASSWORD("ofbiz") where User='ofbiz';
> mysql>update user set password=PASSWORD("ofbizolap") where User='ofbizolap';
> mysql>update user set password=PASSWORD("ofbiztenant") where
> User='ofbiztenant';
> mysql>grant all privileges on *.* to 'ofbiz'@localhost identified by
> 'ofbiz';
> mysql>grant all privileges on *.* to 'ofbizolap'@localhost identified by
> 'ofbizolap';
> mysql>grant all privileges on *.* to 'ofbiztenant'@localhost identified by
> 'ofbiztenant';
>
> Step - II
> Use webtools to export all data to XML:
> a. Start OfBiz
> b. Navigate to http://localhost:8080/catalog/
> c. Go to Applications>WebTools
> d. Go to section 'Entity XML Tools' and click the link 'XML Data Export All'
> - export the data to a directory of your choice
>
> Step - III
> Stop OfBiz server
> Create a backup of <ofbiz-dir>/framework/entity/config/entityengine.xml
> Edit entityengine.xml as follows:
> 1. Add the following datasources below the datasource 'localmysql'
> <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="latin1"
> collate="latin1_general_cs">
> <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/ofbiz?autoReconnect=true"
> jdbc-username="ofbizolap"
> jdbc-password="ofbizolap"
> isolation-level="ReadCommitted"
> pool-minsize="2"
> pool-maxsize="250"
> time-between-eviction-runs-millis="600000"/>
> </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="latin1"
> collate="latin1_general_cs">
> <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/ofbiz?autoReconnect=true"
> jdbc-username="ofbiztenant"
> jdbc-password="ofbiztenant"
> isolation-level="ReadCommitted"
> pool-minsize="2"
> pool-maxsize="250"
> time-between-eviction-runs-millis="600000"/>
> </datasource>
> 2. Replace derby with mysql in default, default-no-eca and test delegators
> as follows:
> <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>
> 3. Save this file
>
> Step -IV
> 1. Open ofbiz/framework/entity/src/org/ofbiz/entity/jdbc/DatabaseUtil.java
> in eclipse and replace sqlBuf.append(" TYPE ") with sqlBuf.append(" ENGINE
> ")
> 2. Save the file and run ofbiz/build.xml
> Note: This is required because TYPE was deprecated in MySQL 4.0 and removed
> in MySQL 5.5. The older TYPE option was synonymous with the new option
> ENGINE
>
> Step -V
> 1. Run the following command from command prompt:
> ofbiz-dir>java -jar ofbiz.jar -install
> 2. Start OfBiz
> 3. Use webtools to import all data from XML:
> a. Navigate to http://localhost:8080/catalog/
> b. Go to Applications>WebTools
> c. Go to section 'Entity XML Tools' and click the link 'XML Data Import Dir'
> -> In the 'Absolute directory path:' enter the full path of the directory
> where you exported the data in Step - II
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Error-Migrating-from-Derby-to-MySQL-tp2339328p4591905.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.