Run OFBiz with MySQL

最新推荐文章于 2021-02-19 06:21:12 发布
最新推荐文章于 2021-02-19 06:21:12 发布
阅读量1.7k 收藏
点赞数
分类专栏： Workflow Study 文章标签： mysql java svn download jdbc ant
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Asirxing/article/details/509189
版权

**************************************************
*** How to run OFBiz with MySQL                ***
**************************************************

##################################################
### Download ofbiz source with svn
##################################################
Anonymous (Guest) Access
To connect to the OFBiz SVN Respository for anonymous checkout use your SVN client command line tool:
$ svn co http://svn.ofbiz.org/svn/ofbiz/trunk ofbiz

##################################################
### Create Database&User for OFBiz
##################################################
mysql>create database ofbiz_mysql;
mysql>grant all on *.* to ofbiz_mysql@localhost identified by 'ofbiz_mysql' with grant option;
mysql>create database ofbiz_odbc_mysql;
mysql>grant all on *.* to ofbiz_odbc_mysql@localhost identified by 'ofbiz_odbc_mysql' with grant option;

##################################################
### Set OFBiz Environment
##################################################
----------------------------------------------------------------------------------------------------
set JAVA_HOME=C:/j2sdk1.4.2_04
set CLASSPATH=C:/j2sdk1.4.2_04/lib/dt.jar;C:/j2sdk1.4.2_04/lib/tools.jar;.
----------------------------------------------------------------------------------------------------

#############################################################################
### Modify the [%OFBIZ_HOME%/framework/entity/config/entityengine.xml] file
#############################################################################
----------------------------------------------------------------------------------------------------
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
modify the follow segment:
    <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="localderby"/>
        <group-map group-name="org.ofbiz.odbc" datasource-name="localderbyodbc"/>
    </delegator>
to:
    <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.odbc" datasource-name="odbcmysql"/>
    </delegator>
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
addition,modify the follow segment:
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
    <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="true"
            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="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="ofbiz"
                jdbc-password="ofbiz"
                isolation-level="ReadCommitted"
                pool-minsize="2"
                pool-maxsize="20"/>
        <!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
    </datasource>
to:
    <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="true"
            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="demo"/>
        <read-data reader-name="ext"/>
        <inline-jdbc
                jdbc-driver="com.mysql.jdbc.Driver"
                jdbc-uri="jdbc:mysql://localhost/ofbiz_mysql?autoReconnect=true"
                jdbc-username="ofbiz_mysql"
                jdbc-password="ofbiz_mysql"
                isolation-level="ReadCommitted"
                pool-minsize="2"
                pool-maxsize="20"/>
        <!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
    </datasource>
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
another,modify the follow segment:
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
    <datasource name="odbcmysql"
            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="true"
            drop-fk-use-foreign-key-keyword="true"
            table-type="InnoDB"
            character-set="latin1"
            collate="latin1_general_cs">
        <read-data reader-name="seed"/>
        <inline-jdbc
                jdbc-driver="com.mysql.jdbc.Driver"
                jdbc-uri="jdbc:mysql://127.0.0.1/ofbiz_odbc?autoReconnect=true"
                jdbc-username="ofbiz"
                jdbc-password="ofbiz"
                isolation-level="ReadCommitted"
                pool-minsize="2"
                pool-maxsize="20"/>
        <!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
    </datasource>
to:
    <datasource name="odbcmysql"
            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="true"
            drop-fk-use-foreign-key-keyword="true"
            table-type="InnoDB"
            character-set="latin1"
            collate="latin1_general_cs">
        <read-data reader-name="seed"/>
        <inline-jdbc
                jdbc-driver="com.mysql.jdbc.Driver"
                jdbc-uri="jdbc:mysql://localhost/ofbiz_odbc_mysql?autoReconnect=true"
                jdbc-username="ofbiz_odbc_mysql"
                jdbc-password="ofbiz_odbc_mysql"
                isolation-level="ReadCommitted"
                pool-minsize="2"
                pool-maxsize="20"/>
        <!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
    </datasource>
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
----------------------------------------------------------------------------------------------------

##################################################
### Building From SVN
##################################################
----------------------------------------------------------------------------------------------------
1、When building from SVN you will need to have Ant 1.5 or later (see http://ant.apache.org) installed
and setup properly in addition to a Java 1.4 or newer J2SDK (NOT just the JRE, need to full SDK) as
mentioned above.

2、In the directory where you want OFBiz to be, do a SVN checkout of the ofbiz module on the java.net
servers. For example:
svn co http://svn.ofbiz.org/svn/ofbiz/trunk ofbiz
For information on connecting to SVN click here (svn.ofbiz.org).

3、Now go into the "ofbiz" directory and run "ant". It will compile all modules and leave you an executable
jar (ofbiz.jar) in the "ofbiz" directory.

4、To load the seed data, run "ant run-install", or "$JAVA_HOME/bin/java -jar ofbiz.jar install",
or "%JAVA_HOME%/bin/java -jar ofbiz.jar install"

5、To start the server run "ant run", or "$JAVA_HOME/bin/java -jar ofbiz.jar",
or "%JAVA_HOME%/bin/java -jar ofbiz.jar"

6、Another build option in the Ant build script that is useful is "ant clean". That will clean out all built
classes allowing you to run "ant" again to get a clean build. If you are running into funny errors after
updating from SVN in the future, give this clean build process a try first.
----------------------------------------------------------------------------------------------------

##################################################
### Quick & Easy Setup
##################################################
----------------------------------------------------------------------------------------------------
You can get up and running quickly by downloading the OFBiz Complete distribution and following some
simple instructions. For more options and explanations, see the rest of this document.

1、Download and install the Java 2 v1.4 or later JDK/J2SDK (not the JRE, need the full SDK) from Sun's
Java site, and make sure your JAVA_HOME environment variable is set to this JDK after installation
(NOTE that for Mac OS X no JVM setup is needed, just make sure you are up to date with the Java 1.4 series
with the OS X Software Update facility).

2、Download the OFBiz Apps archive and unzip it in the directory of your choice. This should create one
sub-directory: ofbiz. This will be the OFBIZ_HOME location.
 
3、Start OFBiz with embedded Jetty by going into the ofbiz directory and then running "startofbiz.bat" (or
"%JAVA_HOME%/bin/java -jar ofbiz.jar") for Windows, or "./startofbiz.sh" (or "$JAVA_HOME/bin/java -jar ofbiz.jar")
for Linux/Unix. For OS X you can just run "java -jar ofbiz.jar" and you don't need to setup the JAVA_HOME
or anything because it is already there.

4、Open a browser and go to http://127.0.0.1:8080/ecommerce for the ecommerce application or
https://127.0.0.1:8443/webtools for the WebTools application or https://127.0.0.1:8443/catalog
for the Catalog Manager application.

5、The default administrative account is username: "admin", password: "ofbiz".

6、Have fun with it! You are running on a Java database. For more discussion of databases, read the section below
on that topic.

7、For more detailed options and configuration information, read on!
----------------------------------------------------------------------------------------------------

参考网址：

http://svn.ofbiz.org/

http://www.supcode.com/Article/html/4/50/2005/03/07/038245534451.shtml (OFBIZ安装与配置)

Asirxing
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
run ofbiz with mysql5.5+
04-13 329
创建表空间mysql>create database ofbiz_mysql;mysql>grant all on *.* to ofbiz@localhost identified by 'ofbiz' with grant option;修改配置文件去掉 table-type="InnoDB" 属性。table-type属性在 mysql5.5 以后版本被engine替代，而且mysql5.5 以后默认的存储引擎就是InnoDB，因此去掉该参数没有任何副作用。下载 mysql jdbc 驱动ant ru
ofbiz与mysql_ofbiz 安装以及使用mysql数据库
weixin_28953819的博客
02-08 217
一.安装安装需要eclipse ，以及eclipse中的javacc和svn插件svn地址：http://svn.apache.org/repos/asf/ofbiz/branches/release13.07下载后会报错，在javabulidpath中将missing的移除，并将项目中framework下的entity下的config文件夹加载进来然后编译json.jj,parser.jj...
ofbiz 安装以及使用mysql数据库
sky_fate的专栏
10-14 2174
一.安装 安装需要eclipse ，以及eclipse中的javacc和svn插件 svn地址：http://svn.apache.org/repos/asf/ofbiz/branches/release13.07 下载后会报错，在java bulid path 中将missing的移除，并将项目中framework下的entity下的config文件夹加载进来 然后编译json.jj
ofbiz结合mysql安装教程
lchunp的专栏
04-28 1578
ofbiz结合mysql安装，下面是安装步骤。  一：安装mysql。  详细参照mysql的基本安装方法  http://blog.csdn.net/lchunp/article/details/8862016，主要是要在mysql里面建立OFBiz所需要的数据库名称和用户，我们可以利用Navicat连接mysql，并且新建立一个数据库ofbiz。我使用的是root用户，密码是:admin
ofbiz修改mysql_如何将OFBIZG的默认数据库更改mysql的方法(只求参考 )
weixin_39999586的博客
02-06 94
ofbiz自带的数据库是Derby,这是一种小型的适合与测试系统的数据库,但不适合在产品级系统中使用,所以通常我们需要将ofbiz迁移到其它数据库上,下面我就以如何迁移至mysql为例,向大家讲述数据库迁移过程,迁移至其它数据库的过程类似.第一步:修改entityengine.xml文件.该文件的位置是ofbiz_home\framework\entity\config\entityengine....
ofbiz mysql 序列_如何将OFBIZ(opentaps)默认数据库迁移至mysql
weixin_33905037的博客
02-19 73
如何将OFBIZ(opentaps)默认数据库迁移至mysql.ofbiz自带的数据库是Derby,这是一种小型的适合与测试系统的数据库,但不适合在产品级系统中使用,所以通常我们需要将ofbiz迁移到其它数据库上,下面我就以如何迁移至mysql为例,向大家讲述数据库迁移过程,迁移至其它数据库的过程类似.第一步:修改entityengine.xml文件.该文件的位置是ofbiz_homeframew...
ofbiz12.04更换数据库为mysql
program_thinker的专栏
10-06 1230
ofbiz自带数据库为derby，只适合于内部ce
开源电商 OFBiz (Mysql)Idea安装过程及问题(中文乱码，500 GenericEntityException jdbc，Visitor错误处理)
泥人儿的博客
09-14 1543
开源电商 OFBiz (Mysql)安装过程及问题OFBiz是一个非常著名的电子商务平台，是一个非常著名的开源项目，提供了创建基于最新J2EE/XML规范和技术标准，构建大中型企业级、跨平台、跨数据库、跨应用服务器的多层、分布式电子商务类WEB应用系统的框架。 OFBiz最主要的特点是OFBiz提供了一整套的开发基于Java的web应用程序的组件和工具。包括实体引擎, 服务引擎, 消息引擎, 工作流
Ofbiz10.04改用mysql数据库配置
guhao's blog
08-19 142
去年4月份原来写在sina上面的东西，技术文章以后都迁移至此处   Step1 、在 mysql 下建一个库 ofbiz10   Step2 、把 mysql 的驱动包拷到 framework\entity\lib\jdbc 下   Step3 、修改 framework\entity\config 下的 entityengine.xml ...
ofbiz16 配置mysql数据库
04-24
NULL 博文链接：https://youngbrick.iteye.com/blog/2344086
Ofbiz 和 Mysql中文乱码解决方法.docx
10-30
本文将详细探讨如何解决在Ofbiz（一个开源的企业应用框架）与MySQL数据库交互时出现的中文乱码问题。 首先，我们需要了解中文乱码产生的原因。通常，乱码是由于数据在不同阶段的编码格式不一致导致的。例如，JVM...
ofbiz开发文档
10-26
**OFBiz 开发文档概述** OFBiz，全称为Open For Business Project，是一个开源的企业级应用框架，主要用于构建和管理复杂的业务流程。它提供了一个全面的、可扩展的、基于服务的架构，支持电子商务、供应链管理、...
Run JBPM3.0.x with MySQL
Asirxing的专栏
10-19 2085
***************************************************** How to run JBPM with MySQL                   *****************************************************################################################
Run Shark with MySQL
Asirxing的专栏
10-20 2053
***************************************************** How to run Shark with MySQL                   *****************************************************###############################################
在JBoss+MySQL环境下运行obe
Asirxing的专栏
10-29 1698
***************************************************** 在JBoss+MySQL环境下运行obe             ***************************************************** 我按照obe文档的说明试着在JBoss+MySQL环境下运行obe程序，在部署obe程序后启动JBoss，总是一堆的异
准确编译obe的cvs源程序
Asirxing的专栏
10-19 1553
***************************************************** 准确编译 obe 的 cvs源程序                      *****************************************************#####################################################
我的blog开通了，主题是基于J2EE的工作流
Asirxing的专栏
10-19 1148
我的blog开通了，主题是基于J2EE的工作流
OFBiz电商开发入门：从JDK到MySQL环境配置
在开发环境中，OFBiz最初使用的是内嵌的Derby数据库，但为了更稳定和广泛的部署，推荐在正式环境中使用MySQL 5.0及以上版本。教程开始时强调了JDK的选择，建议使用JDK 6的最新版，并将其安装在C:\Java\jdk1.6.0路径...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值