ofbiz9、oracle11g的配置.docVIP

 HYPERLINK /tufanshu/archive/2009/09/03/293787.html ofbiz9 + oracle 11g ofbiz默认的数据库为derby,这个当然不能在生产环境中使用，而且也不方便调试和管理。虽然ofbiz也支持很多的开源数据库，例如mysql等，但是我们这里还是使用主流的数据库系统oracle 11g.详细的操作如下1.更新JDBC驱动，将oracle必威体育精装版的jdbc驱动copy到${ofbiz install dir}/framework/entity/lib/jdbc 目录下。2.设置实体引擎( Entity Engine)的缺省数据库为oracle.在修改 ${ofbiz install dir}/framework/entity/config/entityengine.xml文件中修改配置：?? a.修改数据库连接参数：???? datasource name=localoracle??????????? helper-class=org.ofbiz.entity.datasource.GenericHelperDAO??????????? schema-name=ofbiz 你的数据库schema名称??????????? field-type-name=oracle??????????? check-on-start=true??????????? add-missing-on-start=true??????????? alias-view-columns=false??????????? join-style=ansi??????? read-data reader-name=seed/??????? read-data reader-name=seed-initial/??????? read-data reader-name=demo/??????? read-data reader-name=ext/??????? inline-jdbc??????????????? jdbc-driver=oracle.jdbc.driver.OracleDriver??????????????? jdbc-uri=jdbc:oracle:thin:@54:1521:ofbiz? ofbiz为你的数据库SID??????????????? jdbc-username=ofbiz? 用户名??????????????? jdbc-password=ofbiz? 密码??????????????? pool-minsize=2??????????????? pool-maxsize=250/??? /datasource? b. 修改实体引擎的数据库缺省配置如下：（将datasource-name的值设置为“localoracle”）????? 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=localoracle/??????? group-map group-name=org.ofbiz.olap datasource-name=localoracle/??? /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=localoracle/??????? group-map group-name=org.ofbiz.olap datasource-name=localoracle/??? /delegator??? !-- be sure that your default delegator (or the one you use) uses the same datasource for test. You must run ant run-install before r