oracle.toplink.platform.database
Class AccessPlatform

java.lang.Object
  oracle.toplink.internal.databaseaccess.DatasourcePlatform
      oracle.toplink.internal.databaseaccess.DatabasePlatform
          oracle.toplink.platform.database.DatabasePlatform
              oracle.toplink.platform.database.AccessPlatform

All Implemented Interfaces:

java.io.Serializable, java.lang.Cloneable, oracle.toplink.internal.databaseaccess.Platform

public class AccessPlatform
extends DatabasePlatform

Purpose: Provides Microsoft Access specific behaviour.

Since:

TOPLink/Java 1.0

See Also:

Serialized Form

Field Summary

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

DEFAULT_MAX_BATCH_WRITING_SIZE, DEFAULT_PARAMETERIZED_MAX_BATCH_WRITING_SIZE

Constructor Summary

AccessPlatform()

Method Summary

java.sql.Timestamp	getTimestampFromServer(oracle.toplink.internal.sessions.AbstractSession session, java.lang.String sessionName) Access do not support millisecond well, truncate the millisecond from the timestamp
boolean	isAccess()
java.util.Hashtable	maximumNumericValues() Builds a table of maximum numeric values keyed on java class.
java.util.Hashtable	minimumNumericValues() Builds a table of minimum numeric values keyed on java class.
void	printFieldNotNullClause(java.io.Writer writer) Append the receiver's field 'NOT NULL' constraint clause to a writer.
boolean	requiresNamedPrimaryKeyConstraints() This is used as some databases create the primary key constraint differently, i.e.
boolean	shouldUseJDBCOuterJoinSyntax() JDBC defines and outer join syntax, many drivers do not support this.

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

addStructConverter, allowsSizeInProcedureArguments, appendParameter, appendParameterInternal, autoCommit, beginTransaction, buildProcedureCallString, commitTransaction, copyInto, executeBatch, executeStoredProcedure, getAssignmentString, getBatchBeginString, getBatchDelimiterString, getBatchEndString, getClassTypes, getConstraintDeletionString, getCreateViewString, getCreationInOutputProcedureToken, getCreationOutputProcedureToken, getCursorCode, getCustomModifyValueForCall, getFieldTypeDefinition, getFieldTypes, getFunctionCallHeader, getInOutputProcedureToken, getJDBCOuterJoinString, getJDBCType, getJDBCType, getMaxBatchWritingSize, getNoWaitString, getOutputProcedureToken, getPingSQL, getProcedureArgumentSetter, getProcedureArgumentString, getProcedureAsString, getProcedureBeginString, getProcedureCallHeader, getProcedureCallTail, getProcedureEndString, getQualifiedSequenceTableName, getSelectForUpdateNoWaitString, getSelectForUpdateOfString, getSelectForUpdateString, getSequenceCounterFieldName, getSequenceNameFieldName, getSequencePreallocationSize, getSequenceTableName, getStatementCacheSize, getStoredProcedureParameterPrefix, getStoredProcedureTerminationToken, getStringBindingSize, getTransactionIsolation, isInformixOuterJoin, prepareBatchStatement, printFieldIdentityClause, printFieldNullClause, printFieldTypeSize, printFieldUnique, printValuelist, printValuelist, registerOutputParameter, requiresProcedureCallBrackets, requiresProcedureCallOuputToken, rollbackTransaction, setCursorCode, setMaxBatchWritingSize, setPingSQL, setSequenceCounterFieldName, setSequenceNameFieldName, setSequenceTableName, setShouldBindAllParameters, setShouldCacheAllStatements, setShouldForceFieldNamesToUpperCase, setShouldIgnoreCaseOnFieldComparisons, setShouldOptimizeDataConversion, setShouldTrimStrings, setStatementCacheSize, setStringBindingSize, setSupportsAutoCommit, setTransactionIsolation, setUsesBatchWriting, setUsesByteArrayBinding, setUsesJDBCBatchWriting, setUsesNativeBatchWriting, setUsesNativeSQL, setUsesStreamsForBinding, setUsesStringBinding, shouldBindAllParameters, shouldCacheAllStatements, shouldForceFieldNamesToUpperCase, shouldIgnoreCaseOnFieldComparisons, shouldIgnoreException, shouldOptimizeDataConversion, shouldPrintConstraintNameAfter, shouldPrintFieldIdentityClause, shouldPrintInOutputTokenBeforeType, shouldPrintOuterJoinInWhereClause, shouldPrintOutputTokenAtStart, shouldPrintOutputTokenBeforeType, shouldTrimStrings, shouldUseCustomModifyForCall, supportsAutoCommit, supportsForeignKeyConstraints, supportsNativeSequenceNumbers, supportsPrimaryKeyConstraint, supportsStoredFunctions, supportsUniqueKeyConstraints, usesBatchWriting, usesByteArrayBinding, usesJDBCBatchWriting, usesNativeBatchWriting, usesNativeSQL, usesSequenceTable, usesStreamsForBinding, usesStringBinding, writeParameterMarker

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

addSequence, clone, convertObject, getConversionManager, getDataTypesConvertedFrom, getDataTypesConvertedTo, getDefaultSequence, getOperator, getPlatformOperators, getSelectSequenceQuery, getSequence, getTableQualifier, getTimestampQuery, getUpdateSequenceQuery, hasDefaultSequence, isAttunity, isCloudscape, isDB2, isDBase, isDerby, isHSQL, isInformix, isMySQL, isODBC, isOracle, isPointBase, isPostgreSQL, isSQLAnywhere, isSQLServer, isSybase, isTimesTen, isTimesTen7, removeAllSequences, removeSequence, setConversionManager, setDefaultSequence, setSelectSequenceNumberQuery, setSequencePreallocationSize, setTableQualifier, setTimestampQuery, setUpdateSequenceQuery, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

AccessPlatform

public AccessPlatform()

Method Detail

getTimestampFromServer

public java.sql.Timestamp getTimestampFromServer(oracle.toplink.internal.sessions.AbstractSession session,
                                                 java.lang.String sessionName)

Access do not support millisecond well, truncate the millisecond from the timestamp

Specified by:

getTimestampFromServer in interface oracle.toplink.internal.databaseaccess.Platform

Overrides:

getTimestampFromServer in class oracle.toplink.internal.databaseaccess.DatasourcePlatform

isAccess

public boolean isAccess()

Specified by:

isAccess in interface oracle.toplink.internal.databaseaccess.Platform

Overrides:

isAccess in class oracle.toplink.internal.databaseaccess.DatasourcePlatform

maximumNumericValues

public java.util.Hashtable maximumNumericValues()

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 oracle.toplink.internal.databaseaccess.DatabasePlatform

minimumNumericValues

public java.util.Hashtable minimumNumericValues()

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 oracle.toplink.internal.databaseaccess.DatabasePlatform

printFieldNotNullClause

public void printFieldNotNullClause(java.io.Writer writer)

Append the receiver's field 'NOT NULL' constraint clause to a writer.

Overrides:

printFieldNotNullClause in class oracle.toplink.internal.databaseaccess.DatabasePlatform

requiresNamedPrimaryKeyConstraints

public boolean requiresNamedPrimaryKeyConstraints()

This is used as some databases create the primary key constraint differently, i.e. Access.

Overrides:

requiresNamedPrimaryKeyConstraints in class oracle.toplink.internal.databaseaccess.DatabasePlatform

shouldUseJDBCOuterJoinSyntax

public boolean shouldUseJDBCOuterJoinSyntax()

JDBC defines and outer join syntax, many drivers do not support this. So we normally avoid it.

Overrides:

shouldUseJDBCOuterJoinSyntax in class oracle.toplink.internal.databaseaccess.DatabasePlatform