oracle.jbo.server
Class DB2SQLBuilderImpl

java.lang.Object
oracle.jbo.common.CommonCriteriaAdapter
oracle.jbo.server.BaseSQLBuilderImpl
oracle.jbo.server.SQL92SQLBuilderImpl
oracle.jbo.server.DB2SQLBuilderImpl

All Implemented Interfaces:

SQLBuilder, ViewCriteriaAdapter

public class DB2SQLBuilderImpl

extends SQL92SQLBuilderImpl

DB2 specific implementation of the SQLBuilder interface.

Since:

JDeveloper 3.2

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_ORACLE_NAME, BINDING_STYLE_UNKNOWN, DML_DELETE, DML_INSERT, DML_UPDATE

Constructor Summary

DB2SQLBuilderImpl()

Method Summary

com.sun.java.util.collections.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.

Methods inherited from class oracle.jbo.server.SQL92SQLBuilderImpl

getCreateSequenceInsertTriggerSQL, getCreateSequenceSQL, getDropSequenceSQL, getDropTableSQL, getQueryHitCountSQL, getTypeMapName, isDisplayBindValueUI

Methods inherited from class oracle.jbo.server.BaseSQLBuilderImpl

baseBuildSelectList, bindDeleteStatement, bindInsertStatement, bindOptUpdateWhereClause, bindParametersForStmt, bindParamValue, bindUpdateStatement, bindWhereAttrValue, bindWhereClause, bindWhereClause, buildDeleteStatement, buildInsertStatement, buildOptUpdateWhereClause, buildSelectList, buildSelectString, buildSelectString, buildUpdateStatement, buildWhereClause, capabilityCanReuseLockStatements, checkTableNameForQuotes, compareFetchedValue, convertFlags, convertValueToStorageType, convertValueToWhereFragment, convertValueToWhereFragment, createHandleForCancellableStatements, doEntityDML, doEntitySelect, doLoadBulkFromResultSet, doLoadFromResultSet, doLoadFromStatement, doPreparedStatementDefineColumnType, doPreparedStatementDefines, doRefreshSQL, doRegisterDefaultDriver, doStatementSetBindingStyle, doStatementSetBindingStyleDefault, doStatementSetRowPrefetch, dumpConstraint, executeBatch, formatAttributeValue, generatePKBasedRef, generateRefAndOID, generateRowID, getBaseTable, getColumnNameWithFormatForQuery, getConstraints, getCurrentDbTime, getDefaultBindingStyle, getFormattedLHSCompareFragment, getFormattedLHSCompareFragment, getFormattedLHSCompareFragment, getFormattedRHSCompareFragment, getFormattedRHSCompareFragment, getFormattedRHSCompareFragment, getLockTrailerIsAtEnd, getMaxTableNameLength, getNestedTables, getQuotationMarkLeft, getQuotationMarkRight, getROWID, getSchemaList, getSchemas, getSupportsAliasInUpdateStatements, getTableList, getTableList, getTables, getTables, getViewCriteriaAdapter, getViewCriteriaClause, getWarningText, invalidDatumFactoryUsage, isConnectionAlive, isDataSourceJTABased, isStreamType, jdbcClientSideSecurity, lookupDataSource, needsQuotedTableName, populateJboTypeMapEntries, processException, shouldSkipDML, supportsReturningClause, supportsRowNumQuery

Methods inherited from class oracle.jbo.common.CommonCriteriaAdapter

convertValueToWhereFragment, getCriteriaClause, isCharType, isNumericType

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

DB2SQLBuilderImpl

public DB2SQLBuilderImpl()

Method Detail

getInterface

public static SQLBuilder getInterface()

Gets the singleton instance of this class.

Returns:

a SQLBuilder object.

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

getPersistManagerClassName

public java.lang.String getPersistManagerClassName()

Description copied from interface: SQLBuilder

Returns the name of default PersistManager class name.

Specified by:

getPersistManagerClassName in interface SQLBuilder

Overrides:

getPersistManagerClassName in class SQL92SQLBuilderImpl

getJDBCDriverClassName

protected java.lang.String getJDBCDriverClassName(java.lang.String url)

Description copied from class: BaseSQLBuilderImpl

Concrete implementations of SQLBuilder must elect a default driver name.

Overrides:

getJDBCDriverClassName in class SQL92SQLBuilderImpl

setSavepoint

public void setSavepoint(java.sql.Connection conn,
                         java.lang.String id)
                  throws java.sql.SQLException

Description copied from interface: SQLBuilder

Issue a SAVEPOINT if possible.

Specified by:

setSavepoint in interface SQLBuilder

Overrides:

setSavepoint in class BaseSQLBuilderImpl

Throws:

java.sql.SQLException

rollbackToSavepoint

public void rollbackToSavepoint(java.sql.Connection conn,
                                java.lang.String id)
                         throws java.sql.SQLException

Description copied from interface: SQLBuilder

Rollback to SAVEPOINT if possible.

Specified by:

rollbackToSavepoint in interface SQLBuilder

Overrides:

rollbackToSavepoint in class BaseSQLBuilderImpl

Throws:

java.sql.SQLException

releaseSavepoint

public void releaseSavepoint(java.sql.Connection conn,
                             java.lang.String id)
                      throws java.sql.SQLException

Description copied from interface: SQLBuilder

Release SAVEPOINT if possible.

Specified by:

releaseSavepoint in interface SQLBuilder

Overrides:

releaseSavepoint in class BaseSQLBuilderImpl

Throws:

java.sql.SQLException

getSqlVariantLockTrailer

protected java.lang.String getSqlVariantLockTrailer()

Description copied from class: SQL92SQLBuilderImpl

Returns the lock trailer from the System properties. Subclasses override this method to provide database specific trailer.

Overrides:

getSqlVariantLockTrailer in class SQL92SQLBuilderImpl

Returns:

SQL clause to lock a row in the database.

getDbTimeQuery

public java.lang.String getDbTimeQuery()

Description copied from class: BaseSQLBuilderImpl

Returns a SQL statement to obtain the current time from the database.

Overrides:

getDbTimeQuery in class SQL92SQLBuilderImpl

isNewLineAllowedInSQL

public boolean isNewLineAllowedInSQL(java.sql.Connection conn)

Description copied from interface: SQLBuilder

Checks if the JDBC driver supports new line character in SQL statements. Over-ridden by DB2SQLBuilderImpl to return false when using DB2 Universal Driver (Type IV).

Specified by:

isNewLineAllowedInSQL in interface SQLBuilder

Overrides:

isNewLineAllowedInSQL in class BaseSQLBuilderImpl

getConstraintsList

public com.sun.java.util.collections.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

Description copied from interface: SQLBuilder

Return vector with constraint details for this table where each detail is in a String array with this structure: 0 String owner

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.

Specified by:

getConstraintsList in interface SQLBuilder

Overrides:

getConstraintsList in class BaseSQLBuilderImpl

Throws:

java.sql.SQLException