oracle.jbo.server
Class SQLServerSQLBuilderImpl
java.lang.Object
oracle.jbo.server.BaseSQLBuilderImpl
oracle.jbo.server.SQL92SQLBuilderImpl
oracle.jbo.server.SQLServerSQLBuilderImpl
- All Implemented Interfaces:
- SQLBuilder, ViewCriteriaAdapter
- public class SQLServerSQLBuilderImpl
- extends SQL92SQLBuilderImpl
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.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 |
SQLServerSQLBuilderImpl
public SQLServerSQLBuilderImpl()
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
Copyright © 1997, 2005, Oracle. All rights reserved.