opentaps 1.0.2安装(mysql)

opentaps是一个基于ofbiz基础开发的完全开源的企业级应用系统。它包括了完整的ERP和CRM解决方案和内建的企业智能工具。

opentaps现在在国内应用面不象sugarcrm/vtigercrm这些企业应用那样普遍，我想很大程度是由于JavaEE应用的逻辑结构严谨与复杂度决定其不象PHP应用那样容易拆分按需阅读切入。了解一个JavaEE的应用需要先了解其构造的框图、分层结构、每层实现的技术方式以及采用的技术。对于OFBiz这样一个野心极大要囊括几乎所有企业应用层面的项目，想要掌握它就更难上加难了，也许我们可以选择简单开始，先从文档的中文化与由简入繁的练习中开始了解这个庞大的开源项目。


闲话少说，我们先从opentaps的安装开始，让我们能够在自己的机器上跑起opentaps开始，也许你一直在寻找的企业应用已经全部在此喽！

准备工作：
1、安装JDK 1.5或以上版本，并在系统中设置好JAVA_HOME及相关PATH
2、安装MYSQL 5.0或以上版本
3、安装ANT1.7或以上版本，并在系统中设置好ANT_HOME及相关PATH
4、从以下地址下载opentaps 1.0.2二进制版本
http://nchc.dl.sourceforge.net/sourceforge/opentaps/opentaps-1.0.2-all-platforms.zip

开始安装：
1、通过mysql命令行来创建opentaps所需数据库，为了方便识别，我们这里就用opentaps来做数据库吧。
mysql> create database opentaps;

2、将下载的opentaps-1.0.2-all-platforms.zip解压至你的工作目录。

3、编辑opentaps目录中的framework/entity/config/entityengine.xml文件，使其能正确连接到你的mysql数据库中。
3.1 将其中的<delegator name="default"...> 段中的"datasource-name"从原来的"local" 改为 "localmysql"
3.2 编辑<datasource name="localmysql"...> 段内容，修改"jdbc-uri"为"jdbc:mysql://127.0.0.1/opentaps?autoReconnect=true"；修改"jdbc-username"/ "jdbc-password"为你的mysql连接用户名/密码，修改character-set="gbk"，collate="gbk_bin"
示例如下:

<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"/>
    </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"/>
    </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"/>
    </delegator>
    <delegator name="other" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main">
        <group-map group-name="org.ofbiz" datasource-name="localmysql"/>        
    </delegator>
...

    <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="false"
            drop-fk-use-foreign-key-keyword="true"
            table-type="InnoDB"
            character-set="gbk"
            collate="gbk_bin">
        <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/opentaps?autoReconnect=true"
                jdbc-username="opentaps"
                jdbc-password="opentaps-password"
                isolation-level="ReadCommitted"
                pool-minsize="2"
                pool-maxsize="20"/>
...

4、进行系统初始化
在命令行窗口下，进入opentaps根目录后运行
ant run-install
系统开始安装，等大约15-30分钟后，系统提示安装完成。


启动opentaps
双击运行opentaps目录下的startofbiz.bat命令即可，请注意控制台输入默认输出至log下的ofbiz.log中，所以无法从控制台中判断系统是否启动完成，一般需等待两到五分钟。也可以将输出改回至console。

访问opentaps
打开浏览器访问：http://localhost:8080/
点击你希望访问的功能特性，系统默认帐号为
admin/ofbiz，拥有所有权限。


本人原创文章，欢迎转载，转载请注明出处！

评论

1 楼 jerryli_vip 2009-07-06  

我用的oracle，按照楼主所说把framework/entity/config/entityengine.xml两处数据库连接改成oracle连接属性，build的时候报以下错误：     [java] ---- exception report ----------------------------------------------------------
     [java] [install.loadData]: Error loading XML Resource "file:/E:/Dev%20Files/Opentaps/opentaps%20Open%20Source%20ERP+CRM/opentaps%20ER
20+%20CRM%201.0/opentaps-1.0.4/hot-deploy/financials/data/FinancialsDemoPeople.xml"; Error was: A transaction error occurred reading data
     [java] Exception: org.xml.sax.SAXException
     [java] Message: A transaction error occurred reading data
     [java] ---- cause ---------------------------------------------------------------------
     [java] Exception: org.ofbiz.entity.GenericDataSourceException
     [java] Message: Unable to esablish a connection with the database. (Could not create connection)
     [java] ---- stack trace ---------------------------------------------------------------
     [java] org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection with the database. (Could not create connection)
     [java] org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:265)
     [java] org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:368)
     [java] org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:352)
     [java] org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:528)
     [java] org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:499)
     [java] org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:83)
     [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1101)
     [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:259)
     [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:241)
     [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:198)
     [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:226)
     [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:269)
     [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:83)
     [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:266)
     [java] org.ofbiz.base.start.Start.startServer(Start.java:317)
     [java] org.ofbiz.base.start.Start.start(Start.java:321)
     [java] org.ofbiz.base.start.Start.main(Start.java:407)
     [java] java.sql.SQLException: Could not create connection
     [java] org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:366)
     [java] org.ofbiz.entity.connection.MinervaConnectionFactory.getConnection(MinervaConnectionFactory.java:48)
     [java] org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:131)
     [java] org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:95)
     [java] org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:98)
     [java] org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:76)
     [java] org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:262)
     [java] org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:368)
     [java] org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:352)
     [java] org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:528)
     [java] org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:499)
     [java] org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:83)
     [java] org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1101)
     [java] org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:259)
     [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:241)
     [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:198)
     [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:226)
     [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:269)
     [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:83)
     [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:266)
     [java] org.ofbiz.base.start.Start.startServer(Start.java:317)
     [java] org.ofbiz.base.start.Start.start(Start.java:321)
     [java] org.ofbiz.base.start.Start.main(Start.java:407)
     [java] --------------------------------------------------------------------------------

     [java] 2009-07-06 15:24:02,468 (main) [    EntitySaxReader.java:197:INFO ] Beginning import from URL: file:/E:/Dev%20Files/Opentaps/o
ntaps%20Open%20Source%20ERP+CRM/opentaps%20ERP%20+%20CRM%201.0/opentaps-1.0.4/hot-deploy/financials/data/DemoAgreement.xml
     [java] 2009-07-06 15:24:02,468 (main) [    EntitySaxReader.java:235:INFO ] Transaction Timeout set to 2 hours (7200 seconds)
     [java] 2009-07-06 15:24:02,468 (main) [XAConnectionFactory.java:369:ERROR] Can't get an XAConnection
     [java] java.sql.SQLException: Listener refused the connection with the following error:
     [java] ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
     [java] The Connection descriptor used by the client was:
     [java] 127.0.0.1:1521:opentaps

     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
     [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
     [java]     at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
     [java]     at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
     [java]     at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
     [java]     at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
     [java]     at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:582)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:185)
     [java]     at org.ofbiz.minerva.pool.jdbc.xa.wrapper.XADataSourceImpl.getXAConnection(XADataSourceImpl.java:224)
     [java]     at org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.createObject(XAConnectionFactory.java:363)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:992)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:623)
     [java]     at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:363)
     [java]     at org.ofbiz.entity.connection.MinervaConnectionFactory.getConnection(MinervaConnectionFactory.java:48)
     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:131)
     [java]     at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:95)
     [java]     at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:98)
     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:76)
     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:262)
     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:368)
     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:352)
     [java]     at org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:528)
     [java]     at org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:499)
     [java]     at org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:83)
     [java]     at org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1101)
     [java]     at org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:259)
     [java]     at org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:241)
     [java]     at org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:198)
     [java]     at org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:226)
     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:269)
     [java]     at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:83)
     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java:266)
     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:317)
     [java]     at org.ofbiz.base.start.Start.start(Start.java:321)
     [java]     at org.ofbiz.base.start.Start.main(Start.java:407)
     [java] 2009-07-06 15:24:02,468 (main) [         ObjectPool.java:625:FATAL] Exception in creating new object for pool
     [java] java.lang.RuntimeException: Could not create connection
     [java]     at org.ofbiz.minerva.pool.ObjectPool.createNewObject(ObjectPool.java:995)
     [java]     at org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:623)
     [java]     at org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:363)
     [java]     at org.ofbiz.entity.connection.MinervaConnectionFactory.getConnection(MinervaConnectionFactory.java:48)
     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getManagedConnection(ConnectionFactory.java:131)
     [java]     at org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:95)
     [java]     at org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:98)
     [java]     at org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:76)
     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:262)
     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:368)
     [java]     at org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:352)
     [java]     at org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:528)
     [java]     at org.ofbiz.entity.datasource.GenericDAO.select(GenericDAO.java:499)
     [java]     at org.ofbiz.entity.datasource.GenericHelperDAO.findByPrimaryKey(GenericHelperDAO.java:83)
     [java]     at org.ofbiz.entity.GenericDelegator.storeAll(GenericDelegator.java:1101)
     [java]     at org.ofbiz.entity.util.EntitySaxReader.writeValues(EntitySaxReader.java:259)
     [java]     at org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:241)
     [java]     at org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:198)
     [java]     at org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:226)
     [java]     at org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:269)
     [java]     at org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:83)
     [java]     at org.ofbiz.base.start.Start.startStartLoaders(Start.java:266)
     [java]     at org.ofbiz.base.start.Start.startServer(Start.java:317)
     [java]     at org.ofbiz.base.start.Start.start(Start.java:321)
     [java]     at org.ofbiz.base.start.Start.main(Start.java:407)
     [java] 2009-07-06 15:24:02,468 (main) [         ObjectPool.java:653:FATAL] fatal pool error : Pool Data localoracle [0/0/20] 0