Page History

...

1. Java SDK
   Please see System Requirements for details of the correct Java JDK version required for each OFBiz version.
   NOTE: Check this bug before choosing a JDK version on a 64 bit server.
   
   
2. Check/install SVN client

   Expert Recommendation: If you intend to only install a binary release version (do we have that?) of OFBiz you will not need the SVN client. But normally you would want to have the svn client in order to be able to upgrade easily.

...

1. If you decide not to use the embedded Derby database, check/install your database of choice. See below for some information that may help with using or installing OFBiz with alternative databases
   
   Changing from Derby to MySQL Database
   OFBiz and Oracle
   Connecting OFBiz to PostGIS spatially enabled database
   Working with Multiple Databases
   
   
2. If necessary, put the correct JDBC driver in the following directory:
   
   
   1. ${ofbiz install dir}/framework/entity/lib/jdbc (you may NOTE: You can use "download-PG-JDBC" to download the last postgres jdbc driver or  " ant download-mySQL-JDBC" to  download the last mySQL jdbc driver)
   2. replacing Replace the old or incorrect version of the driver there (ie i.e. copy in with same name to avoid problems with update restoring the old driver later)
      
      
3. To setup the Entity Engine to use a different database from the default Derby database.
   In the: ${ofbiz install dir}/framework/entity/config/entityengine.xml file:

• •  Modify the "localmysql", "localmysqlolap" and "localmysqltenant" datasources elements to connect to your database.
    
    
  •  Modify the "default" delegator element:

        Change
            <group-map group-name="org.ofbiz" datasource-name="localderby"/>
        to
            <group-map group-name="org.ofbiz" datasource-name="localmysql"/>

  •     The OLAP and Tenant data sources will still use Derby. If you want to change those to use MySQL also, then:

    • Modify the "localmysqlolap" datasource element to connect to your OLAP database.

    • Modify the "localmysqltenant" datasource element to connect to your Tenant database.

  • Modify the "default" delegator element:

        Change
            <group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/>
        to
            <group-map group-name="org.ofbiz.olap" datasource-name="localmysqlolap"/>
        Change
            <group-map group-name="org.ofbiz.tenant" datasource-name="localderbytenant"/>
        to
            <group-map group-name="org.ofbiz.tenant" datasource-name="localmysqltenant"/>
    
    

  • Modify an existing datasource (near the bottom of the file) or create a new one by copying one of the sample datasources already there and giving it a new unique name

1. If using the default OFBiz transaction manager and connection pool , then update the data URI, username and password in the inline-jdbc tag
   
   
2. If you want your OFBiz tables in a special schema you will first need to create that schema in your database , and then set the schema-name attribute on the datasource tag
   
   
3. Find the "default" delegator near the top of the file and change the datasource-name attribute value in the group-map tag under it to the name of the data source you modified or created.

Expert Recommendation: if you are using an external

...

application server or want to setup more advanced Entity Engine configurations, see the Entity Engine Configuration Guide or other online documentation. The training videos from Undersun Consulting are highly recommend if you get into more advanced usage of OFBiz.

Initial Data Loading

To load the initial data just use the OFBiz install routine through ant or directly with Java and the ofbiz.jar executable JAR file. By default the install routine will load the "seed" and "demo" sets of data files, as defined in the entityengine.xml file and in the ofbiz-component.xml file in each component. Run one of these two options from the command line in the ofbiz home directory to run the default install routine:

...