Run OFBiz with MySQL

**************************************************

*** 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安装与配置)

• ·StringBuffer与String
• ·《30年代互动电影——格斗天王》(OpenGL
• ·[原创]java web三层架构程序实例
• ·[原创]java web三层架构配置入门
• ·[原创]Java最佳实践笔记。（不断更新）
• ·[原创]工厂模式我之见（简单工厂模式 VS 工
• ·光脚养生4个妙招 生活_美丽顾问
• ·智能指针的另外用途：optional valu
• ·想不到的冰箱妙用 生活_美丽顾问
• ·保护 Internet Information