|
Oracle Fusion Middleware Java API Reference for Oracle TopLink 11g Release 1 (11.1.1) B32476-03 |
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object oracle.toplink.internal.databaseaccess.DatasourcePlatform oracle.toplink.internal.databaseaccess.DatabasePlatform oracle.toplink.platform.database.DatabasePlatform oracle.toplink.platform.database.SybasePlatform
public class SybasePlatform
Purpose: Provides Sybase specific behaviour.
Responsibilities:
Field Summary |
---|
Fields inherited from class oracle.toplink.internal.databaseaccess.DatabasePlatform |
---|
DEFAULT_MAX_BATCH_WRITING_SIZE, DEFAULT_PARAMETERIZED_MAX_BATCH_WRITING_SIZE |
Constructor Summary | |
---|---|
SybasePlatform()
|
Method Summary | |
---|---|
java.lang.Object |
executeStoredProcedure(DatabaseCall dbCall,
java.sql.PreparedStatement statement,
DatabaseAccessor accessor,
oracle.toplink.internal.sessions.AbstractSession session)
because each platform has different requirements for accessing stored procedures and the way that we can combine resultsets and output params the stored procedure call is being executed on the platform. |
java.lang.String |
getBatchDelimiterString()
Used for batch writing and sp defs. |
java.lang.String |
getCreationInOutputProcedureToken()
This method is used to print the required output parameter token for the specific platform. |
java.lang.String |
getCreationOutputProcedureToken()
This method is used to print the required output parameter token for the specific platform. |
java.lang.String |
getInOutputProcedureToken()
This method is used to print the output parameter token when stored procedures are called |
java.util.Vector |
getNativeTableInfo(java.lang.String table,
java.lang.String creator,
oracle.toplink.internal.sessions.AbstractSession session)
Return the catalog information through using the native SQL catalog selects. |
java.lang.String |
getOutputProcedureToken()
This method is used to print the output parameter token when stored procedures are called |
java.lang.String |
getProcedureArgumentString()
Used for sp defs. |
java.lang.String |
getProcedureCallHeader()
Used for sp calls. |
java.lang.String |
getStoredProcedureParameterPrefix()
|
ValueReadQuery |
getTimestampQuery()
This method returns the query to select the timestamp from the server for Sybase. |
boolean |
isSybase()
|
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. |
ExpressionOperator |
modOperator()
Override the default MOD operator. |
void |
printFieldIdentityClause(java.io.Writer writer)
Append the receiver's field 'identity' constraint clause to a writer. |
void |
printFieldNullClause(java.io.Writer writer)
Append the receiver's field 'NULL' constraint clause to a writer. |
void |
registerOutputParameter(java.sql.CallableStatement statement,
int index,
int jdbcType)
This method is used to register output parameter on Callable Statements for Stored Procedures as each database seems to have a different method. |
boolean |
requiresProcedureCallBrackets()
USed for sp calls. |
boolean |
requiresProcedureCallOuputToken()
Used for sp calls. |
boolean |
shouldPrintInOutputTokenBeforeType()
This is required in the construction of the stored procedures with output parameters |
boolean |
shouldPrintOuterJoinInWhereClause()
Some database require outer joins to be given in the where clause, others require it in the from clause. |
boolean |
shouldPrintOutputTokenBeforeType()
This is required in the construction of the stored procedures with output parameters |
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, getAssignmentString, getBatchBeginString, getBatchEndString, getClassTypes, getConstraintDeletionString, getCreateViewString, getCursorCode, getCustomModifyValueForCall, getFieldTypeDefinition, getFieldTypes, getFunctionCallHeader, getJDBCOuterJoinString, getJDBCType, getJDBCType, getMaxBatchWritingSize, getNoWaitString, getPingSQL, getProcedureArgumentSetter, getProcedureAsString, getProcedureBeginString, getProcedureCallTail, getProcedureEndString, getQualifiedSequenceTableName, getSelectForUpdateNoWaitString, getSelectForUpdateOfString, getSelectForUpdateString, getSequenceCounterFieldName, getSequenceNameFieldName, getSequencePreallocationSize, getSequenceTableName, getStatementCacheSize, getStringBindingSize, getTransactionIsolation, isInformixOuterJoin, prepareBatchStatement, printFieldNotNullClause, printFieldTypeSize, printFieldUnique, printValuelist, printValuelist, requiresNamedPrimaryKeyConstraints, 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, shouldPrintOutputTokenAtStart, 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, getTimestampFromServer, getUpdateSequenceQuery, hasDefaultSequence, isAccess, isAttunity, isCloudscape, isDB2, isDBase, isDerby, isHSQL, isInformix, isMySQL, isODBC, isOracle, isPointBase, isPostgreSQL, isSQLAnywhere, isSQLServer, 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 |
---|
public SybasePlatform()
Method Detail |
---|
public java.lang.Object executeStoredProcedure(DatabaseCall dbCall, java.sql.PreparedStatement statement, DatabaseAccessor accessor, oracle.toplink.internal.sessions.AbstractSession session) throws java.sql.SQLException
executeStoredProcedure
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
java.sql.SQLException
public java.lang.String getBatchDelimiterString()
getBatchDelimiterString
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
public java.lang.String getCreationInOutputProcedureToken()
getCreationInOutputProcedureToken
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
public java.lang.String getCreationOutputProcedureToken()
getCreationOutputProcedureToken
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
public java.lang.String getInOutputProcedureToken()
getInOutputProcedureToken
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
public java.util.Vector getNativeTableInfo(java.lang.String table, java.lang.String creator, oracle.toplink.internal.sessions.AbstractSession session)
public java.lang.String getOutputProcedureToken()
getOutputProcedureToken
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
public java.lang.String getProcedureArgumentString()
getProcedureArgumentString
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
public java.lang.String getProcedureCallHeader()
getProcedureCallHeader
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
public java.lang.String getStoredProcedureParameterPrefix()
getStoredProcedureParameterPrefix
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
public ValueReadQuery getTimestampQuery()
getTimestampQuery
in interface oracle.toplink.internal.databaseaccess.Platform
getTimestampQuery
in class oracle.toplink.internal.databaseaccess.DatasourcePlatform
public boolean isSybase()
isSybase
in interface oracle.toplink.internal.databaseaccess.Platform
isSybase
in class oracle.toplink.internal.databaseaccess.DatasourcePlatform
public java.util.Hashtable maximumNumericValues()
NOTE: BigInteger & BigDecimal maximums are dependent upon their precision & Scale
maximumNumericValues
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
public java.util.Hashtable minimumNumericValues()
NOTE: BigInteger & BigDecimal minimums are dependent upon their precision & Scale
minimumNumericValues
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
public ExpressionOperator modOperator()
public void printFieldIdentityClause(java.io.Writer writer) throws ValidationException
printFieldIdentityClause
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
ValidationException
public void printFieldNullClause(java.io.Writer writer) throws ValidationException
printFieldNullClause
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
ValidationException
public void registerOutputParameter(java.sql.CallableStatement statement, int index, int jdbcType) throws java.sql.SQLException
registerOutputParameter
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
java.sql.SQLException
public boolean requiresProcedureCallBrackets()
requiresProcedureCallBrackets
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
public boolean requiresProcedureCallOuputToken()
requiresProcedureCallOuputToken
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
public boolean shouldPrintInOutputTokenBeforeType()
shouldPrintInOutputTokenBeforeType
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
public boolean shouldPrintOuterJoinInWhereClause()
shouldPrintOuterJoinInWhereClause
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
public boolean shouldPrintOutputTokenBeforeType()
shouldPrintOutputTokenBeforeType
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
public boolean shouldUseJDBCOuterJoinSyntax()
shouldUseJDBCOuterJoinSyntax
in class oracle.toplink.internal.databaseaccess.DatabasePlatform
|
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |