oracle.toplink.essentials.platform.database

Class InformixPlatform

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.InformixPlatform

All Implemented Interfaces:

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

public class InformixPlatform
extends DatabasePlatform

Purpose: Provides Informix specific behaviour.

Responsibilities:

• Types for schema creation.
• Native sequencing using @@SERIAL.

Since:

TOPLink/Java 1.0.1

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
InformixPlatform()

Method Summary

Modifier and Type	Method and Description
protected void	appendCalendar(java.util.Calendar calendar, java.io.Writer writer) INTERNAL: Answer a platform correct string representation of a Calendar, suitable for SQL generation.
protected void	appendDate(java.sql.Date date, java.io.Writer writer) INTERNAL: Answer a platform correct string representation of a Date, suitable for SQL generation.
protected void	appendInformixCalendar(java.util.Calendar calendar, java.io.Writer writer) INTERNAL: Write a timestamp in Informix specific format ( yyyy-mm-dd hh:mm:ss.fff)
protected void	appendInformixTimestamp(java.sql.Timestamp timestamp, java.io.Writer writer) INTERNAL: Write a timestamp in Informix specific format (yyyy-mm-dd hh:mm:ss.fff).
protected void	appendTime(java.sql.Time time, java.io.Writer writer) INTERNAL: Answer a platform correct string representation of a Time, suitable for SQL generation.
protected void	appendTimestamp(java.sql.Timestamp timestamp, java.io.Writer writer) INTERNAL: Answer a platform correct string representation of a Timestamp, suitable for SQL generation.
protected java.util.Hashtable	buildFieldTypes() Return the mapping of class types to database types for the schema framework.
ValueReadQuery	buildSelectQueryForNativeSequence() INTERNAL: Build the identity query for native sequencing.
int	getMaxFieldNameSize() INTERNAL: returns the maximum number of characters that can be used in a field name on this platform.
java.lang.String	getSelectForUpdateString() INTERNAL: Informix seems to like this syntax instead of the OF * syntax.
boolean	isInformix()
boolean	isInformixOuterJoin() INTERNAL: Some database require outer joins to be given in the where clause, others require it in the from clause.
java.util.Hashtable	maximumNumericValues() INTERNAL: Builds a table of maximum numeric values keyed on java class.
java.util.Hashtable	minimumNumericValues() INTERNAL: Builds a table of minimum numeric values keyed on java class.
void	printFieldIdentityClause(java.io.Writer writer) INTERNAL: Append the receiver's field serial constraint clause to a writer.
boolean	requiresProcedureCallBrackets() INTERNAL: USed for sp calls.
boolean	shouldNativeSequenceAcquireValueAfterInsert() INTERNAL: If native sequencing is being used on Informix then the values must be retrieved after the insert.
boolean	shouldPrintConstraintNameAfter() INTERNAL: Some Platforms want the constraint name after the constraint definition.
boolean	shouldPrintOuterJoinInWhereClause() INTERNAL: Some database require outer joins to be given in the where clause, others require it in the from clause.
boolean	supportsNativeSequenceNumbers() INTERNAL: 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, appendByteArray, 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, getCreateViewString, getCreationInOutputProcedureToken, getCreationOutputProcedureToken, getCursorCode, getFieldTypeDefinition, getFieldTypes, getFunctionCallHeader, getInOutputProcedureToken, getJDBCOuterJoinString, getJDBCType, getJDBCType, getJdbcTypeName, getMaxForeignKeyNameSize, getMaxUniqueKeyNameSize, getObjectFromResultSet, getOutputProcedureToken, getProcedureArgumentSetter, getProcedureArgumentString, getProcedureAsString, getProcedureBeginString, getProcedureCallHeader, getProcedureCallTail, getProcedureEndString, getQualifiedSequenceTableName, getSelectForUpdateNoWaitString, getSelectForUpdateOfString, getSequenceCounterFieldName, getSequenceNameFieldName, getSequencePreallocationSize, getSequenceTableName, getStatementCacheSize, getStoredProcedureParameterPrefix, getStoredProcedureTerminationToken, getStringBindingSize, getTempTableForTable, getTransactionIsolation, isNullAllowedInSelectClause, printFieldIdentityClause, printFieldNotNullClause, printFieldNullClause, printFieldTypeSize, printFieldUnique, printValuelist, printValuelist, processResultSet, registerOutputParameter, requiresNamedPrimaryKeyConstraints, 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, shouldNativeSequenceUseTransaction, shouldOptimizeDataConversion, shouldPrintInOutputTokenBeforeType, shouldPrintOutputTokenAtStart, shouldPrintOutputTokenBeforeType, shouldTempTableSpecifyPrimaryKeys, shouldTrimStrings, shouldUseJDBCOuterJoinSyntax, supportsAutoCommit, supportsForeignKeyConstraints, 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, getTimestampQuery, hasDefaultSequence, initializePlatformOperators, isAccess, isAttunity, isCloudscape, isDB2, isDBase, isDerby, isHSQL, isMySQL, isODBC, isOracle, isPointBase, isPostgreSQL, isSQLAnywhere, isSQLServer, isSybase, isTimesTen, 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

InformixPlatform

public InformixPlatform()

Method Detail

appendDate

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

INTERNAL: Answer a platform correct string representation of a Date, suitable for SQL generation. Native format: 'yyyy-mm-dd

Overrides:

appendDate in class DatabasePlatform

Throws:

java.io.IOException

appendInformixTimestamp

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

INTERNAL: Write a timestamp in Informix specific format (yyyy-mm-dd hh:mm:ss.fff).

Throws:

java.io.IOException

appendCalendar

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

INTERNAL: Answer a platform correct string representation of a Calendar, suitable for SQL generation. The date is printed in the ODBC platform independent format {d'YYYY-MM-DD'}.

Overrides:

appendCalendar in class DatabasePlatform

Throws:

java.io.IOException

appendInformixCalendar

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

INTERNAL: Write a timestamp in Informix specific format ( yyyy-mm-dd hh:mm:ss.fff)

Throws:

java.io.IOException

appendTime

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

INTERNAL: Answer a platform correct string representation of a Time, suitable for SQL generation. The time is printed in the ODBC platform independent format {t'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

INTERNAL: Answer a platform correct string representation of a Timestamp, suitable for SQL generation. The date is printed in the ODBC platform independent format {d'YYYY-MM-DD'}.

Overrides:

appendTimestamp in class DatabasePlatform

Throws:

java.io.IOException

buildFieldTypes

protected java.util.Hashtable buildFieldTypes()

Description copied from class: DatabasePlatform

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

Overrides:

buildFieldTypes in class DatabasePlatform

buildSelectQueryForNativeSequence

public ValueReadQuery buildSelectQueryForNativeSequence()

INTERNAL: Build the identity query for native sequencing.

Overrides:

buildSelectQueryForNativeSequence in class DatabasePlatform

getMaxFieldNameSize

public int getMaxFieldNameSize()

INTERNAL: returns the maximum number of characters that can be used in a field name on this platform.

Overrides:

getMaxFieldNameSize in class DatabasePlatform

getSelectForUpdateString

public java.lang.String getSelectForUpdateString()

INTERNAL: Informix seems to like this syntax instead of the OF * syntax.

Overrides:

getSelectForUpdateString in class DatabasePlatform

isInformix

public boolean isInformix()

Specified by:

isInformix in interface Platform

Overrides:

isInformix in class DatasourcePlatform

isInformixOuterJoin

public boolean isInformixOuterJoin()

INTERNAL: Some database require outer joins to be given in the where clause, others require it in the from clause. Informix requires it in the from clause with no ON expression.

Overrides:

isInformixOuterJoin in class DatabasePlatform

maximumNumericValues

public java.util.Hashtable maximumNumericValues()

INTERNAL: Builds a table of maximum numeric values keyed on java class. This is used for type testing but might also be useful to end users attempting to sanitize values.

NOTE: BigInteger & BigDecimal maximums are dependent upon their precision & Scale

Overrides:

maximumNumericValues in class DatabasePlatform

minimumNumericValues

public java.util.Hashtable minimumNumericValues()

INTERNAL: Builds a table of minimum numeric values keyed on java class. This is used for type testing but might also be useful to end users attempting to sanitize values.

NOTE: BigInteger & BigDecimal minimums are dependent upon their precision & Scale

Overrides:

minimumNumericValues in class DatabasePlatform

printFieldIdentityClause

public void printFieldIdentityClause(java.io.Writer writer)
                              throws ValidationException

INTERNAL: Append the receiver's field serial constraint clause to a writer.

Overrides:

printFieldIdentityClause in class DatabasePlatform

Throws:

ValidationException

requiresProcedureCallBrackets

public boolean requiresProcedureCallBrackets()

INTERNAL: USed for sp calls.

Overrides:

requiresProcedureCallBrackets in class DatabasePlatform

shouldNativeSequenceAcquireValueAfterInsert

public boolean shouldNativeSequenceAcquireValueAfterInsert()

INTERNAL: If native sequencing is being used on Informix then the values must be retrieved after the insert. This method is to be used *ONLY* by sequencing classes

Overrides:

shouldNativeSequenceAcquireValueAfterInsert in class DatabasePlatform

shouldPrintConstraintNameAfter

public boolean shouldPrintConstraintNameAfter()

INTERNAL: Some Platforms want the constraint name after the constraint definition.

Overrides:

shouldPrintConstraintNameAfter in class DatabasePlatform

shouldPrintOuterJoinInWhereClause

public boolean shouldPrintOuterJoinInWhereClause()

INTERNAL: 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()

INTERNAL: Return true if the receiver uses host sequence numbers, generated on the database. Informix does this through SERIAL field types.

Overrides:

supportsNativeSequenceNumbers in class DatabasePlatform