oracle.jbo.server
Class SQL92SQLBuilderImpl

java.lang.Object
oracle.jbo.common.CommonCriteriaAdapter
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.

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

Constructor Summary

protected

SQL92SQLBuilderImpl() This is a singleton class.

Method Summary

java.lang.String	getCreateSequenceInsertTriggerSQL(java.lang.String triggerName, java.lang.String tableName, java.lang.String sequenceName, java.lang.String colName) 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, bindInsertStatement, bindOptUpdateWhereClause, bindParametersForStmt, bindParamValue, bindUpdateStatement, bindWhereAttrValue, bindWhereClause, bindWhereClause, buildDeleteStatement, buildInsertStatement, buildOptUpdateWhereClause, buildSelectList, buildSelectString, buildSelectString, buildUpdateStatement, buildWhereClause, capabilityCanReuseLockStatements, checkTableNameForQuotes, compareFetchedValue, convertFlags, convertValueToStorageType, convertValueToWhereFragment, convertValueToWhereFragment, createHandleForCancellableStatements, doEntityDML, doEntitySelect, doLoadBulkFromResultSet, doLoadFromResultSet, doLoadFromStatement, doPreparedStatementDefineColumnType, doPreparedStatementDefines, doRefreshSQL, doRegisterDefaultDriver, doStatementSetBindingStyle, doStatementSetBindingStyleDefault, doStatementSetRowPrefetch, dumpConstraint, executeBatch, formatAttributeValue, generatePKBasedRef, generateRefAndOID, generateRowID, getBaseTable, getColumnNameWithFormatForQuery, getConstraints, getConstraintsList, getCurrentDbTime, getDefaultBindingStyle, getFormattedLHSCompareFragment, getFormattedLHSCompareFragment, getFormattedLHSCompareFragment, getFormattedRHSCompareFragment, getFormattedRHSCompareFragment, getFormattedRHSCompareFragment, getLockTrailerIsAtEnd, getMaxTableNameLength, getNestedTables, getQuotationMarkLeft, getQuotationMarkRight, getROWID, getSchemaList, getSchemas, getSupportsAliasInUpdateStatements, getTableList, getTableList, getTables, getTables, getViewCriteriaAdapter, getViewCriteriaClause, getWarningText, invalidDatumFactoryUsage, isConnectionAlive, isDataSourceJTABased, isNewLineAllowedInSQL, isStreamType, jdbcClientSideSecurity, lookupDataSource, needsQuotedTableName, populateJboTypeMapEntries, processException, releaseSavepoint, rollbackToSavepoint, setSavepoint, shouldSkipDML, supportsReturningClause, supportsRowNumQuery

Methods inherited from class oracle.jbo.common.CommonCriteriaAdapter

convertValueToWhereFragment, getCriteriaClause, isCharType, isNumericType

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

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

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

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

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

getCreateSequenceInsertTriggerSQL

public java.lang.String getCreateSequenceInsertTriggerSQL(java.lang.String triggerName,
                                                          java.lang.String tableName,
                                                          java.lang.String sequenceName,
                                                          java.lang.String colName)

Not implemented. Returns null.

Specified by:

getCreateSequenceInsertTriggerSQL in interface SQLBuilder

Specified by:

getCreateSequenceInsertTriggerSQL in class BaseSQLBuilderImpl

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

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

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