Ofbiz自带的数据库是Derby,Derby是测试系统的数据库,不适合开发用。
1. 找到文件并打开 \framework\entity\config\entityengine.xml,
<datasource name="localmysql"下面的character-set和collate修改下以支持中文。
character-set="utf8"
collate="utf8_general_ci"
安装MySQL数据库服务器,创建用户名口令和三个数据库
mysql -u root -proot
create user 'ofbiz'@'localhost' identified by 'ofbiz';
create database ofbiz DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
create database ofbizolap DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
create database ofbiztenant DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
grant all on *.* to 'ofbiz'@'localhost';
flush privileges;
show grants for 'ofbiz'@'localhost';
quit;
初始化OFBiz
set path=d:\OFBiz\apache-ant-1.9.4\bin;%path%
ant
cd D:\OFBiz\apache-ofbiz-12.04.04
ant load-demo
启动服务:
startofbiz.bat
浏览器打开以下界面:
电子商务 http://localhost:8080/ecommerce
https://localhost:8443/webtools
默认的admin/ofbiz来登录
ERP Order管理 https://localhost:8443/ordermgr
参考:
http://blog.csdn.net/xiaoliouc/article/details/10223095