*OFBIZ INSTALLATION WITH POSTGRESQL* * *
*Required : Ofbiz latest projet,* * PostGresql* * postgresql-connector-xxx.jar (driver for java to connect to mysql) * * Jdk1.6 * * * *Notes : Ofbiz by default uses port 8080. so make sure it is not bound to any other service. * * * * * *POSTGRESQL INSTALLATION* * * *1) Download the latest PostgreSQL database server from http://www.enterprisedb.com/exposure/postgres-download-downloads?googleaw=postgres-database-content&LS=SEM&gclid=CMyH9pWn3akCFQd76wodG2xDYw * * * *2) Download the postgres jdbc driver (postgresql-9.0-801.jdbc4) from * * http://jdbc.postgresql.org/download.html* * * *3) Install PostgreSQL database. * *4) Create database “Ofbiz”.* *5) Create login role for Ofbiz with all privilege on “Ofbiz” database.* * * *JAVA_INSTALLATION* * * *1)Get Jdk6 from “http://www.oracle.com/technetwork/java/index.html”* *2) Install Jdk6 and set JAVA_HOME and JRE_HOME variables.* * * *OFBIZ INSTALLATION* * * *1) Get the latest Ofbiz project zip from http://ofbiz.apache.org/.* *2) Extract Ofbiz project zip where we want to install eg, D:\* *3) Copy the postgres jdbc driver into \Ofbiz-root\framework\entity\lib\jdbc * *4) Change database configuration in the file* *\Ofbiz-root\framework\entity\config\entityengine.xml* * * *Changes in entityengine.xml file for postgres.* * * *A sample configuration.* * * *Delegator section,* * * * * <connection-factory class="* org.ofbiz.entity.connection.DBCPConnectionFactory*" /> *-* <../../../ofbiz-10.04/framework/entity/config/entityengine.xml##> <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="*localpostnew*" /> <group-map group-name="*org.ofbiz.olap*" datasource-name="* localpostnewolap*" /> <group-map group-name="*org.ofbiz.tenant*" datasource-name="* localpostnewtenant*" /> </delegator> *-* <../../../ofbiz-10.04/framework/entity/config/entityengine.xml##> <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="*localpostnew*" /> <group-map group-name="*org.ofbiz.olap*" datasource-name="* localpostnewolap*" /> <group-map group-name="*org.ofbiz.tenant*" datasource-name="* localpostnewtenant*" /> </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 running "ant run-tests" --> *-* <../../../ofbiz-10.04/framework/entity/config/entityengine.xml##> <delegator name="*test*" entity-model-reader="*main*" entity-group-reader="*main*"entity-eca-reader ="*main*"> <group-map group-name="*org.ofbiz*" datasource-name="*localpostnew*" /> <group-map group-name="*org.ofbiz.olap*" datasource-name="* localpostnewolap*" /> <group-map group-name="*org.ofbiz.tenant*" datasource-name="* localpostnewtenant*" /> </delegator> * * *In datasource section* * * <datasource name="*localpostnew*" helper-class="* org.ofbiz.entity.datasource.GenericHelperDAO*" schema-name="*public*"field-type-name ="*postnew*" check-on-start="*true*" add-missing-on-start="*true*"use-fk-initially-deferred ="*true*" alias-view-columns="*false*" join-style="*ansi*" result-fetch-size ="*50*" use-binary-type-for-blob="*true*" use-order-by-nulls="*true*"> <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="*org.postgresql.Driver*" jdbc-uri="* jdbc:postgresql://localhost:5432/ofbiz*" jdbc-username="*ofbiz*"jdbc-password ="*admin*" isolation-level="*ReadCommitted*" pool-minsize="*2*" pool-maxsize ="*250*" time-between-eviction-runs-millis="*600000*" /> </datasource> *-* <../../../ofbiz-10.04/framework/entity/config/entityengine.xml##> <datasource name="*localpostnewolap*" helper-class="* org.ofbiz.entity.datasource.GenericHelperDAO*" schema-name="*public*"field-type-name ="*postnew*" check-on-start="*true*" add-missing-on-start="*true*"use-fk-initially-deferred ="*false*" alias-view-columns="*false*" join-style="*ansi*"result-fetch-size ="*50*" use-binary-type-for-blob="*true*" use-order-by-nulls="*true*"> <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="*org.postgresql.Driver*" jdbc-uri="* jdbc:postgresql://localhost:5432/ofbizolap*" jdbc-username="*ofbiz*"jdbc-password ="*admin*" isolation-level="*ReadCommitted*" pool-minsize="*2*" pool-maxsize ="*250*" time-between-eviction-runs-millis="*600000*" /> </datasource> *-* <../../../ofbiz-10.04/framework/entity/config/entityengine.xml##> <datasource name="*localpostnewtenant*" helper-class="* org.ofbiz.entity.datasource.GenericHelperDAO*" schema-name="*public*"field-type-name ="*postnew*" check-on-start="*true*" add-missing-on-start="*true*"use-fk-initially-deferred ="*false*" alias-view-columns="*false*" join-style="*ansi*"result-fetch-size ="*50*" use-binary-type-for-blob="*true*" use-order-by-nulls="*true*"> <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="*org.postgresql.Driver*" jdbc-uri="* jdbc:postgresql://localhost:5432/ofbiztenant*" jdbc-username="*ofbiz*"jdbc-password ="*admin*" isolation-level="*ReadCommitted*" pool-minsize="*2*" pool-maxsize ="*250*" time-between-eviction-runs-millis="*600000*" /> </datasource> * * * * * * *5) In Ofbiz root folder there will be a file called startofbiz.bat, here we can set JVM memory settings* * * *6) In Ofbiz root run type the command “ant run-install”.* * * *7) startofbiz.bat* * * * * * Best Wishes* *prasath rajan * On Wed, Sep 21, 2011 at 2:44 PM, vivek mishra <vmvivek...@gmail.com> wrote: > Hello all > > I want to connect ofbiz to postgresql on my system. Please list the > procedure how to do? > > > Regards > *Vivek > * > * > * >