Oracle ADF Model and Business Components API Reference 10.1.2 B14022-01

oracle.jbo.server
Class SQLServerSQLBuilderImpl

java.lang.Object
  extended byoracle.jbo.server.BaseSQLBuilderImpl
      extended byoracle.jbo.server.SQL92SQLBuilderImpl
          extended byoracle.jbo.server.SQLServerSQLBuilderImpl
All Implemented Interfaces:
SQLBuilder, ViewCriteriaAdapter

public class SQLServerSQLBuilderImpl
extends SQL92SQLBuilderImpl


Field Summary
 
Fields inherited from class oracle.jbo.server.SQL92SQLBuilderImpl
ERROR_OLITE_RESOURCE_BUSY_AND_NOWAIT_SPECIFIED, mSQLBuilderInterface, 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
SQLServerSQLBuilderImpl()
           
 
Method Summary
 java.lang.String getDbTimeQuery()
           
 java.lang.String getDbType()
          returns a string uniquely identifying this type of SQLBuilder.
static SQLBuilder getInterface()
          Gets the singleton instance of this class.
protected  java.lang.String getJDBCDriverClassName()
          Defaults to the microsoft supplied JDBC driver, but you can override this with the system property
protected  boolean getLockTrailerIsAtEnd()
           
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.
protected  boolean getSupportsAliasInUpdateStatements()
          SQL*Server doesn't support this: eg: "update EMP Employees (set NAME='Brian') where ID=42"
 java.lang.String getVersion()
          Gets a string describing the version of this implentation of this interface.
 
Methods inherited from class oracle.jbo.server.SQL92SQLBuilderImpl
getCreateSequenceInsertTriggerSQL, getCreateSequenceSQL, getDropSequenceSQL, getDropTableSQL, getPersistManagerClassName, getQueryHitCountSQL, getTypeMapName, 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, getQuotationMarkLeft, getQuotationMarkRight, getROWID, getSchemaList, getSchemas, 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
 

Constructor Detail

SQLServerSQLBuilderImpl

public SQLServerSQLBuilderImpl()
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
Overrides:
getVersion in class SQL92SQLBuilderImpl

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
Overrides:
getDbType in class SQL92SQLBuilderImpl

getJDBCDriverClassName

protected java.lang.String getJDBCDriverClassName()
Defaults to the microsoft supplied JDBC driver, but you can override this with the system property

Overrides:
getJDBCDriverClassName in class SQL92SQLBuilderImpl

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 SQL92SQLBuilderImpl

getLockTrailerIsAtEnd

protected boolean getLockTrailerIsAtEnd()
Overrides:
getLockTrailerIsAtEnd in class BaseSQLBuilderImpl

getDbTimeQuery

public java.lang.String getDbTimeQuery()
Overrides:
getDbTimeQuery in class SQL92SQLBuilderImpl

getSupportsAliasInUpdateStatements

protected boolean getSupportsAliasInUpdateStatements()
SQL*Server doesn't support this: eg: "update EMP Employees (set NAME='Brian') where ID=42"

Overrides:
getSupportsAliasInUpdateStatements in class BaseSQLBuilderImpl
Since:
10.1.2 29Jul04

Oracle ADF Model and Business Components API Reference 10.1.2 B14022-01

 

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