The following properties apply exclusively to the OpenJPA JDBC back-end.
Property name: 
openjpa.jdbc.ConnectionDecorators
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getConnectionDecorators
            
Resource adaptor config-property: 
ConnectionDecorators
            
Default: -
Description: A comma-separated list of plugin
strings (see Section 4, “
            Plugin Configuration
        ”) describing
org.apache.openjpa.lib.jdbc.ConnectionDecorator
instances to install on the connection factory. These decorators can wrap
connections passed from the underlying DataSource to add
functionality. OpenJPA will pass all connections through the list of decorators
before using them. Note that by default OpenJPA employs all
of the built-in decorators in the org.apache.openjpa.lib.jdbc
 package already; you do not need to list them here.
            
Property name: 
openjpa.jdbc.DBDictionary
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getDBDictionary
            
Resource adaptor config-property: 
DBDictionary
            
Default: Based on the
openjpa.ConnectionURL
openjpa.ConnectionDriverName
            
Description: A plugin string (see
Section 4, “
            Plugin Configuration
        ”) describing the
org.apache.openjpa.jdbc.sql.DBDictionary to use
for database interaction. OpenJPA typically auto-configures the dictionary based
on the JDBC URL, but you may have to set this property explicitly if you are
using an unrecognized driver, or to plug in your own dictionary for a database
OpenJPA does not support out-of-the-box. See
Section 4, “
            Database Support
        ” for details.
            
Property name: 
openjpa.jdbc.DriverDataSource
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getDriverDataSource
            
Resource adaptor config-property: 
DriverDataSource
            
Default: pooling
            
Description: The alias or full class name of
the
org.apache.openjpa.jdbc.schema.DriverDataSource
implementation to use to wrap JDBC Driver classes with javax.sql.DataSource
instances.
            
Property name: 
openjpa.jdbc.EagerFetchMode
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getEagerFetchMode
            
Resource adaptor config-property: 
EagerFetchMode
            
Default: parallel
            
Possible values: parallel,
join, none
            
Description: Optimizes how OpenJPA loads persistent relations. This setting can also be varied at runtime. See Section 8, “ Eager Fetching ” for details.
Property name: 
openjpa.jdbc.FetchDirection
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getFetchDirection
            
Resource adaptor config-property: 
FetchDirection
            
Default: forward
            
Possible values: forward,
reverse, unknown
            
Description: The expected order in which query result lists will be accessed. This property can also be varied at runtime. See Section 10, “ Large Result Sets ” for details.
Property name: 
openjpa.jdbc.JDBCListeners
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getJDBCListeners
            
Resource adaptor config-property: 
JDBCListeners
            
Default: -
Description: A comma-separated list of plugin
strings (see Section 4, “
            Plugin Configuration
        ”) describing
org.apache.openjpa.lib.jdbc.JDBCListener event
listeners to install. These listeners will be notified on various JDBC-related
events.
            
Property name: openjpa.jdbc.LRSSize
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getLRSSize
            
Resource adaptor config-property: 
LRSSize
            
Default: query
            
Possible values: query,
last, unknown
            
Description: The strategy to use to calculate the size of a result list. This property can also be varied at runtime. See Section 10, “ Large Result Sets ” for details.
Property name: 
openjpa.jdbc.MappingDefaults
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getMappingDefaults
            
Resource adaptor config-property: 
MappingDefaults
            
Default: jpa
Description: A plugin string (see
Section 4, “
            Plugin Configuration
        ”) describing the
org.apache.openjpa.jdbc.meta.MappingDefaults to
use to define default column names, table names, and constraints for your
persistent classes. See Section 5, “
            Mapping Factory
        ” for
details.
            
Property name: 
openjpa.jdbc.MappingFactory
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getMappingFactory
            
Resource adaptor config-property: 
MappingFactory
            
Default: -
Description: A plugin string (see
Section 4, “
            Plugin Configuration
        ”) describing the
org.apache.openjpa.meta.MetaDataFactory to use to
store and retrieve object-relational mapping information for your persistent
classes. See Section 5, “
            Mapping Factory
        ” for details.
            
Property name:
openjpa.jdbc.QuerySQLCache
            
Resource adaptor config-property: 
QuerySQLCache
            
Default: true.
            
Description: A plugin string (see 
Section 4, “
            Plugin Configuration
        ”) describing the 
java.util.Map to use for caching of the SQL string 
used by the find operation.  See Section 3, “
            Query SQL Cache
        ” for 
details.
            
Property name: 
openjpa.jdbc.ResultSetType
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getResultSetType
            
Resource adaptor config-property: 
ResultSetType
            
Default: forward-only
            
Possible values: forward-only
, scroll-sensitive, scroll-insensitive
            
Description: The JDBC result set type to use when fetching result lists. This property can also be varied at runtime. See Section 10, “ Large Result Sets ” for details.
Property name: openjpa.jdbc.Schema
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getSchema
            
Resource adaptor config-property: 
Schema
            
Default: -
Description: The default schema name to prepend to unqualified table names. Also, the schema in which OpenJPA will create new tables. See Section 11, “ Default Schema ” for details.
Property name: 
openjpa.jdbc.SchemaFactory
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getSchemaFactory
            
Resource adaptor config-property: 
SchemaFactory
            
Default: dynamic
            
Possible values: dynamic,
native, file, table,
others
            
Description: A plugin string (see
Section 4, “
            Plugin Configuration
        ”) describing the
org.apache.openjpa.jdbc.schema.SchemaFactory to
use to store and retrieve information about the database schema. See
Section 12.2, “
                Schema Factory
            ” for details.
            
Property name: openjpa.jdbc.Schemas
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getSchemas
            
Resource adaptor config-property: 
Schemas
            
Default: -
Description: A comma-separated list of the schemas and/or tables used for your persistent data. See Section 12.1, “ Schemas List ” for details.
Property name: openjpa.jdbc.SQLFactory
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getSQLFactory
            
Resource adaptor config-property: 
SQLFactory
            
Default: default
            
Description: A plugin string (see
Section 4, “
            Plugin Configuration
        ”) describing the
org.apache.openjpa.jdbc.sql.SQLFactory to use to abstract
common SQL constructs.
            
Property name: 
openjpa.jdbc.SubclassFetchMode
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getSubclassFetchMode
            
Resource adaptor config-property: 
SubclassFetchMode
            
Default: parallel
            
Possible values: parallel,
join, none
            
Description: How to select subclass data when it is in other tables. This setting can also be varied at runtime. See Section 8, “ Eager Fetching ”.
Property name: 
openjpa.jdbc.SynchronizeMappings
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getSynchronizeMappings
            
Resource adaptor config-property: 
SynchronizeMappings
            
Default: -
Description: Controls whether OpenJPA will attempt to run the mapping tool on all persistent classes to synchronize their mappings and schema at runtime. Useful for rapid test/debug cycles. See Section 1.3, “ Runtime Forward Mapping ” for more information.
Property name: 
openjpa.jdbc.TransactionIsolation
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getTransactionIsolation
            
Resource adaptor config-property: 
TransactionIsolation
            
Default: default
            
Possible values: default,
none, read-committed, 
read-uncommitted, repeatable-read, 
serializable
            
Description: The JDBC transaction isolation level to use. See Section 5, “ Setting the Transaction Isolation ” for details.
Property name: 
openjpa.jdbc.UpdateManager
            
Configuration API:
org.apache.openjpa.jdbc.conf.JDBCConfiguration.getUpdateManager
            
Resource adaptor config-property: 
UpdateManager
            
Default: batching-constraint
            
            Possible values: default,
operation-order, constraint, 
batching-constraint, batching-operation-order
            
Description: The full class name of the
org.apache.openjpa.jdbc.kernel.UpdateManager to
use to flush persistent object changes to the datastore. The provided default
implementation is
org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager
.