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.

...

By default OFBiz includes and is configured for an embedded Java database called Derby. This database used to be called Cloudscape but was purchased by IBM, changed to be DB2 specification compliant, and then release as open source. This is a great database for demonstration, testing, development, and even small-scale production environments.

Expert Recommendation: We generally do not recommend the Derby database for production because it is not as easy to administer and optimize, and will generally not perform as well as more substantial or native databases

...

. This is mainly because Derby is a lightweight Java database.

Expert Recommendation: There are many databases that OFBiz can use, both commercial and open source. While there are significant production instances of OFBiz running

...

using Oracle, MS SQLServer, and so on, we generally recommend using an open source database such as Postgres or MySQL.

...

Which database to use is an important decision and may

...

have a future impacts on your implementation. If you do not have a preferred database

...

choice then we strongly recommend discussing options with an experienced consultant before making a final decision.

1. If you decide not to use the embedded Derby database, check/install your database of choice
2. If necessary, put the correct JDBC driver in:
   1. ${ofbiz install dir}/framework/entity/lib/jdbc (you may 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 the old or incorrect version of the driver there (ie 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:

...