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

Field Summary

static int	ERROR_OLITE_RESOURCE_BUSY_AND_NOWAIT_SPECIFIED
protected static SQLBuilder	mSQLBuilderInterface
protected static java.lang.String	ORACLE_ROWID_COLUMN

Fields inherited from interface oracle.jbo.server.SQLBuilder

BINDING_STYLE_JDBC, BINDING_STYLE_ORACLE, 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)
java.lang.String	getCreateSequenceSQL(java.lang.String sequenceName, int startVal)
java.lang.String	getDbTimeQuery()
java.lang.String	getDbType() returns a string uniquely identifying this type of SQLBuilder.
java.lang.String	getDropSequenceSQL(java.lang.String sequenceName)
java.lang.String	getDropTableSQL(java.lang.String dbObjectName)
static SQLBuilder	getInterface() Gets the singleton instance of this class.
protected java.lang.String	getJDBCDriverClassName() required override: provide the name of the default jdbc driver class KM: 2001-09-26 - now
java.lang.String	getPersistManagerClassName() Returns the name of default PersistManager class name.
java.lang.String	getQueryHitCountSQL(RowSet rs)
protected java.lang.String	getSqlVariantLockTrailer() 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.
java.lang.String	getTypeMapName() Returns a String identifying the preferred type map to use.
java.lang.String	getVersion() Gets a string describing the version of this implentation of this interface.
boolean	isDisplayBindValueUI()

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

Field Detail

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

Constructor Detail

SQL92SQLBuilderImpl

protected SQL92SQLBuilderImpl()

This is a singleton class

Method Detail

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