oracle.toplink.essentials.platform.database

Class TimesTenPlatform

java.lang.Object

oracle.toplink.essentials.internal.databaseaccess.DatasourcePlatform

oracle.toplink.essentials.internal.databaseaccess.DatabasePlatform

oracle.toplink.essentials.platform.database.DatabasePlatform

oracle.toplink.essentials.platform.database.TimesTenPlatform

All Implemented Interfaces:

java.io.Serializable, java.lang.Cloneable, Platform

public class TimesTenPlatform
extends DatabasePlatform

See Also:

Serialized Form

Field Summary

Fields inherited from class oracle.toplink.essentials.internal.databaseaccess.DatabasePlatform

classTypes, cursorCode, fieldTypes, shouldBindAllParameters, shouldCacheAllStatements, shouldForceFieldNamesToUpperCase, shouldIgnoreCaseOnFieldComparisons, shouldOptimizeDataConversion, shouldTrimStrings, statementCacheSize, stringBindingSize, supportsAutoCommit, transactionIsolation, usesByteArrayBinding, usesNativeSQL, usesStreamsForBinding, usesStringBinding

Fields inherited from class oracle.toplink.essentials.internal.databaseaccess.DatasourcePlatform

conversionManager, dataTypesConvertedFromAClass, dataTypesConvertedToAClass, defaultSequence, platformOperators, sequences, tableQualifier, timestampQuery

Constructor Summary

Constructors

Constructor and Description
TimesTenPlatform()

Method Summary

Modifier and Type	Method and Description
protected void	appendByteArray(byte[] bytes, java.io.Writer writer) If using native SQL then print a byte[] literally as a hex string otherwise use ODBC format as provided in DatabasePlatform.
protected void	appendCalendar(java.util.Calendar calendar, java.io.Writer writer) Appends an MySQL specific Timestamp, if usesNativeSQL is true otherwise use the ODBC format.
protected void	appendDate(java.sql.Date date, java.io.Writer writer) Appends an MySQL specific date if usesNativeSQL is true otherwise use the ODBC format.
protected void	appendTime(java.sql.Time time, java.io.Writer writer) Appends an MySQL specific time if usesNativeSQL is true otherwise use the ODBC format.
protected void	appendTimestamp(java.sql.Timestamp timestamp, java.io.Writer writer) Appends an MySQL specific Timestamp, if usesNativeSQL is true otherwise use the ODBC format.
protected java.util.Hashtable	buildFieldTypes() Return the mapping of class types to database types for the schema framework.
ValueReadQuery	buildSelectQueryForNativeSequence(java.lang.String seqName, java.lang.Integer size) INTERNAL: Produce a DataReadQuery which updates(!) the sequence number in the db and returns it.
java.lang.String	getCreateViewString() INTERNAL: Used for view creation.
protected java.lang.String	getQualifiedSequenceName(java.lang.String seqName) Prepend sequence name with table qualifier (if any)
java.lang.String	getSelectForUpdateString() INTERNAL: Used for pessimistic locking.
ValueReadQuery	getTimestampQuery() PUBLIC: This method returns the query to select the timestamp from the server for TimesTen.
protected void	initializePlatformOperators() Initialize any platform-specific operators
boolean	isTimesTen() Answers whether platform is TimesTen
protected ExpressionOperator	operatorOuterJoin() Create the outer join operator for this platform
void	setSupportsForeignKeyConstraints(boolean supportsForeignKeyConstraints)
boolean	shouldPrintOuterJoinInWhereClause() Some database require outer joins to be given in the where clause, others require it in the from clause.
boolean	supportsForeignKeyConstraints()
boolean	supportsNativeSequenceNumbers() Return true if the receiver uses host sequence numbers, generated on the database.

Methods inherited from class oracle.toplink.essentials.internal.databaseaccess.DatabasePlatform

allowsSizeInProcedureArguments, appendBoolean, appendLiteralToCall, appendLiteralToCallWithBinding, appendNumber, appendParameter, appendParameterInternal, appendString, autoCommit, beginTransaction, buildCallWithReturning, buildClassTypes, buildSelectQueryForNativeSequence, canBuildCallWithReturning, commitTransaction, convertToDatabaseType, copyInto, createPlatformDefaultSequence, dontBindUpdateAllQueryUsingTempTables, executeStoredProcedure, getAssignmentString, getBatchBeginString, getBatchDelimiterString, getBatchEndString, getClassTypes, getConstraintDeletionString, getCreateTempTableSqlBodyForTable, getCreateTempTableSqlPrefix, getCreateTempTableSqlSuffix, getCreationInOutputProcedureToken, getCreationOutputProcedureToken, getCursorCode, getFieldTypeDefinition, getFieldTypes, getFunctionCallHeader, getInOutputProcedureToken, getJDBCOuterJoinString, getJDBCType, getJDBCType, getJdbcTypeName, getMaxFieldNameSize, getMaxForeignKeyNameSize, getMaxUniqueKeyNameSize, getObjectFromResultSet, getOutputProcedureToken, getProcedureArgumentSetter, getProcedureArgumentString, getProcedureAsString, getProcedureBeginString, getProcedureCallHeader, getProcedureCallTail, getProcedureEndString, getQualifiedSequenceTableName, getSelectForUpdateNoWaitString, getSelectForUpdateOfString, getSequenceCounterFieldName, getSequenceNameFieldName, getSequencePreallocationSize, getSequenceTableName, getStatementCacheSize, getStoredProcedureParameterPrefix, getStoredProcedureTerminationToken, getStringBindingSize, getTempTableForTable, getTransactionIsolation, isInformixOuterJoin, isNullAllowedInSelectClause, maximumNumericValues, minimumNumericValues, printFieldIdentityClause, printFieldIdentityClause, printFieldNotNullClause, printFieldNullClause, printFieldTypeSize, printFieldUnique, printValuelist, printValuelist, processResultSet, registerOutputParameter, requiresNamedPrimaryKeyConstraints, requiresProcedureCallBrackets, requiresProcedureCallOuputToken, requiresTypeNameToRegisterOutputParameter, rollbackTransaction, setClassTypes, setCursorCode, setFieldTypes, setParameterValueInDatabaseCall, setParameterValueInDatabaseCall, setParameterValueInDatabaseCall, setPrimitiveParameterValue, setSequenceCounterFieldName, setSequenceNameFieldName, setSequenceTableName, setShouldBindAllParameters, setShouldCacheAllStatements, setShouldForceFieldNamesToUpperCase, setShouldIgnoreCaseOnFieldComparisons, setShouldOptimizeDataConversion, setShouldTrimStrings, setStatementCacheSize, setStringBindingSize, setSupportsAutoCommit, setTransactionIsolation, setUsesByteArrayBinding, setUsesNativeSQL, setUsesStreamsForBinding, setUsesStringBinding, shouldAcquireSequenceValueAfterInsert, shouldAlwaysUseTempStorageForModifyAll, shouldBindAllParameters, shouldBindLiterals, shouldCacheAllStatements, shouldForceFieldNamesToUpperCase, shouldIgnoreCaseOnFieldComparisons, shouldIgnoreException, shouldNativeSequenceAcquireValueAfterInsert, shouldNativeSequenceUseTransaction, shouldOptimizeDataConversion, shouldPrintConstraintNameAfter, shouldPrintInOutputTokenBeforeType, shouldPrintOutputTokenAtStart, shouldPrintOutputTokenBeforeType, shouldTempTableSpecifyPrimaryKeys, shouldTrimStrings, shouldUseJDBCOuterJoinSyntax, supportsAutoCommit, supportsGlobalTempTables, supportsLocalTempTables, supportsPrimaryKeyConstraint, supportsStoredFunctions, supportsTempTables, supportsUniqueKeyConstraints, usesByteArrayBinding, usesNativeSQL, usesSequenceTable, usesStreamsForBinding, usesStringBinding, writeAutoAssignmentSetClause, writeAutoJoinWhereClause, writeCleanUpTempTableSql, writeCreateTempTableSql, writeDeleteFromTargetTableUsingTempTableSql, writeFields, writeFieldsAutoClause, writeFieldsList, writeInsertIntoTableSql, writeJoinWhereClause, writeLOB, writeParameterMarker, writeUpdateOriginalFromTempTableSql

Methods inherited from class oracle.toplink.essentials.internal.databaseaccess.DatasourcePlatform

addOperator, addSequence, clone, convertObject, createSequences, getConversionManager, getCustomModifyValueForCall, getDataTypesConvertedFrom, getDataTypesConvertedTo, getDefaultSequence, getDefaultSequenceToWrite, getOperator, getPlatformOperators, getSequence, getSequences, getSequencesToWrite, getTableQualifier, getTimestampFromServer, hasDefaultSequence, isAccess, isAttunity, isCloudscape, isDB2, isDBase, isDerby, isHSQL, isInformix, isMySQL, isODBC, isOracle, isPointBase, isPostgreSQL, isSQLAnywhere, isSQLServer, isSybase, platformSpecificSequencingInitialization, removeAllSequences, removeSequence, sequencesAfterCloneCleanup, setConversionManager, setDefaultSequence, setSequences, setTableQualifier, setTimestampQuery, shouldUseCustomModifyForCall, toString, usesPlatformDefaultSequence

Methods inherited from class java.lang.Object

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

Constructor Detail

TimesTenPlatform

public TimesTenPlatform()

Method Detail

appendByteArray

protected void appendByteArray(byte[] bytes,
                               java.io.Writer writer)
                        throws java.io.IOException

If using native SQL then print a byte[] literally as a hex string otherwise use ODBC format as provided in DatabasePlatform.

Overrides:

appendByteArray in class DatabasePlatform

Throws:

java.io.IOException

appendDate

protected void appendDate(java.sql.Date date,
                          java.io.Writer writer)
                   throws java.io.IOException

Appends an MySQL specific date if usesNativeSQL is true otherwise use the ODBC format. Native FORMAT: 'YYYY-MM-DD'

Overrides:

appendDate in class DatabasePlatform

Throws:

java.io.IOException

appendTime

protected void appendTime(java.sql.Time time,
                          java.io.Writer writer)
                   throws java.io.IOException

Appends an MySQL specific time if usesNativeSQL is true otherwise use the ODBC format. Native FORMAT: 'HH:MM:SS'.

Overrides:

appendTime in class DatabasePlatform

Throws:

java.io.IOException

appendTimestamp

protected void appendTimestamp(java.sql.Timestamp timestamp,
                               java.io.Writer writer)
                        throws java.io.IOException

Appends an MySQL specific Timestamp, if usesNativeSQL is true otherwise use the ODBC format. Native Format: 'YYYY-MM-DD HH:MM:SS'

Overrides:

appendTimestamp in class DatabasePlatform

Throws:

java.io.IOException

appendCalendar

protected void appendCalendar(java.util.Calendar calendar,
                              java.io.Writer writer)
                       throws java.io.IOException

Appends an MySQL specific Timestamp, if usesNativeSQL is true otherwise use the ODBC format. Native Format: 'YYYY-MM-DD HH:MM:SS'

Overrides:

appendCalendar in class DatabasePlatform

Throws:

java.io.IOException

buildFieldTypes

protected java.util.Hashtable buildFieldTypes()

Return the mapping of class types to database types for the schema framework.

Overrides:

buildFieldTypes in class DatabasePlatform

buildSelectQueryForNativeSequence

public ValueReadQuery buildSelectQueryForNativeSequence(java.lang.String seqName,
                                                        java.lang.Integer size)

INTERNAL: Produce a DataReadQuery which updates(!) the sequence number in the db and returns it.

Overrides:

buildSelectQueryForNativeSequence in class DatabasePlatform

Parameters:

sequenceName - Name known by TimesTen to be a defined sequence

getCreateViewString

public java.lang.String getCreateViewString()

INTERNAL: Used for view creation.

Overrides:

getCreateViewString in class DatabasePlatform

getQualifiedSequenceName

protected java.lang.String getQualifiedSequenceName(java.lang.String seqName)

Prepend sequence name with table qualifier (if any)

getSelectForUpdateString

public java.lang.String getSelectForUpdateString()

INTERNAL: Used for pessimistic locking.

Overrides:

getSelectForUpdateString in class DatabasePlatform

getTimestampQuery

public ValueReadQuery getTimestampQuery()

PUBLIC: This method returns the query to select the timestamp from the server for TimesTen.

Specified by:

getTimestampQuery in interface Platform

Overrides:

getTimestampQuery in class DatasourcePlatform

initializePlatformOperators

protected void initializePlatformOperators()

Initialize any platform-specific operators

Overrides:

initializePlatformOperators in class DatasourcePlatform

isTimesTen

public boolean isTimesTen()

Answers whether platform is TimesTen

Specified by:

isTimesTen in interface Platform

Overrides:

isTimesTen in class DatasourcePlatform

operatorOuterJoin

protected ExpressionOperator operatorOuterJoin()

Create the outer join operator for this platform

shouldPrintOuterJoinInWhereClause

public boolean shouldPrintOuterJoinInWhereClause()

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

Overrides:

shouldPrintOuterJoinInWhereClause in class DatabasePlatform

supportsNativeSequenceNumbers

public boolean supportsNativeSequenceNumbers()

Return true if the receiver uses host sequence numbers, generated on the database. TimesTen does through global sequence objects.

Overrides:

supportsNativeSequenceNumbers in class DatabasePlatform

supportsForeignKeyConstraints

public boolean supportsForeignKeyConstraints()

Overrides:

supportsForeignKeyConstraints in class DatabasePlatform

setSupportsForeignKeyConstraints

public void setSupportsForeignKeyConstraints(boolean supportsForeignKeyConstraints)