Skip navigation links

Oracle Fusion Middleware Java API Reference for Oracle ADF Model
11g Release 1 (11.1.1.5.0)

E10653-06


oracle.jbo.server
Class SQL92SQLBuilderImpl

java.lang.Object
  extended by oracle.jbo.common.CommonCriteriaAdapter
      extended by oracle.jbo.server.CriteriaAdapterImpl
          extended by oracle.jbo.server.BaseSQLBuilderImpl
              extended by oracle.jbo.server.SQL92SQLBuilderImpl

All Implemented Interfaces:
CriteriaAdapter, SQLBuilder, ViewCriteriaAdapter
Direct Known Subclasses:
DB2SQLBuilderImpl, SQLServerSQLBuilderImpl

public class SQL92SQLBuilderImpl
extends BaseSQLBuilderImpl

SQL92 specific implementation of the SQLBuilder interface.

Since:
JDeveloper 3.2

Field Summary
static int ERROR_OLITE_RESOURCE_BUSY_AND_NOWAIT_SPECIFIED
          OLite specific error code for resource busy exception.
protected static SQLBuilder mSQLBuilderInterface
          Member to hold the singleton instance.
protected static java.lang.String ORACLE_ROWID_COLUMN
          Oracle specific column name for ROWID.

 

Fields inherited from interface oracle.jbo.server.SQLBuilder
BINDING_STYLE_JDBC, BINDING_STYLE_ORACLE, BINDING_STYLE_ORACLE_NAME, BINDING_STYLE_UNKNOWN, DML_DELETE, DML_INSERT, DML_UPDATE, MAX_COLUMN_IDENTIFIER_LEN, RANGE_PAGE_BIND_HIGH_ROWNUM, RANGE_PAGE_BIND_LOW_ROWNUM

 

Constructor Summary
protected SQL92SQLBuilderImpl()
          This is a singleton class.

 

Method Summary
 java.lang.String buildEffDtDateDayAddStatement()
          Returns a statement that returns a date that is 'x' number of days apart from the specified date.
 java.lang.String getClauseForDateLiteral(java.util.Date date)
          Creates a database platform specific clause for converting a date string literal to date datatype.
 java.lang.String getCreateSequenceInsertTriggerSQL(java.lang.String triggerName, java.lang.String tableName, java.util.ArrayList sequenceNames, java.util.ArrayList colNames)
          Not implemented.
 java.lang.String getCreateSequenceSQL(java.lang.String sequenceName, int startVal)
          Not implemented.
 java.lang.String getDbTimeQuery()
          Returns a SQL statement to obtain the current time from the database.
 java.lang.String getDbType()
          Returns a string uniquely identifying this type of SQLBuilder.
 java.lang.String getDropSequenceSQL(java.lang.String sequenceName)
          Not implemented.
 java.lang.String getDropTableSQL(java.lang.String dbObjectName)
          Returns a SQL statement that drops a specified table.
static SQLBuilder getInterface()
          Gets the singleton instance of this class.
protected  java.lang.String getJDBCDriverClassName(java.lang.String url)
          Concrete implementations of SQLBuilder must elect a default driver name.
 java.lang.String getPersistManagerClassName()
          Returns the name of default PersistManager class name.
 java.lang.String getQueryHitCountSQL(RowSet rs)
          Returns a SQL statement to estimate the number of rows effected by the query using the rowset values.
protected  java.lang.String getSqlVariantLockTrailer()
          Returns the lock trailer from the System properties.
 java.lang.String getTypeMapName()
          The default type map for a SQL92 database is Oracle.
 java.lang.String getVersion()
          Gets a string describing the version of this implentation of this interface.
 boolean isDisplayBindValueUI()
          For Oracle database the test SQL wizards provide additional functionality to bind the parameters with test values.

 

Methods inherited from class oracle.jbo.server.BaseSQLBuilderImpl
baseBuildSelectList, bindDeleteStatement, bindEffDtDateDayAddStatement, bindInsertStatement, bindOptUpdateWhereClause, bindParametersForStmt, bindParamValue, bindRangePagingParams, bindUpdateStatement, bindWhereAttrValue, bindWhereClause, bindWhereClause, buildDefaultViewObjectFromClause, buildDefaultViewObjectFromClause, buildDefaultViewObjectWhereClause, buildDeleteStatement, buildInsertStatement, buildOptUpdateWhereClause, buildRangePagingQuery, buildSelectList, buildSelectString, buildSelectString, buildUpdateStatement, buildWhereClause, capabilityCanReuseLockStatements, checkTableNameForQuotes, compareFetchedValue, containsTableAlias, convertFlags, convertValueToStorageType, convertValueToWhereFragment, convertValueToWhereFragment, createHandleForCancellableStatements, doEntityDML, doEntitySelect, doEntitySelectForAltKey, doLoadBulkFromResultSet, doLoadFromResultSet, doLoadFromStatement, doPreparedStatementDefineColumnType, doPreparedStatementDefines, doRefreshSQL, doRegisterDefaultDriver, doStatementSetBindingStyle, doStatementSetBindingStyleDefault, doStatementSetRowPrefetch, dumpConstraint, executeBatch, findTableAliasInSQLExpr, generatePKBasedRef, generateRefAndOID, generateRowID, getANSIJoinVCs, getBaseTable, getBindingStyleValue, getCappedQueryHitCountSQL, getColumnNameWithFormatForQuery, getConstraints, getConstraintsList, getCurrentDbTime, getDBOperationList, getDBPackageList, getDefaultBindingStyle, getEscapeClause, getFormattedLHSCompareFragment, getFormattedRHSCompareFragment, getFormattedRHSCompareFragment, getLockTrailerIsAtEnd, getMaxTableNameLength, getNestedTables, getQuotationMarkLeft, getQuotationMarkRight, getROWID, getSchemaList, getSchemas, getStringConcatOper, getSupportsAliasInUpdateStatements, getTableList, getTableList, getTables, getTables, getTables, getTables, getViewCriteriaAdapter, getWarningText, getWildCardEscapeVal, handleSQLException, invalidDatumFactoryUsage, isConnectionAlive, isDataSourceJTABased, isNCharType, isNewLineAllowedInSQL, isSQLRecoverableException, isStreamType, jdbcClientSideSecurity, lookupDataSource, needsQuotedTableName, populateCompOpers, populateJboTypeMapEntries, processClauseForSubQuery, processClauseReplaceTableAliases, processException, registerDatabaseChangeListener, releaseSavepoint, rollbackToSavepoint, setSavepoint, setSessionTimeZone, shouldPutJoinConstraintInFromClause, shouldSkipDML, supportsReturningClause, supportsRowNumQuery

 

Methods inherited from class oracle.jbo.server.CriteriaAdapterImpl
formatAttributeValue, getBindValsForSqlGen, getFormattedLHSCompareFragment, getFormattedRHSCompareFragment, getRowSetForSqlGen, getViewCriteriaClause, getWhereFragmentFromVO, isCriteriaItemOuterJoined, isLHSFragmentOptional, setupBindVarExtendedData

 

Methods inherited from class oracle.jbo.common.CommonCriteriaAdapter
cleanUpTemporaryBindVariables, cleanUpTemporaryBindVars, convertCriteriaItemToWhereFragment, convertOpandRHSToWhereFragment, convertValueToWhereFragment, correctOprandLiteral, createTempBindVar, createTemporaryBindVar, doConvertCriteriaItemToWhereFragment, getCriteriaClause, getCriteriaClause, getFormattedLHSCompareFragment, getOptionalItemClause, isCharType, isDateType, isNumericType, parseOperatorAndValueFromItemValue, shouldUseTempBindVariableForValue

 

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

 

Methods inherited from interface oracle.jbo.server.SQLBuilder
isCharType, isNumericType

 

Field Detail

ERROR_OLITE_RESOURCE_BUSY_AND_NOWAIT_SPECIFIED

public static final int ERROR_OLITE_RESOURCE_BUSY_AND_NOWAIT_SPECIFIED
OLite specific error code for resource busy exception.
See Also:
Constant Field Values

ORACLE_ROWID_COLUMN

protected static final java.lang.String ORACLE_ROWID_COLUMN
Oracle specific column name for ROWID.
See Also:
Constant Field Values

mSQLBuilderInterface

protected static SQLBuilder mSQLBuilderInterface
Member to hold the singleton instance.

Constructor Detail

SQL92SQLBuilderImpl

protected SQL92SQLBuilderImpl()
This is a singleton class.

Method Detail

getInterface

public static SQLBuilder getInterface()
Gets the singleton instance of this class.
Returns:
a SQLBuilder object.

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
Returns:
a String containing the version.

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
Returns:
a String containing the Database type.

getTypeMapName

public java.lang.String getTypeMapName()
The default type map for a SQL92 database is Oracle. This is overridden in the subclasses.
Specified by:
getTypeMapName in interface SQLBuilder
Specified by:
getTypeMapName in class BaseSQLBuilderImpl
Returns:
PropertyConstants.ORACLE constant.

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
Returns:
a String containing the Class name.

getJDBCDriverClassName

protected java.lang.String getJDBCDriverClassName(java.lang.String url)
Description copied from class: BaseSQLBuilderImpl
Concrete implementations of SQLBuilder must elect a default driver name.
Specified by:
getJDBCDriverClassName in class BaseSQLBuilderImpl
Parameters:
url - JDBC Connection url.
Returns:
the default driver class name based on the url and database flavor.

getSqlVariantLockTrailer

protected java.lang.String getSqlVariantLockTrailer()
Returns the lock trailer from the System properties. Subclasses override this method to provide database specific trailer.
Overrides:
getSqlVariantLockTrailer in class BaseSQLBuilderImpl
Returns:
SQL clause to lock a row in the database.

getDbTimeQuery

public java.lang.String getDbTimeQuery()
Description copied from class: BaseSQLBuilderImpl
Returns a SQL statement to obtain the current time from the database.
Specified by:
getDbTimeQuery in class BaseSQLBuilderImpl
Returns:
a String containing the SQL statement.

getDropTableSQL

public java.lang.String getDropTableSQL(java.lang.String dbObjectName)
Description copied from interface: SQLBuilder
Returns a SQL statement that drops a specified table. For Oracle database it also deletes the constraints for the table.

Note: this method is subject to change.

Specified by:
getDropTableSQL in interface SQLBuilder
Specified by:
getDropTableSQL in class BaseSQLBuilderImpl
Parameters:
dbObjectName - name of the Table.
Returns:
the SQL statement as a String object.

isDisplayBindValueUI

public boolean isDisplayBindValueUI()
Description copied from interface: SQLBuilder
For Oracle database the test SQL wizards provide additional functionality to bind the parameters with test values. For other databases this functionality is not supported.
Specified by:
isDisplayBindValueUI in interface SQLBuilder
Specified by:
isDisplayBindValueUI in class BaseSQLBuilderImpl
Returns:
true for Oracle, false for all other databases.

getCreateSequenceInsertTriggerSQL

public java.lang.String getCreateSequenceInsertTriggerSQL(java.lang.String triggerName,
                                                          java.lang.String tableName,
                                                          java.util.ArrayList sequenceNames,
                                                          java.util.ArrayList colNames)
Not implemented. Returns null.
Specified by:
getCreateSequenceInsertTriggerSQL in interface SQLBuilder
Specified by:
getCreateSequenceInsertTriggerSQL in class BaseSQLBuilderImpl
Parameters:
triggerName - the name of the trigger.
tableName - the name of the table for which the trigger is created.
sequenceNames - the array of names of the sequence.
colNames - the arrya of names of the column to which the value of the sequence is copied to.
Returns:
the SQL statement as a String object.

getCreateSequenceSQL

public java.lang.String getCreateSequenceSQL(java.lang.String sequenceName,
                                             int startVal)
Not implemented. Returns null.
Specified by:
getCreateSequenceSQL in interface SQLBuilder
Specified by:
getCreateSequenceSQL in class BaseSQLBuilderImpl
Parameters:
sequenceName - name of the Sequence.
startVal - the initial value of the Sequence.
Returns:
the SQL statement as a String object.

getDropSequenceSQL

public java.lang.String getDropSequenceSQL(java.lang.String sequenceName)
Not implemented. Returns null.
Specified by:
getDropSequenceSQL in interface SQLBuilder
Specified by:
getDropSequenceSQL in class BaseSQLBuilderImpl
Parameters:
sequenceName - name of the Sequence.
Returns:
the SQL statement as a String object.

getQueryHitCountSQL

public java.lang.String getQueryHitCountSQL(RowSet rs)
Description copied from interface: SQLBuilder
Returns a SQL statement to estimate the number of rows effected by the query using the rowset values.

Note: this method is subject to change.

Specified by:
getQueryHitCountSQL in interface SQLBuilder
Overrides:
getQueryHitCountSQL in class BaseSQLBuilderImpl
Parameters:
rs - the RowSet object.
Returns:
the SQL statement as a String object.

buildEffDtDateDayAddStatement

public java.lang.String buildEffDtDateDayAddStatement()
Description copied from interface: SQLBuilder
Returns a statement that returns a date that is 'x' number of days apart from the specified date.
Specified by:
buildEffDtDateDayAddStatement in interface SQLBuilder
Overrides:
buildEffDtDateDayAddStatement in class BaseSQLBuilderImpl
Returns:
A String that contains the necessary SQL.

getClauseForDateLiteral

public java.lang.String getClauseForDateLiteral(java.util.Date date)
Description copied from interface: SQLBuilder
Creates a database platform specific clause for converting a date string literal to date datatype. May be used in date comparisions and other manipulations.
Parameters:
date - The date object that will be formatted and passed as a String
Returns:
A string representing the clause to be used while building the query statement.

Skip navigation links

Oracle Fusion Middleware Java API Reference for Oracle ADF Model
11g Release 1 (11.1.1.5.0)

E10653-06


Copyright © 1997, 2011, Oracle. All rights reserved.