Setup MySQL as Datasource for OFBiz

Standard

Derby is the default database of ofbiz. Now we migrate our database to MySQL from derby.
1. Before you start migrating check your installed MySQL version & download the supported version of mysql-connector.jar
2. Place the mysql-connector.jar to <ofbiz-dir>/framework/entity/lib/jdbc
MysqlConnector
3. Create 3 database [Ex. ofbiz, ofbizolap, ofbiztenant]
4. Open entityengine.xml file from <ofbiz-dir>/framework/entity/config/
5. Edit as follows,

Advertisements

Start ofbiz

Standard

Note: Ofbiz version 16 or later is build with gradle & previous versions are build by ant.

Go to ofbiz directory ..
1.
Load demo data [For first time only]
ant load-demo [ofbiz version<13]
2.
After loading demo data start ofbiz
ant start [ofbiz version<13]
3.
Hit the url (http://localhost:8080/webtools) after successful start.
4.
Login with username admin & password ofbiz