org.fastnate.generator.dialect

Class OracleDialect

java.lang.Object

org.fastnate.generator.dialect.GeneratorDialect

org.fastnate.generator.dialect.OracleDialect

public class OracleDialect
extends GeneratorDialect

Handles Oracle specific conversions.

Author:

Tobias Liefke

See Also:

Oracle - Documentation

Field Summary

Fields

Modifier and Type	Field and Description
private static int	MAX_VARCHAR_LENGTH

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
void	adjustNextSequenceValue(StatementsWriter writer, 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, boolean firstCall) 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.
protected String	createAddDateExpression(String referenceDate, long value, String unit) Creates an SQL expression to add a value to a date.
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	isFastInTransaction() Indicates that the database usually faster when all statements are executed within an transaction.
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, convertNumberValue, convertTemporalValue, convertToDatabaseDate, createHexBlobExpression, getAutoGenerationType, getConcatOperator, getEmptyValuesExpression, getLetter, isEmulatingSequences, isNextSequenceValueInInsertSupported, isSelectFromSameTableInInsertSupported, isSequenceSupported, isSettingIdentityAllowed, truncateTable

Methods inherited from class java.lang.Object

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

Field Detail

MAX_VARCHAR_LENGTH

private static final int MAX_VARCHAR_LENGTH

See Also:

Constant Field Values

Constructor Detail

OracleDialect

public OracleDialect()

Method Detail

adjustNextSequenceValue

public void adjustNextSequenceValue(StatementsWriter writer,
                                    String sequenceName,
                                    long currentSequenceValue,
                                    long nextSequenceValue,
                                    int incrementSize)
                             throws IOException

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:

writer - the target of the generated statements

sequenceName - the fully qualified 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

Throws:

IOException - if the writer throws one

buildCurrentSequenceValue

public String buildCurrentSequenceValue(String sequence,
                                        int incrementSize,
                                        boolean firstCall)

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 fully qualified 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

firstCall - indicates that the sequence was not updated before in this session - we may need to use a different approach to get the current value

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 fully qualified 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.

createAddDateExpression

protected String createAddDateExpression(String referenceDate,
                                         long value,
                                         String unit)

Description copied from class: GeneratorDialect

Creates an SQL expression to add a value to a date.

Overrides:

createAddDateExpression in class GeneratorDialect

Parameters:

referenceDate - the expression for the reference date

value - the value to add to the date

unit - the unit of the value

Returns:

the SQL expression that adds 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

isFastInTransaction

public boolean isFastInTransaction()

Description copied from class: GeneratorDialect

Indicates that the database usually faster when all statements are executed within an transaction. For example Oracle is approx. 25% faster but H2 is 200% slower compared to auto commit. Only relevant if executed against a running database.

Overrides:

isFastInTransaction in class GeneratorDialect

Returns:

true if an transaction is faster than auto commit

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