Module org.seasar.doma.core

Package org.seasar.doma.jdbc.dialect

Class OracleDialect

java.lang.Object

org.seasar.doma.jdbc.dialect.StandardDialect

org.seasar.doma.jdbc.dialect.Oracle11Dialect

org.seasar.doma.jdbc.dialect.OracleDialect

All Implemented Interfaces:

Dialect

public class OracleDialect
extends Oracle11Dialect

A dialect for Oracle Database.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	OracleDialect.OracleExpressionFunctions
static class	OracleDialect.OracleJdbcMappingVisitor
static class	OracleDialect.OracleScriptBlockContext
static class	OracleDialect.OracleSqlLogFormattingVisitor

Nested classes/interfaces inherited from class org.seasar.doma.jdbc.dialect.Oracle11Dialect

Oracle11Dialect.Oracle11CriteriaBuilder, Oracle11Dialect.Oracle11ExpressionFunctions, Oracle11Dialect.Oracle11JdbcMappingVisitor, Oracle11Dialect.Oracle11ScriptBlockContext, Oracle11Dialect.Oracle11SqlLogFormattingVisitor, Oracle11Dialect.OracleResultSetType

Nested classes/interfaces inherited from class org.seasar.doma.jdbc.dialect.StandardDialect

StandardDialect.StandardCriteriaBuilder, StandardDialect.StandardExpressionFunctions, StandardDialect.StandardJdbcMappingVisitor, StandardDialect.StandardScriptBlockContext, StandardDialect.StandardSqlLogFormattingVisitor

Field Summary

Fields inherited from class org.seasar.doma.jdbc.dialect.Oracle11Dialect

RESULT_SET, UNIQUE_CONSTRAINT_VIOLATION_ERROR_CODE

Fields inherited from class org.seasar.doma.jdbc.dialect.StandardDialect

CLOSE_QUOTE, expressionFunctions, jdbcMappingVisitor, OPEN_QUOTE, sqlLogFormattingVisitor, UNIQUE_CONSTRAINT_VIOLATION_STATE_CODES

Constructor Summary

Constructors

Constructor	Description
OracleDialect()
OracleDialect(ExpressionFunctions expressionFunctions)
OracleDialect(JdbcMappingVisitor jdbcMappingVisitor)
OracleDialect(JdbcMappingVisitor jdbcMappingVisitor, SqlLogFormattingVisitor sqlLogFormattingVisitor)
OracleDialect(JdbcMappingVisitor jdbcMappingVisitor, SqlLogFormattingVisitor sqlLogFormattingVisitor, ExpressionFunctions expressionFunctions)
OracleDialect(SqlLogFormattingVisitor sqlLogFormattingVisitor)

Method Summary

Modifier and Type	Method	Description
AutoGeneratedKeysType	getAutoGeneratedKeysType()	Returns the type of the auto generated keys.
<ENTITY> MultiInsertAssembler	getMultiInsertAssembler(MultiInsertAssemblerContext<ENTITY> context)	Provides an implementation of MultiInsertAssembler based on the given context.
UpsertAssembler	getUpsertAssembler(UpsertAssemblerContext context)	Returns the UpsertAssembler implementation for the given context.
boolean	supportsAutoGeneratedKeys()	Determines whether this dialect supports retrieving auto-generated keys via Statement.getGeneratedKeys().
boolean	supportsIdentity()	Determines whether this dialect supports the IDENTITY column.
boolean	supportsMultiRowInsertStatement()	Determines whether this dialect supports multi-row insert statements (bulk inserts).
boolean	supportsReturning()	Determines if this dialect supports the SQL RETURNING clause in database operations.
boolean	supportsUpsertEmulationWithMergeStatement()	Determines whether this dialect supports upsert emulation using MERGE statements.

Methods inherited from class org.seasar.doma.jdbc.dialect.Oracle11Dialect

createScriptBlockContext, getCriteriaBuilder, getName, getResultSetType, getScriptBlockDelimiter, getSequenceNextValSql, isUniqueConstraintViolated, supportsAutoIncrementWhenInsertingMultipleRows, supportsBatchUpdateResults, supportsModOperator, supportsResultSetReturningAsOutParameter, supportsSelectForUpdate, supportsSequence, toForUpdateSqlNode, toPagingSqlNode

Methods inherited from class org.seasar.doma.jdbc.dialect.StandardDialect

applyQuote, getCauseSQLException, getDeleteAssembler, getErrorCode, getExpressionFunctions, getIdentityReservationSql, getIdentitySelectSql, getInsertAssembler, getJdbcMappingVisitor, getRootCause, getSqlLogFormattingVisitor, getSQLState, getUpdateAssembler, includesIdentityColumn, removeQuote, supportsIdentityReservation, toCountCalculatingSqlNode, toCountGettingSqlNode, transformSelectSqlNode, transformSelectSqlNodeForGettingCount

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.seasar.doma.jdbc.dialect.Dialect

includesIdentityColumn, supportsAliasInDeleteClause, supportsAliasInDeleteStatement, supportsAliasInUpdateClause, supportsAliasInUpdateStatement, supportsBatchExecutionReturningGeneratedValues, supportsParenthesesForSetOperands

Constructor Details

OracleDialect

public OracleDialect()

OracleDialect

public OracleDialect(JdbcMappingVisitor jdbcMappingVisitor)

OracleDialect

public OracleDialect(SqlLogFormattingVisitor sqlLogFormattingVisitor)

OracleDialect

public OracleDialect(ExpressionFunctions expressionFunctions)

OracleDialect

public OracleDialect(JdbcMappingVisitor jdbcMappingVisitor,
 SqlLogFormattingVisitor sqlLogFormattingVisitor)

OracleDialect

public OracleDialect(JdbcMappingVisitor jdbcMappingVisitor,
 SqlLogFormattingVisitor sqlLogFormattingVisitor,
 ExpressionFunctions expressionFunctions)

Method Details

supportsIdentity

public boolean supportsIdentity()

Description copied from interface: Dialect

Determines whether this dialect supports the IDENTITY column.

An IDENTITY column is a column that automatically generates a unique value for each row when data is inserted. The exact implementation varies by database system.

Specified by:

supportsIdentity in interface Dialect

Overrides:

supportsIdentity in class Oracle11Dialect

Returns:

true if this dialect supports IDENTITY columns, false otherwise

supportsAutoGeneratedKeys

public boolean supportsAutoGeneratedKeys()

Description copied from interface: Dialect

Determines whether this dialect supports retrieving auto-generated keys via Statement.getGeneratedKeys().

This feature allows retrieving values that were automatically generated during an insert operation, such as identity column values, without executing a separate query.

Specified by:

supportsAutoGeneratedKeys in interface Dialect

Overrides:

supportsAutoGeneratedKeys in class StandardDialect

Returns:

true if this dialect supports retrieving auto-generated keys, false otherwise

supportsMultiRowInsertStatement

public boolean supportsMultiRowInsertStatement()

Description copied from interface: Dialect

Determines whether this dialect supports multi-row insert statements (bulk inserts).

Multi-row insert statements allow inserting multiple rows in a single SQL statement, which can significantly improve performance when inserting large amounts of data.

The default implementation returns true.

Specified by:

supportsMultiRowInsertStatement in interface Dialect

Overrides:

supportsMultiRowInsertStatement in class Oracle11Dialect

Returns:

true if this dialect supports multi-row insert statements, false otherwise

supportsUpsertEmulationWithMergeStatement

public boolean supportsUpsertEmulationWithMergeStatement()

Description copied from interface: Dialect

Determines whether this dialect supports upsert emulation using MERGE statements.

An upsert operation (update or insert) can be emulated using MERGE statements in some database systems. This method indicates whether the dialect supports this approach.

The default implementation returns false.

Returns:

true if this dialect supports upsert emulation with MERGE statements, false otherwise

getAutoGeneratedKeysType

public AutoGeneratedKeysType getAutoGeneratedKeysType()

Description copied from interface: Dialect

Returns the type of the auto generated keys.

Specified by:

getAutoGeneratedKeysType in interface Dialect

Overrides:

getAutoGeneratedKeysType in class StandardDialect

Returns:

the type of the auto generated keys

getUpsertAssembler

public UpsertAssembler getUpsertAssembler(UpsertAssemblerContext context)

Description copied from interface: Dialect

Returns the UpsertAssembler implementation for the given context.

Specified by:

getUpsertAssembler in interface Dialect

Overrides:

getUpsertAssembler in class StandardDialect

Parameters:

context - the UpsertAssemblerContext object

Returns:

the UpsertAssembler object for the given context

getMultiInsertAssembler

public <ENTITY> MultiInsertAssembler getMultiInsertAssembler(MultiInsertAssemblerContext<ENTITY> context)

Description copied from interface: Dialect

Provides an implementation of MultiInsertAssembler based on the given context.

Specified by:

getMultiInsertAssembler in interface Dialect

Overrides:

getMultiInsertAssembler in class StandardDialect

Type Parameters:

ENTITY - the type of the entity to be handled by the assembler

Parameters:

context - the context that holds the information required to create the MultiInsertAssembler

Returns:

an instance of MultiInsertAssembler specific to the provided entity context

supportsReturning

public boolean supportsReturning()

Description copied from interface: Dialect

Determines if this dialect supports the SQL RETURNING clause in database operations.

The RETURNING clause allows a DML statement (INSERT, UPDATE, DELETE) to return data from rows that were affected by the operation. This feature is particularly useful for retrieving auto-generated values or updated columns in a single database operation, without requiring a separate SELECT statement.

The default implementation returns true, but dialect implementations for databases that don't support this feature should override this method to return false.

Returns:

true if the RETURNING clause is supported by this dialect, false otherwise