oracle.jbo.server
Class SQL92SQLBuilderImpl
java.lang.Object
oracle.jbo.server.BaseSQLBuilderImpl
oracle.jbo.server.SQL92SQLBuilderImpl
- All Implemented Interfaces:
- SQLBuilder, ViewCriteriaAdapter
- Direct Known Subclasses:
- DB2SQLBuilderImpl, SQLServerSQLBuilderImpl
- public class SQL92SQLBuilderImpl
- extends BaseSQLBuilderImpl
SQL92-specific implementation of the SQLBuilder interface. 26Sep01 - KM - added method for registerDefaultDriver which indirects through the jbo.sql92.jdbcdriver property
- Since:
- JDeveloper 3.2
Methods inherited from class oracle.jbo.server.BaseSQLBuilderImpl |
bindDeleteStatement, bindInsertStatement, bindOptUpdateWhereClause, bindUpdateStatement, bindWhereAttrValue, bindWhereClause, bindWhereClause, buildDeleteStatement, buildInsertStatement, buildOptUpdateWhereClause, buildSelectString, buildSelectString, buildUpdateStatement, buildWhereClause, capabilityCanReuseLockStatements, checkTableNameForQuotes, compareFetchedValue, convertFlags, convertValueToStorageType, convertValueToWhereFragment, convertValueToWhereFragment, doEntityDML, doEntitySelect, doLoadBulkFromResultSet, doLoadFromResultSet, doLoadFromStatement, doPreparedStatementDefineColumnType, doPreparedStatementDefines, doRefreshSQL, doRegisterDefaultDriver, doStatementSetBindingStyle, doStatementSetBindingStyleDefault, doStatementSetRowPrefetch, dumpConstraint, executeBatch, generatePKBasedRef, generateRefAndOID, generateRowID, getBaseTable, getColumnNameWithFormatForQuery, getConstraints, getConstraintsList, getCurrentDbTime, getDefaultBindingStyle, getFormattedLHSCompareFragment, getFormattedLHSCompareFragment, getFormattedRHSCompareFragment, getFormattedRHSCompareFragment, getLockTrailerIsAtEnd, getQuotationMarkLeft, getQuotationMarkRight, getROWID, getSchemaList, getSchemas, getSupportsAliasInUpdateStatements, getTableList, getTables, getViewCriteriaAdapter, getViewCriteriaClause, getWarningText, isCharType, isConnectionAlive, isDataSourceJTABased, isNumericType, isStreamType, jdbcClientSideSecurity, lookupDataSource, needsQuotedTableName, populateJboTypeMapEntries, releaseSavepoint, rollbackToSavepoint, setSavepoint, shouldSkipDML, supportsReturningClause, supportsRowNumQuery |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
ERROR_OLITE_RESOURCE_BUSY_AND_NOWAIT_SPECIFIED
public static final int ERROR_OLITE_RESOURCE_BUSY_AND_NOWAIT_SPECIFIED
-
- See Also:
- Constant Field Values
ORACLE_ROWID_COLUMN
protected static final java.lang.String ORACLE_ROWID_COLUMN
-
- See Also:
- Constant Field Values
mSQLBuilderInterface
protected static SQLBuilder mSQLBuilderInterface
SQL92SQLBuilderImpl
protected SQL92SQLBuilderImpl()
- This is a singleton class
getInterface
public static SQLBuilder getInterface()
- Gets the singleton instance of this class.
getVersion
public java.lang.String getVersion()
- Description copied from interface:
SQLBuilder
- Gets a string describing the version of this implentation of this interface.
-
- Specified by:
getVersion
in interface SQLBuilder
- Specified by:
getVersion
in class BaseSQLBuilderImpl
getDbType
public java.lang.String getDbType()
- Description copied from interface:
SQLBuilder
- returns a string uniquely identifying this type of SQLBuilder. Examples are: "Oracle", "OLite", "SQL92"
-
- Specified by:
getDbType
in interface SQLBuilder
- Specified by:
getDbType
in class BaseSQLBuilderImpl
getTypeMapName
public java.lang.String getTypeMapName()
- Description copied from interface:
SQLBuilder
- Returns a String identifying the preferred type map to use.
-
- Specified by:
getTypeMapName
in interface SQLBuilder
- Specified by:
getTypeMapName
in class BaseSQLBuilderImpl
getPersistManagerClassName
public java.lang.String getPersistManagerClassName()
- Description copied from interface:
SQLBuilder
- Returns the name of default PersistManager class name.
-
- Specified by:
getPersistManagerClassName
in interface SQLBuilder
- Specified by:
getPersistManagerClassName
in class BaseSQLBuilderImpl
getJDBCDriverClassName
protected java.lang.String getJDBCDriverClassName()
- required override: provide the name of the default jdbc driver class KM: 2001-09-26 - now
-
- Specified by:
getJDBCDriverClassName
in class BaseSQLBuilderImpl
getSqlVariantLockTrailer
protected java.lang.String getSqlVariantLockTrailer()
- Description copied from class:
BaseSQLBuilderImpl
- This defines the string that will be post-fixed to SQL ststements to have the rows locked - if the DB is incapable of this then is should return null. Examples are: SQL Server - "WITH (HOLDLOCK)" Oracle - "FOR UPDATE NOWAIT"
-
- Overrides:
getSqlVariantLockTrailer
in class BaseSQLBuilderImpl
getDbTimeQuery
public java.lang.String getDbTimeQuery()
-
- Specified by:
getDbTimeQuery
in class BaseSQLBuilderImpl
getDropTableSQL
public java.lang.String getDropTableSQL(java.lang.String dbObjectName)
-
- Specified by:
getDropTableSQL
in interface SQLBuilder
- Specified by:
getDropTableSQL
in class BaseSQLBuilderImpl
isDisplayBindValueUI
public boolean isDisplayBindValueUI()
-
- Specified by:
isDisplayBindValueUI
in interface SQLBuilder
- Specified by:
isDisplayBindValueUI
in class BaseSQLBuilderImpl
getCreateSequenceInsertTriggerSQL
public java.lang.String getCreateSequenceInsertTriggerSQL(java.lang.String triggerName,
java.lang.String tableName,
java.lang.String sequenceName,
java.lang.String colName)
-
- Specified by:
getCreateSequenceInsertTriggerSQL
in interface SQLBuilder
- Specified by:
getCreateSequenceInsertTriggerSQL
in class BaseSQLBuilderImpl
getCreateSequenceSQL
public java.lang.String getCreateSequenceSQL(java.lang.String sequenceName,
int startVal)
-
- Specified by:
getCreateSequenceSQL
in interface SQLBuilder
- Specified by:
getCreateSequenceSQL
in class BaseSQLBuilderImpl
getDropSequenceSQL
public java.lang.String getDropSequenceSQL(java.lang.String sequenceName)
-
- Specified by:
getDropSequenceSQL
in interface SQLBuilder
- Specified by:
getDropSequenceSQL
in class BaseSQLBuilderImpl
getQueryHitCountSQL
public java.lang.String getQueryHitCountSQL(RowSet rs)
-
- Specified by:
getQueryHitCountSQL
in interface SQLBuilder
- Overrides:
getQueryHitCountSQL
in class BaseSQLBuilderImpl
Copyright © 1997, 2005, Oracle. All rights reserved.