net.sf.hajdbc.dialect.oracle

Class OracleDialect

java.lang.Object

net.sf.hajdbc.dialect.StandardDialect

net.sf.hajdbc.dialect.oracle.OracleDialect

All Implemented Interfaces:

Dialect, IdentityColumnSupport, SequenceSupport, TriggerSupport

public class OracleDialect
extends StandardDialect

Dialect for Oracle (commercial).

Author:

Paul Ferraro

Nested Class Summary

Nested classes/interfaces inherited from interface net.sf.hajdbc.TriggerSupport

TriggerSupport.TriggerEventEnum, TriggerSupport.TriggerTimeEnum

Field Summary

Fields inherited from class net.sf.hajdbc.dialect.StandardDialect

SQL_2003_RESERVED_KEY_WORDS

Constructor Summary

Constructors

Constructor and Description
OracleDialect()

Method Summary

Methods

Modifier and Type	Method and Description
protected String	alterSequenceFormat()
protected String	createForeignKeyConstraintFormat() ON UPDATE and deferrability clauses are not supported.
protected String	dummyTable()
Collection<SequenceProperties>	getSequences(DatabaseMetaData metaData, SequencePropertiesFactory factory) Returns a collection of sequences using dialect specific logic.
SequenceSupport	getSequenceSupport()
protected boolean	indicatesFailure(String sqlState) Indicates whether the specified SQLState indicates a database failure that should result in a database deactivation.
protected String	nextSequenceValueFormat()
protected String	schemaPattern(DatabaseMetaData metaData)
protected String	sequencePattern()
protected String	truncateTableFormat()
protected String	vendorPattern()

Methods inherited from class net.sf.hajdbc.dialect.StandardDialect

alterIdentityColumnFormat, createColumnPropertiesFactory, createForeignKeyConstraintFactory, createIdentifierNormalizer, createQualifiedNameFactory, createSchemaFormat, createSequencePropertiesFactory, createTriggerFormat, createUniqueConstraintFactory, createUniqueConstraintFormat, currentDatePattern, currentTimePattern, currentTimestampPattern, dateLiteralFormat, dropConstraintFormat, dropForeignKeyConstraintFormat, dropSchemaFormat, dropTriggerFormat, dropUniqueConstraintFormat, evaluateCurrentDate, evaluateCurrentTime, evaluateCurrentTimestamp, evaluateRand, executeFunction, executeFunctionFormat, executeFunctionSQL, executeQuery, failureXAErrorCodes, getAlterIdentityColumnSQL, getAlterSequenceSQL, getColumns, getColumnType, getConnectionProperties, getCreateForeignKeyConstraintSQL, getCreateSchemaSQL, getCreateTriggerSQL, getCreateUniqueConstraintSQL, getDefaultSchemas, getDropForeignKeyConstraintSQL, getDropSchemaSQL, getDropTriggerSQL, getDropUniqueConstraintSQL, getDumpRestoreSupport, getForeignKeyConstraints, getIdentityColumns, getIdentityColumnSupport, getNextSequenceValueSQL, getPrimaryKey, getTables, getTriggerRowAlias, getTriggerSupport, getTruncateTableSQL, getTypes, getUniqueConstraints, identifierPattern, indicatesFailure, indicatesFailure, indicatesFailure, insertIntoTablePattern, isSelectForUpdate, isValid, locatorPattern, meetsRequirement, parse, parseInsertTable, parseSequence, randomPattern, reservedIdentifiers, selectForUpdatePattern, sequenceTableType, timeLiteralFormat, timestampLiteralFormat

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleDialect

public OracleDialect()

Method Detail

vendorPattern

protected String vendorPattern()

Overrides:

vendorPattern in class StandardDialect

See Also:

StandardDialect.vendorPattern()

dummyTable

protected String dummyTable()

Overrides:

dummyTable in class StandardDialect

See Also:

StandardDialect.dummyTable()

getSequenceSupport

public SequenceSupport getSequenceSupport()

Specified by:

getSequenceSupport in interface Dialect

Overrides:

getSequenceSupport in class StandardDialect

See Also:

StandardDialect.getSequenceSupport()

getSequences

public Collection<SequenceProperties> getSequences(DatabaseMetaData metaData,
                                          SequencePropertiesFactory factory)
                                            throws SQLException

Description copied from class: StandardDialect

Returns a collection of sequences using dialect specific logic.

Specified by:

getSequences in interface SequenceSupport

Overrides:

getSequences in class StandardDialect

Parameters:

metaData - database meta data

Returns:

a collection of sequences

Throws:

SQLException

See Also:

SequenceSupport.getSequences(java.sql.DatabaseMetaData, net.sf.hajdbc.SequencePropertiesFactory)

schemaPattern

protected String schemaPattern(DatabaseMetaData metaData)
                        throws SQLException

Overrides:

schemaPattern in class StandardDialect

Throws:

SQLException

truncateTableFormat

protected String truncateTableFormat()

Overrides:

truncateTableFormat in class StandardDialect

See Also:

StandardDialect.truncateTableFormat()

createForeignKeyConstraintFormat

protected String createForeignKeyConstraintFormat()

ON UPDATE and deferrability clauses are not supported.

Overrides:

createForeignKeyConstraintFormat in class StandardDialect

See Also:

StandardDialect.createForeignKeyConstraintFormat()

sequencePattern

protected String sequencePattern()

Overrides:

sequencePattern in class StandardDialect

See Also:

StandardDialect.sequencePattern()

nextSequenceValueFormat

protected String nextSequenceValueFormat()

Overrides:

nextSequenceValueFormat in class StandardDialect

See Also:

StandardDialect.nextSequenceValueFormat()

alterSequenceFormat

protected String alterSequenceFormat()

Overrides:

alterSequenceFormat in class StandardDialect

See Also:

StandardDialect.alterSequenceFormat()

indicatesFailure

protected boolean indicatesFailure(String sqlState)

Description copied from class: StandardDialect

Indicates whether the specified SQLState indicates a database failure that should result in a database deactivation.

Overrides:

indicatesFailure in class StandardDialect

Parameters:

sqlState - a SQL:2003 or X/Open SQLState

Returns:

true if the SQLState indicate a failure, false otherwise