public Class DatabasePlatform

INTERNAL: This gets called on each iteration to add parameters to the batch Needs to be implemented so that it returns the number of rows successfully modified by this statement for optimistic locking purposes (if useNativeBatchWriting is enabled, and the call uses optimistic locking).

INTERNAL: In case shouldBindLiterals is true, instead of null value a DatabaseField value may be passed (so that it's type could be used for binding null).

Returns the number of parameters that used binding.

Used by JDBC drivers that do not support autocommit so simulate an autocommit.

INTERNAL: Return the selection criteria used to IN batch fetching.

INTERNAL Returns null unless the platform supports call with returning

INTERNAL: Don't override this method.

INTERNAL: Don't override this method.

INTERNAL: Returns sql used to alter sequence object's increment in the database.

INTERNAL: Returns sql used to delete sequence object from the database.

INTERNAL Indicates whether the platform can build call with returning.

Used for jdbc drivers which do not support autocommit to explicitly commit a transaction This method is a no-op for databases which implement autocommit as expected.

INTERNAL We support more primitive than JDBC does so we must do conversion before printing or binding.

INTERNAL: This method builds an Array using the unwrapped connection within the session

INTERNAL: This method builds a Struct using the unwrapped connection within the session

INTERNAL: May need to override this method if the sql generated for UpdateAllQuery using temp tables fails in case parameter binding is used.

because each platform has different requirements for accessing stored procedures and the way that we can combine resultsets and output params, the stored procedure call is being executed on the platform.

Used for stored function calls.

Used for batch writing and sp defs.

Used for batch writing for row count return.

Used for batch writing for row count return.

ADVANCED: Get the maximum length allowed by the database for a Varchar Parameter This is used by subclasses when writing SQL for parameters

INTERNAL: This method is used to unwrap the oracle connection wrapped by the application server.

Used for constraint deletion.

This method is used to print the required output parameter token for the specific platform.

ADVANCED: Return the code for preparing cursored output parameters in a stored procedure

Returns the table name used by TableSequence by default.

Allows DROP TABLE to cascade dropping of any dependent constraints if the database supports this option.

Return the field type object describing this databases platform specific representation of the Java primitive class name.

Used for stored function calls.

This method is used to print the output parameter token when stored procedures are called

Returns the JDBC outer join operator for SELECT statements.

Return the JDBC type for the Java type.

INTERNAL: Returns the type name corresponding to the jdbc type

PUBLIC: Allow for the max batch writing size to be set.

INTERNAL: returns the maximum number of characters that can be used in a foreign key name on this platform.

INTERNAL: returns the maximum number of characters that can be used in a unique key name on this platform.

INTERNAL: Get the object from the JDBC Result set.

INTERNAL Get the parameter from the JDBC statement with the given index.

Return callback.

Obtain the platform specific argument string

Used for stored procedure defs.

Used for sp calls.

Used for stored procedure defs.

INTERNAL: Platforms that support java.sql.Ref may override this method.

This syntax does no wait on the lock.

Most database support a syntax.

Overrides org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform.getSequencePreallocationSize.

The statement cache size for prepare parameterized statements.

Returns the delimiter between stored procedures in multiple stored procedure calls.

INTERNAL: Get the map of StructConverters that will be used to preprocess STRUCT data as it is read

Returns the transaction isolation setting for a connection.

Used for constraint deletion.

Any platform that supports VPD should implement this method.

Any platform that supports VPD should implement this method.

Any platform that supports VPD should implement this method.

Overrides org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform.initialize.

Implements org.eclipse.persistence.internal.databaseaccess.Platform.initialize.

INTERNAL: Override this method if the platform supports sequence objects and it's possible to alter sequence object's increment in the database.

INTERNAL: Some databases have issues with using parameters on certain functions and relations.

Some database require outer joins to be given in the where clause, others require it in the from clause.

INTERNAL: Indicates whether SELECT DISTINCT lob FROM ...

INTERNAL: Override this if the platform cannot handle NULL in select clause.

Return if the platform does not maintain the row count on batch executes and requires an output parameter to maintain the row count.

Builds a table of maximum numeric values keyed on java class.

INTERNAL: Returns the minimum time increment supported by the platform.

Append the receiver's field 'identity' constraint clause to a writer.

Append the receiver's field 'NULL' constraint clause to a writer.

INTERNAL: Prints return keyword for StoredFunctionDefinition: CREATE FUNCTION StoredFunction_In (P_IN BIGINT) RETURN BIGINT The method was introduced because MySQL requires "RETURNS" instead: CREATE FUNCTION StoredFunction_In (P_IN BIGINT) RETURNS BIGINT

This method is used to register output parameter on CallableStatements for Stored Procedures as each database seems to have a different method.

This method is used to register output parameter on CallableStatements for Stored Procedures as each database seems to have a different method.

Used for stored procedure creation: Some platforms need brackets around arguments declaration even if no arguments exist.

Used for sp calls.

INTERNAL: Indicates whether the version of CallableStatement.registerOutputParameter method that takes type name should be used.

INTERNAL: Used by Exists queries because they just need to select a single row.

Set the custom batch writing mechanism.

During auto-detect, the driver name is set on the platform.

PUBLIC: Allow for the max batch writing size to be set.

INTERNAL Set the parameter in the JDBC statement with the given name.

Used for determining if an SQL exception was communication based.

PUBLIC: Changes the way that OuterJoins are done on the database.

Bind all arguments to any SQL statement.

Used to enable parameter binding and override the platform default

Used for table creation.

Can be used if the app expects upper case but the database is not return consistent case, i.e. different databases.

PUBLIC: Set if our driver level data conversion optimization is enabled.

PUBLIC: Set if SQL-Level pagination should be used for FirstResult and MaxRows settings.

supportsAutoCommit can be set to false for JDBC drivers which do not support autocommit.

Set the transaction isolation setting for a connection.

Advanced: This is used to enable native batch writing on drivers that support it.

INTERNAL: That method affects UpdateAllQuery and DeleteAllQuery execution.

PUBLIC: Allows platform to choose whether to bind literals in DatabaseCalls or not.

Cache all prepared statements, this requires full parameter binding as well.

Used for table creation.

Used to enable parameter binding and override platform default

Allow for case in field names to be ignored as some databases are not case sensitive and when using custom this can be an issue.

Return if our driver level data conversion optimization is enabled.

Some Platforms want the constraint name after the constraint definition.

This is required in the construction of the stored procedures with output parameters

INTERNAL: Indicates whether locking clause should be printed after where clause by SQLSelectStatement.

This is required in the construction of the stored procedures with output parameters

INTERNAL: Should the variable name of a stored procedure call be printed as part of the procedure call e.g. EXECUTE PROCEDURE MyStoredProc(myvariable = ?)

Overrides org.eclipse.persistence.internal.databaseaccess.DatasourcePlatform.shouldUseCustomModifyForCall.

Implements org.eclipse.persistence.internal.databaseaccess.Platform.shouldUseCustomModifyForCall.

JDBC defines and outer join syntax, many drivers do not support this.

Indicates whether the ANSI syntax for inner joins (e.g. SELECT FROM t1 JOIN t2 ON t1.pk = t2.fk) is supported by this platform.

Some db allow VARCHAR db field to be used in arithmetic operations automatically converting them to numeric: UPDATE OL_PHONE SET PHONE_ORDER_VARCHAR = (PHONE_ORDER_VARCHAR + 1) WHERE ...

INTERNAL: Indicates whether the platform supports the count distinct function with multiple fields.

INTERNAL: Return if this database support index creation.

INTERNAL: Indicates whether the platform supports local temporary tables.

INTERNAL: Return if nesting outer joins is supported, i.e. each join must be followed by the ON clause.

INTERNAL: Return if brackets can be used in the ON clause for outer joins.

Allows unique columns to be defined as constraint if the UNIQUE keyword is not support on a column defintion.

By default, platforms do not support VPD.

Some JDBC 2 drivers to not support batching, so this lets are own batching be used.

INTERNAL: Don't override this method.

INTERNAL: Write an sql string for deletion from target table using temporary table.

INTERNAL: May need to override this method if the platform supports temporary tables and the generated sql doesn't work.

INTERNAL: Write LOB value - only on Oracle8 and up

INTERNAL: Write used on all table creation statements generated from the DefaultTableGenerator with a session using this project (DDL generation).