helper-class= org.ofbiz.entity.datasource. GenericHelperDAO

The OFBiz utility program (Java class) that performs conversions and other helper functions on behalf of the Entity Engine for this particular database.

field-type-name="postnew"

Pointer to the field type definition XML document that describes the field type mappings for this database. Field type files are found in the ~framework/entity/fieldtype directory. Each file's name is derived by adding the value in this field to a prefix of fieldtype. For example, field type definitions for localpostnew, where the field-type-name ="postnew" are found in: ~framework/entity/fieldtype/fieldtypepostnew.xml

schema-name="public"

Default schema name for PostgreSQL database schemas. Other databases may not require a default schema name. Configure accordingly.

check-on-start="true"

Instructs OFBiz to check the database against the configured data model (that is, against the configured entities for a data source) for missing entities and/or tables.

add-missing-on-start="true"

Instructs OFBiz to add any missing tables and keys to the database based on the defined data model. Set this to false if you do NOT want OFBiz to modify the target database.

use-fk-initially-deferred= "false"

Used to specify whether or not to set the "INITIALLY DEFERRED" option available in many databases when creating foreign keys. (Note: not all databases support this option). When enabled and supported, the foreign keys will not be checked until a transaction is committed.

Defaults to "true".

alias-view-columns="false"

This value is used to compensate for a variation seen in some JDBC drivers where column names returned for aliased fields may be either the alias name or the full text of what makes up that alias name. See your database vendor's documentation for more information on settings per your target database.

Defaults to "true".

join-style="ansi"

Used to specify the syntax to use when doing table joins in view-entity operations. Many databases are adopting the ANSI JOIN standard, but before that was introduced, theta joins were much more common. Two theta join styles are supported: Oracle and MS SQL. Valid values: ansi, ansi-no-parenthesis, theta-oracle or theta-mssql.

Defaults to ansi.

result-fetch-size="50"

Used by OFBiz with the list iterator to determine default result set size.

use-binary-type-for-blob= "true"

Instructs OFBiz on how to map database fields typed as Binary Large Objects (BLOBs).

jdbc-driver

Java class file name of the driver to use when accessing the database. This class file must be on the OFBiz CLASSPATH.

jdbc-uri

Network-based location of the database. The syntax for database connection URI(s) vary from database to database. Please refer to your vendor's documentation for the appropriate syntax. For PostgreSQL, the following syntax is used:

jdbc:postgresql://{IP Address}/{Database Name}

jdbc-username

The plain text username as established on the remote database for OFBiz to use to access the database.

jdbc-password

The plain text password as established on the remote database for OFBiz to use when connecting to the database.

isolation-level

Transaction isolation levels determine how insulated concurrently active transactions are from one another. This attribute establishes the default row-level locking behavior for this database connection.

While details of database transaction theory are beyond the scope of this book, it is recommended that most applications should use

ReadCommitted or ReadUncommitted isolation levels.

Note: transactions discussed within the context of the Entity Engine's configuration are not the same transactions as configured for the Service Engine.

pool-size

Used to configure database connection pooling. The provided values are those found by experience to be most useful for the configured data source. The Entity Engine handles all connection acquisition and closure automatically (unless you otherwise instruct it).

pool-maxsize

Used to configure database connection pooling (Minerva). The provided values are those found by experience to be most useful for the configured data source.