|
Oracle Fusion Middleware Java API Reference for Oracle ADF Model 11g Release 1 (11.1.1.9.0) E52932-01 |
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object
oracle.jbo.common.CommonCriteriaAdapter
oracle.jbo.server.CriteriaAdapterImpl
oracle.jbo.server.BaseSQLBuilderImpl
oracle.jbo.server.SQL92SQLBuilderImpl
oracle.jbo.server.SQLServerSQLBuilderImpl
public class SQLServerSQLBuilderImpl
SQLServer specific implementation of the SQLBuilder interface.
Field Summary |
---|
Fields inherited from class oracle.jbo.server.SQL92SQLBuilderImpl |
---|
ERROR_OLITE_RESOURCE_BUSY_AND_NOWAIT_SPECIFIED, mSQLBuilderInterface, ORACLE_ROWID_COLUMN |
Fields inherited from class oracle.jbo.server.BaseSQLBuilderImpl |
---|
LOGGER_NAME |
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 | |
---|---|
SQLServerSQLBuilderImpl() |
Method Summary | |
---|---|
void |
bindEffDtDateDayAddStatement(java.sql.PreparedStatement stmt, java.lang.Object date, int days) Bind the statement with the values required to compute a date that is 'x' number of days apart from the specified date |
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 |
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. |
static SQLBuilder |
getInterface() Gets the singleton instance of this class. |
protected java.lang.String |
getJDBCDriverClassName(java.lang.String url) Defaults to the microsoft supplied JDBC driver, but you can override this with the system property. |
protected boolean |
getLockTrailerIsAtEnd() SQLServer permits the lock clause before the WHERE clause. |
java.lang.String |
getPersistManagerClassName() Returns the name of default PersistManager class name. |
protected java.lang.String |
getSqlVariantLockTrailer() Returns the lock trailer from the System properties. |
java.lang.String |
getStringConcatOper(boolean bIncludeSpaces) Returns a String concatenation operator for query clause generation. |
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, getQueryHitCountSQL, getTypeMapName, isDisplayBindValueUI |
Methods inherited from class oracle.jbo.server.CriteriaAdapterImpl |
---|
formatAttributeValue, getBindValsForSqlGen, getCriteriaClause, getFormattedLHSCompareFragment, getFormattedRHSCompareFragment, getRowSetForSqlGen, getViewCriteriaClause, getWhereFragmentFromVO, isCriteriaItemOuterJoined, isLHSFragmentOptional, setupBindVarExtendedData |
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 |
Constructor Detail |
---|
public SQLServerSQLBuilderImpl()
Method Detail |
---|
public static SQLBuilder getInterface()
public java.lang.String getVersion()
SQLBuilder
getVersion
in interface SQLBuilder
getVersion
in class SQL92SQLBuilderImpl
public java.lang.String getDbType()
SQLBuilder
getDbType
in interface SQLBuilder
getDbType
in class SQL92SQLBuilderImpl
public java.lang.String getPersistManagerClassName()
SQLBuilder
getPersistManagerClassName
in interface SQLBuilder
getPersistManagerClassName
in class SQL92SQLBuilderImpl
protected java.lang.String getJDBCDriverClassName(java.lang.String url)
getJDBCDriverClassName
in class SQL92SQLBuilderImpl
url
- the JDBC url.protected java.lang.String getSqlVariantLockTrailer()
SQL92SQLBuilderImpl
getSqlVariantLockTrailer
in class SQL92SQLBuilderImpl
protected boolean getLockTrailerIsAtEnd()
getLockTrailerIsAtEnd
in class BaseSQLBuilderImpl
public java.lang.String getDbTimeQuery()
BaseSQLBuilderImpl
getDbTimeQuery
in class SQL92SQLBuilderImpl
public java.lang.String getStringConcatOper(boolean bIncludeSpaces)
SQLBuilder
getStringConcatOper
in interface SQLBuilder
getStringConcatOper
in class BaseSQLBuilderImpl
bIncludeSpaces
- if the database platform allows spaces before and after the operator the returned string may include the spaces if the passed flag is true
.protected boolean getSupportsAliasInUpdateStatements()
getSupportsAliasInUpdateStatements
in class BaseSQLBuilderImpl
public java.lang.String buildEffDtDateDayAddStatement()
SQLBuilder
buildEffDtDateDayAddStatement
in interface SQLBuilder
buildEffDtDateDayAddStatement
in class SQL92SQLBuilderImpl
String
that contains the necessary SQL.public void bindEffDtDateDayAddStatement(java.sql.PreparedStatement stmt, java.lang.Object date, int days) throws java.sql.SQLException
SQLBuilder
bindEffDtDateDayAddStatement
in interface SQLBuilder
bindEffDtDateDayAddStatement
in class BaseSQLBuilderImpl
stmt
- The PreparedStatment
object that needs to be bound with the valuesdate
- The specified datedays
- The number of days the resulting date needs to differ from the specified date. It could be a positive or a negative numberjava.sql.SQLException
public java.lang.String getClauseForDateLiteral(java.util.Date date)
SQLBuilder
getClauseForDateLiteral
in interface SQLBuilder
getClauseForDateLiteral
in class SQL92SQLBuilderImpl
date
- The date object that will be formatted and passed as a String
|
Oracle Fusion Middleware Java API Reference for Oracle ADF Model 11g Release 1 (11.1.1.9.0) E52932-01 |
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |