public class SQL92SQLBuilderImpl extends BaseSQLBuilderImpl
Modifier and Type | Field and Description |
---|---|
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.
|
LOGGER_NAME
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
Modifier | Constructor and Description |
---|---|
protected |
SQL92SQLBuilderImpl()
This is a singleton class.
|
Modifier and Type | Method and Description |
---|---|
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 |
getCreateSequenceInsertTriggerSQL(java.lang.String triggerName, java.lang.String tableName, java.util.ArrayList sequenceNames, java.util.ArrayList colNames)
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.
|
baseBuildSelectList, bindDeleteStatement, bindEffDtDateDayAddStatement, bindInsertStatement, bindOptUpdateWhereClause, bindParametersForStmt, bindParamValue, bindRangePagingParams, bindUpdateStatement, bindWhereAttrValue, bindWhereClause, bindWhereClause, buildDefaultViewObjectFromClause, buildDefaultViewObjectFromClause, buildDefaultViewObjectWhereClause, buildDeleteStatement, buildInsertStatement, buildOptUpdateWhereClause, buildRangePagingQuery, buildSelectList, buildSelectString, buildSelectString, buildUpdateStatement, buildWhereClause, capabilityCanReuseLockStatements, checkTableNameForQuotes, compareFetchedValue, containsTableAlias, convertFlags, convertValueToStorageType, convertValueToWhereFragment, convertValueToWhereFragment, createHandleForCancellableStatements, createStatement, doEntityDML, doEntitySelect, doEntitySelectForAltKey, doLoadBulkFromResultSet, doLoadFromResultSet, doLoadFromStatement, doPreparedStatementDefineColumnType, doPreparedStatementDefines, doRefreshSQL, doRegisterDefaultDriver, doStatementSetBindingStyle, doStatementSetBindingStyleDefault, doStatementSetRowPrefetch, dumpConstraint, executeBatch, findTableAliasInSQLExpr, generatePKBasedRef, generateRefAndOID, generateRowID, getANSIJoinVCs, getBaseTable, getBindingStyleValue, getCappedQueryHitCountSQL, getColumnNameWithFormatForQuery, getConstraints, getConstraintsList, getCurrentDbTime, getDBOperationList, getDBPackageList, getDefaultBindingStyle, getEscapeClause, getFormattedLHSCompareFragment, getFormattedRHSCompareFragment, getFormattedRHSCompareFragment, getLockTrailerIsAtEnd, getMaxTableNameLength, getNativeConnectionType, getNativeResultSetType, getNativeStatementType, getNestedTables, getQuotationMarkLeft, getQuotationMarkRight, getROWID, getSchemaList, getSchemas, getStringConcatOper, getSupportsAliasInUpdateStatements, getTableList, getTableList, getTables, getTables, getTables, getTables, getViewCriteriaAdapter, getWarningText, getWildCardEscapeVal, handleSQLException, invalidDatumFactoryUsage, isConnectionAlive, isDataSourceJTABased, isNCharType, isNewLineAllowedInSQL, isSQLRecoverableException, isStreamType, jdbcClientSideSecurity, lookupDataSource, needsQuotedTableName, populateCompOpers, populateJboTypeMapEntries, prepareCall, prepareStatement, processClauseForSubQuery, processClauseReplaceTableAliases, processException, registerDatabaseChangeListener, releaseSavepoint, rollbackToSavepoint, setSavepoint, setSessionTimeZone, shouldPutJoinConstraintInFromClause, shouldSkipDML, supportsReturningClause, supportsRowNumQuery, unwrapConnection, unwrapResultSet, unwrapStatement
formatAttributeValue, getBindValsForSqlGen, getFormattedLHSCompareFragment, getFormattedRHSCompareFragment, getRowSetForSqlGen, getViewCriteriaClause, getWhereFragmentFromVO, isCriteriaItemOuterJoined, isLHSFragmentOptional, replaceSQLDerivedAttrTableAlias, setupBindVarExtendedData
cleanUpTemporaryBindVariables, cleanUpTemporaryBindVars, convertCriteriaItemToWhereFragment, convertOpandRHSToWhereFragment, convertValueToWhereFragment, correctOprandLiteral, createTempBindVar, createTemporaryBindVar, doConvertCriteriaItemToWhereFragment, getCriteriaClause, getCriteriaClause, getFormattedLHSCompareFragment, getOptionalItemClause, isCharType, isDateType, isNumericType, parseOperatorAndValueFromItemValue, shouldUseTempBindVariableForValue
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
isCharType, isNumericType
public static final int ERROR_OLITE_RESOURCE_BUSY_AND_NOWAIT_SPECIFIED
protected static final java.lang.String ORACLE_ROWID_COLUMN
protected static SQLBuilder mSQLBuilderInterface
public static SQLBuilder getInterface()
SQLBuilder
object.public java.lang.String getVersion()
SQLBuilder
getVersion
in interface SQLBuilder
getVersion
in class BaseSQLBuilderImpl
public java.lang.String getDbType()
SQLBuilder
getDbType
in interface SQLBuilder
getDbType
in class BaseSQLBuilderImpl
public java.lang.String getTypeMapName()
getTypeMapName
in interface SQLBuilder
getTypeMapName
in class BaseSQLBuilderImpl
public java.lang.String getPersistManagerClassName()
SQLBuilder
getPersistManagerClassName
in interface SQLBuilder
getPersistManagerClassName
in class BaseSQLBuilderImpl
protected java.lang.String getJDBCDriverClassName(java.lang.String url)
BaseSQLBuilderImpl
getJDBCDriverClassName
in class BaseSQLBuilderImpl
url
- JDBC Connection url.protected java.lang.String getSqlVariantLockTrailer()
getSqlVariantLockTrailer
in class BaseSQLBuilderImpl
public java.lang.String getDbTimeQuery()
BaseSQLBuilderImpl
getDbTimeQuery
in class BaseSQLBuilderImpl
public java.lang.String getDropTableSQL(java.lang.String dbObjectName)
SQLBuilder
Note: this method is subject to change.
getDropTableSQL
in interface SQLBuilder
getDropTableSQL
in class BaseSQLBuilderImpl
dbObjectName
- name of the Table.public boolean isDisplayBindValueUI()
SQLBuilder
isDisplayBindValueUI
in interface SQLBuilder
isDisplayBindValueUI
in class BaseSQLBuilderImpl
public java.lang.String getCreateSequenceInsertTriggerSQL(java.lang.String triggerName, java.lang.String tableName, java.util.ArrayList sequenceNames, java.util.ArrayList colNames)
getCreateSequenceInsertTriggerSQL
in interface SQLBuilder
getCreateSequenceInsertTriggerSQL
in class BaseSQLBuilderImpl
triggerName
- the name of the trigger.tableName
- the name of the table for which the trigger is created.sequenceNames
- the array of names of the sequence.colNames
- the arrya of names of the column to which the value of the sequence is copied to.public java.lang.String getCreateSequenceSQL(java.lang.String sequenceName, int startVal)
getCreateSequenceSQL
in interface SQLBuilder
getCreateSequenceSQL
in class BaseSQLBuilderImpl
sequenceName
- name of the Sequence.startVal
- the initial value of the Sequence.public java.lang.String getDropSequenceSQL(java.lang.String sequenceName)
getDropSequenceSQL
in interface SQLBuilder
getDropSequenceSQL
in class BaseSQLBuilderImpl
sequenceName
- name of the Sequence.public java.lang.String getQueryHitCountSQL(RowSet rs)
SQLBuilder
Note: this method is subject to change.
getQueryHitCountSQL
in interface SQLBuilder
getQueryHitCountSQL
in class BaseSQLBuilderImpl
rs
- the RowSet object.public java.lang.String buildEffDtDateDayAddStatement()
SQLBuilder
buildEffDtDateDayAddStatement
in interface SQLBuilder
buildEffDtDateDayAddStatement
in class BaseSQLBuilderImpl
String
that contains the necessary SQL.public java.lang.String getClauseForDateLiteral(java.util.Date date)
SQLBuilder
date
- The date object that will be formatted and passed as a String