|
org.jpox.rdbms.statementBatchLimit
|
|---|
| Description | Maximum number of statements that can be batched. Up to and including JPOX 1.2.0-beta-2
the default is -1 (unlimited) and only applies to container elements/keys/values. For
later releases the default is 50 and also applies to delete of objects.
Please refer to the Statement Batching guide |
| Range of Values | integer value (0 = no batching) |
|
org.jpox.rdbms.CheckExistTablesOrViews
|
|---|
| Description | Whether to check if the table/view exists. If false, it disables the automatic generation
of tables that don't exist. |
| Range of Values | true | false |
|
org.jpox.rdbms.initializeColumnInfo
|
|---|
| Description | Allows control over what column information is initialised when a table is loaded for the
first time. By default info for all columns will be loaded. Unfortunately some RDBMS are
particularly poor at returning this information so we allow reduced forms to just load the
primary key column info, or not to load any. |
| Range of Values | ALL | PK | NONE |
|
org.jpox.rdbms.classAdditionMaxRetries
|
|---|
| Description | The maximum number of retries when trying to find a class to persist or when validating a class. |
| Range of Values | 3 | A positive integer |
|
org.jpox.rdbms.constraintCreateMode
|
|---|
| Description | How to determine the RDBMS constraints to be created.
JPOX will automatically add foreign-keys/indices to handle all relationships, and will
utilise the specified MetaData foreign-key information.
JDO2 will only use the information in the MetaData file(s).
|
| Range of Values | JPOX | JDO2 |
|
org.jpox.rdbms.uniqueConstraints.mapInverse
|
|---|
| Description | Whether to add unique constraints to the element table for a map inverse field.
Possible values are true or false. |
| Range of values | true | false |
|
org.jpox.rdbms.discriminatorPerSubclassTable
|
|---|
| Description | In all versions of JPOX upto and including 1.2.0-beta-4 when using value-map discriminator
strategy and when having subclasses with their own tables, a discriminator column
would have been put in subclass tables too (without benefit). After 1.2.0-beta-4
only the base class where the discriminator is defined will have a discriminator
column |
| Range of values | false | true |
|
org.jpox.rdbms.useUpdateLock
|
|---|
| Description | Whether JPOX should use 'SELECT ... FOR UPDATE' on all fetch operations to prevent dirty
writes. Only applies to read committed and read uncommitted transaction isolation level
and doesn't apply to Optimistic Transactions.
Please refer to the Transactions Guide |
| Range of Values | true | false |
|
org.jpox.rdbms.stringDefaultLength
|
|---|
| Description | The default (max) length to use for all strings that don't have their column length defined
in MetaData. |
| Range of Values | 256 (JDO) | 255 (JPA) | A valid length |
|
org.jpox.rdbms.stringLengthExceededAction
|
|---|
| Description | Defines what happens when persisting a String field and its length exceeds the length of the
underlying datastore column. The default is to throw an Exception. The other option is to
truncate the String to the length of the datastore column. |
| Range of Values | EXCEPTION | TRUNCATE |
|
org.jpox.rdbms.persistEmptyStringAsNull
|
|---|
| Description | When persisting en empty string, should it be persisted as null in the datastore.
This is to allow for datastores (Oracle) that dont differentiate between null
and empty string. If it is set to false and the datastore doesnt differentiate then
a special character will be saved when storing an empty string. |
| Range of Values | true | false |
|
org.jpox.rdbms.sql.allowAllSQLStatements
|
|---|
| Description | javax.jdo.query.SQL queries are allowed by JDO 2 only to run SELECT queries.
This extension permits to bypass this limitation (so for example can execute stored procedures). |
| Range of Values | false | true |
|
org.jpox.rdbms.query.fetchDirection
|
|---|
| Description | The direction in which the query results will be navigated. |
| Range of Values | forward | reverse | unknown |
|
org.jpox.rdbms.query.resultSetType
|
|---|
| Description | Type of ResultSet to create. Not all JDBC drivers accept all options. The values correspond
directly to the ResultSet options. |
| Range of Values | forward-only | scroll-sensitive | scroll-insensitive |
|
org.jpox.rdbms.query.resultSetConcurrency
|
|---|
| Description | Whether the ResultSet is readonly or can be updated. Not all JDBC drivers support all options.
The values correspond directly to the ResultSet options. |
| Range of Values | read-only | updateable |
|
org.jpox.rdbms.jdoql.joinType
|
|---|
| Description | When running a JDOQL query, this defines what type of joins JPOX should try to use
overriding the natural choice for the query. In some situations the user may know that
it should use "INNER", or "LEFT OUTER" joins only. |
| Range of Values | INNER | LEFT OUTER |
|
org.jpox.rdbms.jdoql.existsIncludesConstraints
|
|---|
| Description | When a JDOQL query has a "contains" clause this will be replaced by an EXISTS
sub-query. This property defines whether all other clauses should be applied
to this sub-query, instead of the parent query. In some cases this will lead
to inefficient queries. |
| Range of Values | true | false |
|
org.jpox.rdbms.oracleNlsSortOrder
|
|---|
| Description | Sort order for Oracle String fields in queries (BINARY disables native language sorting) |
| Range of Values | LATIN | See Oracle documentation |
|
org.jpox.rdbms.schemaTable.tableName
|
|---|
| Description | Name of the schema table when using "SchemaTable" auto start mechanism.
Please refer to the AutoStart Mechanism guide |
| Range of Values | JPOX_TABLES | valid table name |
