public class DB2SQLBuilderImpl extends SQL92SQLBuilderImpl
ERROR_OLITE_RESOURCE_BUSY_AND_NOWAIT_SPECIFIED, mSQLBuilderInterface, ORACLE_ROWID_COLUMN
SQLBUILDER_LOGGER
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 and Description |
---|
DB2SQLBuilderImpl() |
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.util.ArrayList |
getConstraintsList(java.sql.Connection conn,
java.lang.String catalog,
java.lang.String user_or_schema,
java.lang.String full_tablename)
Return vector with constraint details for this table
where each detail is in a String array with this structure:
0 String owner
|
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)
Concrete implementations of SQLBuilder must elect a default driver name.
|
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 |
getVersion()
Gets a string describing the version of this implentation
of this interface.
|
boolean |
isNewLineAllowedInSQL(java.sql.Connection conn)
Checks if the JDBC driver supports new line character
in SQL statements.
|
void |
releaseSavepoint(java.sql.Connection conn,
java.lang.String id)
Release SAVEPOINT if possible.
|
void |
rollbackToSavepoint(java.sql.Connection conn,
java.lang.String id)
Rollback to SAVEPOINT if possible.
|
void |
setSavepoint(java.sql.Connection conn,
java.lang.String id)
Issue a SAVEPOINT if possible.
|
getCreateSequenceInsertTriggerSQL, getCreateSequenceSQL, getDropSequenceSQL, getDropTableSQL, getQueryHitCountSQL, getTypeMapName, isDisplayBindValueUI
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, getCurrentDbTime, getDBOperationList, getDBPackageList, getDefaultBindingStyle, getDefaultOptimizerHint, 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, isSQLRecoverableException, isStreamType, jdbcClientSideSecurity, lookupDataSource, needsQuotedTableName, populateCompOpers, populateJboTypeMapEntries, prepareCall, prepareStatement, processClauseForSubQuery, processClauseReplaceTableAliases, processException, registerDatabaseChangeListener, setSessionTimeZone, shouldPutJoinConstraintInFromClause, shouldSkipDML, supportsReturningClause, supportsRowNumQuery, unwrapConnection, unwrapResultSet, unwrapStatement
formatAttributeValue, getBindValsForSqlGen, getCriteriaClause, getCriteriaClause, getFormattedLHSCompareFragment, getFormattedRHSCompareFragment, getRowSetForSqlGen, getViewCriteriaClause, getWhereFragmentFromVO, isCriteriaItemOuterJoined, isLHSFragmentOptional, replaceSQLDerivedAttrTableAlias, setupBindVarExtendedData
cleanUpTemporaryBindVariables, cleanUpTemporaryBindVars, convertCriteriaItemToWhereFragment, convertOpandRHSToWhereFragment, convertValueToWhereFragment, correctOprandLiteral, createTempBindVar, createTemporaryBindVar, doConvertCriteriaItemToWhereFragment, getFormattedLHSCompareFragment, getOptionalItemClause, isCharType, isDateType, isNumericType, parseOperatorAndValueFromItemValue, shouldUseTempBindVariableForValue
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
isCharType, isNumericType
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)
BaseSQLBuilderImpl
getJDBCDriverClassName
in class SQL92SQLBuilderImpl
url
- JDBC Connection url.public void setSavepoint(java.sql.Connection conn, java.lang.String id) throws java.sql.SQLException
SQLBuilder
setSavepoint
in interface SQLBuilder
setSavepoint
in class BaseSQLBuilderImpl
conn
- the Connection used to create a savepoint.id
- the id for a savepoint.java.sql.SQLException
public void rollbackToSavepoint(java.sql.Connection conn, java.lang.String id) throws java.sql.SQLException
SQLBuilder
rollbackToSavepoint
in interface SQLBuilder
rollbackToSavepoint
in class BaseSQLBuilderImpl
conn
- the Connection used to rollback the savepoint.id
- the id for a savepointjava.sql.SQLException
public void releaseSavepoint(java.sql.Connection conn, java.lang.String id) throws java.sql.SQLException
SQLBuilder
releaseSavepoint
in interface SQLBuilder
releaseSavepoint
in class BaseSQLBuilderImpl
conn
- the Connection used to release the savepoint.id
- the id for a savepointjava.sql.SQLException
protected java.lang.String getSqlVariantLockTrailer()
SQL92SQLBuilderImpl
getSqlVariantLockTrailer
in class SQL92SQLBuilderImpl
public java.lang.String getDbTimeQuery()
BaseSQLBuilderImpl
getDbTimeQuery
in class SQL92SQLBuilderImpl
public boolean isNewLineAllowedInSQL(java.sql.Connection conn)
SQLBuilder
isNewLineAllowedInSQL
in interface SQLBuilder
isNewLineAllowedInSQL
in class BaseSQLBuilderImpl
conn
- the Database connection objectpublic java.util.ArrayList getConstraintsList(java.sql.Connection conn, java.lang.String catalog, java.lang.String user_or_schema, java.lang.String full_tablename) throws java.sql.SQLException
SQLBuilder
1 String constraint_name
2 String constraint_type
3 String table_name
4 String search_condition
5 Integer delete_rule (cascade)
6 Integer status (enabled)
7 Integerdeferrable
8 Integer deferred
9 Integer validated
10 String column_name
11 Integer position
12 String fkname
13 String fkother
Note: this method is subject to change.
getConstraintsList
in interface SQLBuilder
getConstraintsList
in class BaseSQLBuilderImpl
conn
- the connection object.catalog
- the database catalog.user_or_schema
- the database schema.full_tablename
- the name of the table.java.sql.SQLException
public java.lang.String buildEffDtDateDayAddStatement()
SQLBuilder
buildEffDtDateDayAddStatement
in interface SQLBuilder
buildEffDtDateDayAddStatement
in class SQL92SQLBuilderImpl
String
that contains the necessary SQL.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