org.fastnate.generator.dialect

Class OracleDialect

java.lang.Object

org.fastnate.generator.dialect.GeneratorDialect

org.fastnate.generator.dialect.OracleDialect

public final class OracleDialect
extends GeneratorDialect

Handles Oracle specific conversions.

Author:

Tobias Liefke

See Also:

Oracle - Documentation

Field Summary

Fields inherited from class org.fastnate.generator.dialect.GeneratorDialect

NOW

Constructor Summary

Constructors

Constructor and Description
OracleDialect()

Method Summary

Modifier and Type	Method and Description
List<? extends EntityStatement>	adjustNextSequenceValue(String sequenceName, long currentSequenceValue, long nextSequenceValue, int incrementSize) Adjusts the given sequence to ensure that the next value is exactly the given value.
String	buildCurrentSequenceValue(String sequence, int incrementSize) Builds the SQL expression that is used for referencing the current value of the given sequence.
String	buildNextSequenceValue(String sequence, int incrementSize) Builds the SQL expression resp. statement that is used for creating the next value of the given sequence.
String	convertTemporalValue(Date value, javax.persistence.TemporalType type) Converts a date to an appropriate SQL expression.
String	createBlobExpression(byte[] blob) Converts the given byte array to an SQL expression for the current database.
String	getOptionalTable() Returns the string to use when no table is required, e.g. for "SELECT 1, 2 FROM DUAL" this would return "FROM DUAL".
boolean	isEmptyStringEqualToNull() Indicates that the empty string is equal to null in this database.
boolean	isIdentitySupported() Indicates that identity columns are supported by the database.
boolean	isSequenceInWhereSupported() Indicates that references to sequences in WHERE expressions are supported.
String	quoteString(String value) Quotes the given string.

Methods inherited from class org.fastnate.generator.dialect.GeneratorDialect

addQuotedCharacter, adjustNextIdentityValue, convertBooleanValue, createHexBlobExpression, createSql, getAutoGenerationType, isNextSequenceValueInInsertSupported, isSequenceSupported

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

adjustNextSequenceValue

public List<? extends EntityStatement> adjustNextSequenceValue(String sequenceName,
                                                               long currentSequenceValue,
                                                               long nextSequenceValue,
                                                               int incrementSize)

Description copied from class: GeneratorDialect

Adjusts the given sequence to ensure that the next value is exactly the given value.

Overrides:

adjustNextSequenceValue in class GeneratorDialect

Parameters:

sequenceName - the name of the sequence

currentSequenceValue - the current value of the sequence

nextSequenceValue - the next value of the sequence

incrementSize - the increment size of the sequence

Returns:

all statements necessary to adjust the sequence

buildCurrentSequenceValue

public String buildCurrentSequenceValue(String sequence,
                                        int incrementSize)

Description copied from class: GeneratorDialect

Builds the SQL expression that is used for referencing the current value of the given sequence.

Overrides:

buildCurrentSequenceValue in class GeneratorDialect

Parameters:

sequence - the name of the sequence

incrementSize - the expected incrementSize, as given in the schema - used by some dialects to ensure that exactly that inrement is used

Returns:

the SQL expression to use in statement

buildNextSequenceValue

public String buildNextSequenceValue(String sequence,
                                     int incrementSize)

Description copied from class: GeneratorDialect

Builds the SQL expression resp. statement that is used for creating the next value of the given sequence. Depending on GeneratorDialect.isNextSequenceValueInInsertSupported() this will return an expression or a statement.

Overrides:

buildNextSequenceValue in class GeneratorDialect

Parameters:

sequence - the name of the sequence

incrementSize - the expected incrementSize, as given in the schema - used by some dialects to ensure that exactly that inrement is used

Returns:

the SQL to use in resp. before the insert / update statement

convertTemporalValue

public String convertTemporalValue(Date value,
                                   javax.persistence.TemporalType type)

Description copied from class: GeneratorDialect

Converts a date to an appropriate SQL expression.

Overrides:

convertTemporalValue in class GeneratorDialect

Parameters:

value - the timestamp value

type - the type

Returns:

SQL expression representing the value.

createBlobExpression

public String createBlobExpression(byte[] blob)

Description copied from class: GeneratorDialect

Converts the given byte array to an SQL expression for the current database.

Overrides:

createBlobExpression in class GeneratorDialect

Parameters:

blob - the bytes to convert

Returns:

the expression for the bytes

getOptionalTable

public String getOptionalTable()

Description copied from class: GeneratorDialect

Returns the string to use when no table is required, e.g. for "SELECT 1, 2 FROM DUAL" this would return "FROM DUAL".

Overrides:

getOptionalTable in class GeneratorDialect

Returns:

the SQL to use in "SELECT x [OPTIONALTABLE] WHERE ..."

isEmptyStringEqualToNull

public boolean isEmptyStringEqualToNull()

Description copied from class: GeneratorDialect

Indicates that the empty string is equal to null in this database. Important for NotNull constraints, where an empty string would result in the same constraint violation.

Overrides:

isEmptyStringEqualToNull in class GeneratorDialect

Returns:

true if this database assumes that an empty string is the same as null

isIdentitySupported

public boolean isIdentitySupported()

Description copied from class: GeneratorDialect

Indicates that identity columns are supported by the database.

Overrides:

isIdentitySupported in class GeneratorDialect

Returns:

true if the database supports identities

isSequenceInWhereSupported

public boolean isSequenceInWhereSupported()

Description copied from class: GeneratorDialect

Indicates that references to sequences in WHERE expressions are supported.

Overrides:

isSequenceInWhereSupported in class GeneratorDialect

Returns:

true if this database supports sequences in WHERE expressions

quoteString

public String quoteString(String value)

Description copied from class: GeneratorDialect

Quotes the given string.

Overrides:

quoteString in class GeneratorDialect

Parameters:

value - the value to quote

Returns:

the quoted string