oracle.jbo.server
Class OracleSQLBuilderImpl

java.lang.Object
oracle.jbo.common.CommonCriteriaAdapter
oracle.jbo.server.BaseSQLBuilderImpl
oracle.jbo.server.OracleSQLBuilderImpl

All Implemented Interfaces:

SQLBuilder, ViewCriteriaAdapter

public class OracleSQLBuilderImpl

extends BaseSQLBuilderImpl

Oracle specific implementation of the SQLBuilder interface.

Since:

JDeveloper 3.0

Field Summary

protected static java.lang.String

ORACLE_ROWID_COLUMN Oracle specific column name for ROWID.

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

protected

OracleSQLBuilderImpl() This is a singleton class.

Method Summary

protected static java.lang.String	addSqlTypeText(java.lang.String sqlText, java.lang.String inputType) A helper method for getTableList.
int	bindInsertStatement(EntityImpl entityContext, java.sql.PreparedStatement stmt, AttributeDefImpl[] cols, AttributeDefImpl[] retrCols, AttributeDefImpl[] retrKeyCols, com.sun.java.util.collections.HashMap retrList, boolean batchMode) Binds the entity attribute storage with the parameters in the INSERT statement.
protected int	bindParamValue(int bindingStyle, java.lang.Object value, DBTransactionImpl trans, java.sql.PreparedStatement stmt, AttributeDefImpl attrDef, int bindIndex, boolean skipNull) Binds a parameter value to the Statement's bind index dealing with Null values appropriately.
int	bindUpdateStatement(EntityImpl entityContext, java.sql.PreparedStatement stmt, AttributeDefImpl[] cols, AttributeDefImpl[] retrCols, AttributeDefImpl[] retrKeyCols, com.sun.java.util.collections.HashMap retrList, boolean batchMode) Binds the entity attribute storage with the parameters in the UPDATE statement.
protected int	bindWhereAttrValue(EntityImpl entityContext, DBTransactionImpl trans, java.sql.PreparedStatement stmt, AttributeDefImpl attrDef, int bindIndex, boolean skipNull) Binds an attribute value to the Statement's WHERE clause parameter index dealing with Null values appropriately.
java.lang.StringBuffer	buildDeleteStatement(EntityImpl entityContext) Build a DELETE SQL for the Entity Object.
java.lang.StringBuffer	buildInsertStatement(EntityImpl entityContext, AttributeDefImpl[] cols, AttributeDefImpl[] retrCols, AttributeDefImpl[] retrKeyCols, boolean batchMode) Build a INSERT SQL for the Entity Object skipping non-persistent values.
void	buildOptUpdateWhereClause(EntityImpl entityContext, java.lang.StringBuffer buffer, AttributeDefImpl[] cols) This method binds the unfetched attributes in the list or the change indicator column of an entity definition.
protected void	buildReturningClause(java.lang.StringBuffer sqlBuffer, DBTransactionImpl trans, AttributeDefImpl[] retrCols, AttributeDefImpl[] retrKeyCols, boolean batchMode, boolean oracleBinding) Create a statement to use the RETURNING clause for the entity attributes that need to be fetched after a successful INSERT or UPDATE.
void	buildSelectList(java.lang.StringBuffer buffer, AttributeDefImpl[] attrs, java.lang.String sourceName) Build a list of columns that could be used in a SELECT statement.
void	buildSelectString(DBTransactionImpl trans, java.lang.StringBuffer buffer, java.lang.String sourceName, java.lang.String sourceAlias, AttributeDefImpl[] attrs, boolean withIntoClause, int bindingStyle) Construct a SQL SELECT statement for the Entity into the designated Buffer.
java.lang.StringBuffer	buildUpdateStatement(EntityImpl entityContext, AttributeDefImpl[] cols, AttributeDefImpl[] retrCols, AttributeDefImpl[] retrKeyCols, boolean batchMode) Build a UPDATE SQL for the Entity Object skipping non-persistent values.
void	buildWhereClause(EntityImpl entityContext, java.lang.StringBuffer buffer, AttributeDefImpl[] keyCols, java.lang.Object rowid) Creates a WHERE clause containing the Primary Key columns passed to the method.
boolean	compareFetchedValue(EntityImpl entity, AttributeDefImpl ad, java.lang.Object cacheValue, java.lang.Object fetchedValue) Overridden for Oracle because in OracleDB, in cache we may have "" string that was posted and DB assumes that string as null and returns null on fetch again.
java.lang.Object	convertValueToStorageType(java.lang.Object value) This method is used to convert the Java type to a JDBC type so that it could be used to bind as a parameter for SQL execution.
void	doEntityDML(EntityImpl entityContext, int operation, TransactionEvent e) Performs the appropriate SQL Data Manipulation Language (DML) operations on the database to reflect an update, delete or insert operation on an Entity Object.
void	doEntitySelect(EntityImpl entityContext, boolean lock) Perform the appropriate SQL operations to execute a select operation on an Entity Object.
java.lang.Object[]	doLoadBulkFromResultSet(AttributeDefImpl[] attrDefs, int attrIndex, java.sql.ResultSet rs, int index, DBTransactionImpl trans) Loads an array of objects from a result set.
java.lang.Object	doLoadFromResultSet(java.lang.Object theTypeFactory, java.lang.Object theElemFactory, java.lang.Class theJavaType, byte attrLoad, java.sql.ResultSet rs, int index, DBTransactionImpl trans) Loads an object from a result set.
java.lang.Object	doLoadFromStatement(java.lang.Object theTypeFactory, java.lang.Object theElemFactory, java.lang.Class theJavaType, java.sql.PreparedStatement ps, int index, Transaction trans) Loads an object from a result set.
void	doPreparedStatementDefineColumnType(java.sql.PreparedStatement ps, int colnum, int sqltype) Performs the equivalent of defineColumnType() on a prepared statement.
void	doPreparedStatementDefines(java.sql.PreparedStatement stmt, AttributeDefImpl[] columns) Defines the column types of the attributes based on the meta-data.
void	doStatementSetBindingStyle(java.sql.Statement ps, int bindingStyle) Sets the binding style for the statement.
void	doStatementSetBindingStyleDefault(java.sql.Statement ps) Sets the binding style to the default value of the database type.
void	doStatementSetRowPrefetch(java.sql.Statement ps, int prefetchSize) Performs the equivalent of setRowPrefetch() on a statement.
void	executeBatch(java.sql.PreparedStatement stmt) Executes the PreparedStatement in batch mode.
java.lang.Object	generatePKBasedRef(EntityImpl entityContext) Generates a PK-Based REF for an Entity Object.
java.lang.Object[]	generateRefAndOID(EntityImpl entityContext) Generates an object Ref and OID for an Entity Object.
java.lang.String	getBaseTable(java.sql.Connection conn, java.lang.String schema, java.lang.String name) Unroll any synonyms that may be present, and get the real objectname.
com.sun.java.util.collections.ArrayList	getConstraintsList(java.sql.Connection conn, java.lang.String catalog, java.lang.String schema, java.lang.String table) 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	getCreateSequenceInsertTriggerSQL(java.lang.String triggerName, java.lang.String tableName, java.lang.String sequenceName, java.lang.String colName) Returns a SQL statement that creates a trigger that updates a column with the value from a sequence upon the creation of a new row.
java.lang.String	getCreateSequenceSQL(java.lang.String sequenceName, int startVal) Returns a SQL statement that creates a Sequence with an initial value specified in the argument.
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.
int	getDefaultBindingStyle() Default binding style for this SQLBuilder is Oracle Named parameters.
java.lang.String	getDropSequenceSQL(java.lang.String sequenceName) Returns a SQL statement that drops a specified Sequence.
java.lang.String	getDropTableSQL(java.lang.String dbObjectName) Returns a SQL statement that drops a specified table.
protected java.lang.String	getFormattedLHSCompareFragment(ViewObject vo, ViewCriteria vc, AttributeDef attrDef, int sqltype, java.lang.String lhs, java.lang.Object rhs) Override this method to provide a formatted left-hand-comparator fragment of a comparision in a where clause for the given column.
protected java.lang.String	getFormattedRHSCompareFragment(ViewObject vo, ViewCriteria vc, AttributeDef attrDef, int sqlType, java.lang.String rhs) Override this method to provide a formatted right-hand-comparator fragment of a comparision in a where clause for the given column.
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.
com.sun.java.util.collections.ArrayList	getNestedTables(java.sql.Connection conn) Returns a list of nested tables in this connection.
java.lang.String	getPersistManagerClassName() Returns the name of default PersistManager class name.
protected java.lang.Object	getROWID(EntityImpl entityContext) Get the ROWID attribute.
java.util.Vector	getSchemaList(java.sql.Connection connection) Return a list of schemas for this database (note that for Oracle this is synonymous with users)
protected java.lang.String	getSqlVariantLockTrailer() This defines the string that will be post-fixed to SQL statements to have the rows locked - if the DB is incapable of this then it should return null.
protected java.lang.String	getSqlVariantLockTrailer(EntityImpl entityContext) Invokes the default getSqlVariantLockTrailer() method.
protected static java.lang.String	getTableListSqlStatement(java.lang.String defaultUserName, java.lang.String userName, boolean bTable, boolean bAlias, boolean bView, boolean bSnap, boolean bCount) A helper method for getTableList.
protected static java.lang.String	getTableListSqlStatement(java.lang.String defaultUserName, java.lang.String userName, boolean bTable, boolean bAlias, boolean bView, boolean bSnap, boolean bCount, boolean bIncludeNested) A helper method for getTableList.
com.sun.java.util.collections.ArrayList	getTables(java.sql.Connection conn, java.lang.String defaultUserName, java.lang.String userName, boolean bTable, boolean bAlias, boolean bView, boolean bSnap) Return a list of tables visible in this connection.
com.sun.java.util.collections.ArrayList	getTables(java.sql.Connection conn, java.lang.String defaultUserName, java.lang.String userName, boolean bTable, boolean bAlias, boolean bView, boolean bSnap, boolean bIncludeNested) Return a list of tables visible in this connection.
java.lang.String	getTypeMapName() The default type map for a Oracle database is ORACLE.
java.lang.String	getVersion() Gets a string describing the version of this implentation of this interface.
boolean	invalidDatumFactoryUsage(java.lang.String colType, int id, java.lang.Class clz) Returns false only for types where raw-bytes may be used to create the desired attribute values while fetching data from jdbc.
boolean	isConnectionAlive(java.sql.Connection conn) Detects if a connection is alive.
boolean	isDisplayBindValueUI() For Oracle database the test SQL wizards provide additional functionality to bind the parameters with test values.
boolean	isStreamType(int sqlTypeId) Check if a given type provides streaming support.
void	jdbcClientSideSecurity(java.util.Properties info, java.util.Hashtable env) Populates the properties with known security attributes found in the environment.
protected boolean	needsQuotedTableName(java.lang.String tableName) Inspects the table name if it needs to be escaped with quotes.
void	processException(java.lang.String errorCode, java.lang.Exception sqlEx, java.lang.Object[] params) Handle SQL exceptions by wrapping into SQLStmtException or JboException.
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.
boolean	supportsReturningClause() Oracle database supports RETURNING clause.
boolean	supportsRowNumQuery() Oracle database supports rownum in a query.

Methods inherited from class oracle.jbo.server.BaseSQLBuilderImpl

baseBuildSelectList, bindDeleteStatement, bindOptUpdateWhereClause, bindParametersForStmt, bindWhereClause, bindWhereClause, buildSelectList, buildSelectString, capabilityCanReuseLockStatements, checkTableNameForQuotes, convertFlags, convertValueToWhereFragment, convertValueToWhereFragment, createHandleForCancellableStatements, doRefreshSQL, doRegisterDefaultDriver, dumpConstraint, formatAttributeValue, generateRowID, getColumnNameWithFormatForQuery, getConstraints, getCurrentDbTime, getFormattedLHSCompareFragment, getFormattedLHSCompareFragment, getFormattedRHSCompareFragment, getFormattedRHSCompareFragment, getLockTrailerIsAtEnd, getMaxTableNameLength, getQueryHitCountSQL, getQuotationMarkLeft, getQuotationMarkRight, getSchemas, getSupportsAliasInUpdateStatements, getTableList, getTableList, getViewCriteriaAdapter, getViewCriteriaClause, getWarningText, isDataSourceJTABased, isNewLineAllowedInSQL, lookupDataSource, populateJboTypeMapEntries, shouldSkipDML

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

Field Detail

ORACLE_ROWID_COLUMN

protected static final java.lang.String ORACLE_ROWID_COLUMN

Oracle specific column name for ROWID.

See Also:

Constant Field Values

Constructor Detail

OracleSQLBuilderImpl

protected OracleSQLBuilderImpl()

This is a singleton class.

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

Specified by:

getVersion in class BaseSQLBuilderImpl

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

Specified by:

getDbType in class BaseSQLBuilderImpl

getTypeMapName

public java.lang.String getTypeMapName()

The default type map for a Oracle database is ORACLE.

Specified by:

getTypeMapName in interface SQLBuilder

Specified by:

getTypeMapName in class BaseSQLBuilderImpl

Returns:

PropertyConstants.ORACLE constant.

getNestedTables

public com.sun.java.util.collections.ArrayList getNestedTables(java.sql.Connection conn)
                                                        throws java.sql.SQLException

Description copied from interface: SQLBuilder

Returns a list of nested tables in this connection.

Note: this method is subject to change.

Specified by:

getNestedTables in interface SQLBuilder

Overrides:

getNestedTables in class BaseSQLBuilderImpl

Throws:

java.sql.SQLException

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

Specified by:

getPersistManagerClassName in class BaseSQLBuilderImpl

getDefaultBindingStyle

public int getDefaultBindingStyle()

Default binding style for this SQLBuilder is Oracle Named parameters.

Specified by:

getDefaultBindingStyle in interface SQLBuilder

Overrides:

getDefaultBindingStyle in class BaseSQLBuilderImpl

Returns:

a SQLBuilder.BINDING_STYLE_ORACLE_NAME constant.

executeBatch

public void executeBatch(java.sql.PreparedStatement stmt)
                  throws java.sql.SQLException

Description copied from interface: SQLBuilder

Executes the PreparedStatement in batch mode. Implemented for Oracle database only by invoking OraclePreparedStatement.executeBatch. Other database flavors throw an exception.

Note: this method is subject to change.

Specified by:

executeBatch in interface SQLBuilder

Overrides:

executeBatch in class BaseSQLBuilderImpl

Throws:

java.sql.SQLException

doEntityDML

public void doEntityDML(EntityImpl entityContext,
                        int operation,
                        TransactionEvent e)

Description copied from interface: SQLBuilder

Performs the appropriate SQL Data Manipulation Language (DML) operations on the database to reflect an update, delete or insert operation on an Entity Object.

Note: this method is subject to change.

Specified by:

doEntityDML in interface SQLBuilder

Overrides:

doEntityDML in class BaseSQLBuilderImpl

doEntitySelect

public void doEntitySelect(EntityImpl entityContext,
                           boolean lock)

Description copied from interface: SQLBuilder

Perform the appropriate SQL operations to execute a select operation on an Entity Object.

Note: this method is subject to change. Note: this method is subject to change.

Specified by:

doEntitySelect in interface SQLBuilder

Overrides:

doEntitySelect in class BaseSQLBuilderImpl

doStatementSetRowPrefetch

public void doStatementSetRowPrefetch(java.sql.Statement ps,
                                      int prefetchSize)
                               throws java.sql.SQLException

Description copied from interface: SQLBuilder

Performs the equivalent of setRowPrefetch() on a statement.

Specified by:

doStatementSetRowPrefetch in interface SQLBuilder

Overrides:

doStatementSetRowPrefetch in class BaseSQLBuilderImpl

Throws:

java.sql.SQLException

doStatementSetBindingStyle

public void doStatementSetBindingStyle(java.sql.Statement ps,
                                       int bindingStyle)

Description copied from interface: SQLBuilder

Sets the binding style for the statement.

Specified by:

doStatementSetBindingStyle in interface SQLBuilder

Overrides:

doStatementSetBindingStyle in class BaseSQLBuilderImpl

doStatementSetBindingStyleDefault

public void doStatementSetBindingStyleDefault(java.sql.Statement ps)

Description copied from interface: SQLBuilder

Sets the binding style to the default value of the database type. For Oracle database it is set to BINDING_STYLE_ORACLE and for non-oracle databases it is set to BINDING_STYLE_JDBC.

Note: this method is subject to change.

Specified by:

doStatementSetBindingStyleDefault in interface SQLBuilder

Overrides:

doStatementSetBindingStyleDefault in class BaseSQLBuilderImpl

doPreparedStatementDefineColumnType

public void doPreparedStatementDefineColumnType(java.sql.PreparedStatement ps,
                                                int colnum,
                                                int sqltype)
                                         throws java.sql.SQLException

Description copied from interface: SQLBuilder

Performs the equivalent of defineColumnType() on a prepared statement.

Note: this method is subject to change.

Specified by:

doPreparedStatementDefineColumnType in interface SQLBuilder

Overrides:

doPreparedStatementDefineColumnType in class BaseSQLBuilderImpl

Throws:

java.sql.SQLException

doPreparedStatementDefines

public void doPreparedStatementDefines(java.sql.PreparedStatement stmt,
                                       AttributeDefImpl[] columns)

Description copied from interface: SQLBuilder

Defines the column types of the attributes based on the meta-data.

Note: this method is subject to change.

Specified by:

doPreparedStatementDefines in interface SQLBuilder

Overrides:

doPreparedStatementDefines in class BaseSQLBuilderImpl

doLoadFromResultSet

public java.lang.Object doLoadFromResultSet(java.lang.Object theTypeFactory,
                                            java.lang.Object theElemFactory,
                                            java.lang.Class theJavaType,
                                            byte attrLoad,
                                            java.sql.ResultSet rs,
                                            int index,
                                            DBTransactionImpl trans)

Description copied from interface: SQLBuilder

Loads an object from a result set.

Note: this method is subject to change.

Specified by:

doLoadFromResultSet in interface SQLBuilder

Overrides:

doLoadFromResultSet in class BaseSQLBuilderImpl

doLoadBulkFromResultSet

public java.lang.Object[] doLoadBulkFromResultSet(AttributeDefImpl[] attrDefs,
                                                  int attrIndex,
                                                  java.sql.ResultSet rs,
                                                  int index,
                                                  DBTransactionImpl trans)

Description copied from interface: SQLBuilder

Loads an array of objects from a result set.

Note: this method is subject to change.

Specified by:

doLoadBulkFromResultSet in interface SQLBuilder

Overrides:

doLoadBulkFromResultSet in class BaseSQLBuilderImpl

doLoadFromStatement

public java.lang.Object doLoadFromStatement(java.lang.Object theTypeFactory,
                                            java.lang.Object theElemFactory,
                                            java.lang.Class theJavaType,
                                            java.sql.PreparedStatement ps,
                                            int index,
                                            Transaction trans)

Description copied from interface: SQLBuilder

Loads an object from a result set.

Note: this method is subject to change.

Specified by:

doLoadFromStatement in interface SQLBuilder

Overrides:

doLoadFromStatement in class BaseSQLBuilderImpl

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

supportsReturningClause

public boolean supportsReturningClause()

Oracle database supports RETURNING clause.

Specified by:

supportsReturningClause in interface SQLBuilder

Overrides:

supportsReturningClause in class BaseSQLBuilderImpl

Returns:

true.

supportsRowNumQuery

public boolean supportsRowNumQuery()

Oracle database supports rownum in a query.

Specified by:

supportsRowNumQuery in interface SQLBuilder

Overrides:

supportsRowNumQuery in class BaseSQLBuilderImpl

Returns:

true.

buildUpdateStatement

public java.lang.StringBuffer buildUpdateStatement(EntityImpl entityContext,
                                                   AttributeDefImpl[] cols,
                                                   AttributeDefImpl[] retrCols,
                                                   AttributeDefImpl[] retrKeyCols,
                                                   boolean batchMode)

Description copied from interface: SQLBuilder

Build a UPDATE SQL for the Entity Object skipping non-persistent values. If there are attributes in the Entity Object that need to be fetched after the UPDATE succeeds, a CallableStatement is created to fetch those values.

Note: this method is subject to change.

Specified by:

buildUpdateStatement in interface SQLBuilder

Overrides:

buildUpdateStatement in class BaseSQLBuilderImpl

buildReturningClause

protected void buildReturningClause(java.lang.StringBuffer sqlBuffer,
                                    DBTransactionImpl trans,
                                    AttributeDefImpl[] retrCols,
                                    AttributeDefImpl[] retrKeyCols,
                                    boolean batchMode,
                                    boolean oracleBinding)

Create a statement to use the RETURNING clause for the entity attributes that need to be fetched after a successful INSERT or UPDATE. If using the RETURNING clause is not feasible a Callable Statement with two SQL Statements is used. RETURNING clause is not generated for batch mode.

Parameters:

sqlBuffer - the StringBuffer object to which the RETURNING clause is appended.

trans - the transaction object

retrCols - the Columns whose values need to be fetched after the entity DML succeeds.

retrKeyCols - the Columns that are used as Keys to fetch the values.

batchMode - indicates if the SQL is being generated for batch mode.

oracleBinding - indicates the binding style to use.

bindInsertStatement

public int bindInsertStatement(EntityImpl entityContext,
                               java.sql.PreparedStatement stmt,
                               AttributeDefImpl[] cols,
                               AttributeDefImpl[] retrCols,
                               AttributeDefImpl[] retrKeyCols,
                               com.sun.java.util.collections.HashMap retrList,
                               boolean batchMode)
                        throws java.sql.SQLException

Description copied from interface: SQLBuilder

Binds the entity attribute storage with the parameters in the INSERT statement.

Note: this method is subject to change.

Specified by:

bindInsertStatement in interface SQLBuilder

Overrides:

bindInsertStatement in class BaseSQLBuilderImpl

Throws:

java.sql.SQLException

bindUpdateStatement

public int bindUpdateStatement(EntityImpl entityContext,
                               java.sql.PreparedStatement stmt,
                               AttributeDefImpl[] cols,
                               AttributeDefImpl[] retrCols,
                               AttributeDefImpl[] retrKeyCols,
                               com.sun.java.util.collections.HashMap retrList,
                               boolean batchMode)
                        throws java.sql.SQLException

Description copied from interface: SQLBuilder

Binds the entity attribute storage with the parameters in the UPDATE statement.

Note: this method is subject to change.

Specified by:

bindUpdateStatement in interface SQLBuilder

Overrides:

bindUpdateStatement in class BaseSQLBuilderImpl

Throws:

java.sql.SQLException

bindWhereAttrValue

protected int bindWhereAttrValue(EntityImpl entityContext,
                                 DBTransactionImpl trans,
                                 java.sql.PreparedStatement stmt,
                                 AttributeDefImpl attrDef,
                                 int bindIndex,
                                 boolean skipNull)
                          throws java.sql.SQLException

Description copied from class: BaseSQLBuilderImpl

Binds an attribute value to the Statement's WHERE clause parameter index dealing with Null values appropriately. The attribute value is not yet poupulated in the Entity definition it is fetched and then bound.

Overrides:

bindWhereAttrValue in class BaseSQLBuilderImpl

Parameters:

entityContext - the entity object.

trans - the transaction object.

stmt - the Statement object carrying out the SQL.

attrDef - the defintion of the attribute to which the value belongs.

bindIndex - the parameter index in the PreparedStatement.

skipNull - indicates if the null values need to be bound or skipped.

Returns:

a new bind index value so that this method can be invoked in a loop.

Throws:

java.sql.SQLException

getROWID

protected java.lang.Object getROWID(EntityImpl entityContext)

Description copied from class: BaseSQLBuilderImpl

Get the ROWID attribute. The ROWID attribute can be used to gain faster access to the underyling database data. Obtain the value for the ROWID attribute. If this entity doesn't support ROWID attributes, then return NULL. If, for some reason the value of the ROWID attribute isn't present, then return null.

Overrides:

getROWID in class BaseSQLBuilderImpl

Parameters:

entityContext - the entity object.

Returns:

the value of the ROWID attribute or null if not present or applicable to this entity.

buildWhereClause

public void buildWhereClause(EntityImpl entityContext,
                             java.lang.StringBuffer buffer,
                             AttributeDefImpl[] keyCols,
                             java.lang.Object rowid)

Description copied from interface: SQLBuilder

Creates a WHERE clause containing the Primary Key columns passed to the method.

Note: this method is subject to change.

Specified by:

buildWhereClause in interface SQLBuilder

Overrides:

buildWhereClause in class BaseSQLBuilderImpl

buildOptUpdateWhereClause

public void buildOptUpdateWhereClause(EntityImpl entityContext,
                                      java.lang.StringBuffer buffer,
                                      AttributeDefImpl[] cols)

Description copied from class: BaseSQLBuilderImpl

This method binds the unfetched attributes in the list or the change indicator column of an entity definition.

Overrides:

buildOptUpdateWhereClause in class BaseSQLBuilderImpl

Parameters:

entityContext - the entity definition.

buffer - the storage for the WHERE clause.

cols - the attributes to be considered for fetching.

buildInsertStatement

public java.lang.StringBuffer buildInsertStatement(EntityImpl entityContext,
                                                   AttributeDefImpl[] cols,
                                                   AttributeDefImpl[] retrCols,
                                                   AttributeDefImpl[] retrKeyCols,
                                                   boolean batchMode)

Description copied from interface: SQLBuilder

Build a INSERT SQL for the Entity Object skipping non-persistent values. If there are attributes in the Entity Object that need to be fetched after the INSERT succeeds, a CallableStatement is created to fetch those values.

Note: this method is subject to change.

Specified by:

buildInsertStatement in interface SQLBuilder

Overrides:

buildInsertStatement in class BaseSQLBuilderImpl

buildDeleteStatement

public java.lang.StringBuffer buildDeleteStatement(EntityImpl entityContext)

Description copied from interface: SQLBuilder

Build a DELETE SQL for the Entity Object. The row is deleted from the table using the values of the Primary keys defined in the Entity.

Note: this method is subject to change.

Specified by:

buildDeleteStatement in interface SQLBuilder

Overrides:

buildDeleteStatement in class BaseSQLBuilderImpl

buildSelectList

public void buildSelectList(java.lang.StringBuffer buffer,
                            AttributeDefImpl[] attrs,
                            java.lang.String sourceName)

Build a list of columns that could be used in a SELECT statement.

Note: this method is subject to change.

Parameters:

buffer - the StringBuffer object to which the SELECT list is appended.

attrs - the list of attribute definitions to be considered for the SELECT list.

sourceName - the database object name that contains the attributes.

buildSelectString

public void buildSelectString(DBTransactionImpl trans,
                              java.lang.StringBuffer buffer,
                              java.lang.String sourceName,
                              java.lang.String sourceAlias,
                              AttributeDefImpl[] attrs,
                              boolean withIntoClause,
                              int bindingStyle)

Description copied from interface: SQLBuilder

Construct a SQL SELECT statement for the Entity into the designated Buffer. This routine will construct a SQL SELECT statement in the StringBuffer passed. It does this by appending the various components of the SELECT statement into the buffer area.

Note: this method is subject to change.

Specified by:

buildSelectString in interface SQLBuilder

Overrides:

buildSelectString in class BaseSQLBuilderImpl

generatePKBasedRef

public java.lang.Object generatePKBasedRef(EntityImpl entityContext)

Description copied from interface: SQLBuilder

Generates a PK-Based REF for an Entity Object. This is used for an object table.

Note: this method is subject to change.

Specified by:

generatePKBasedRef in interface SQLBuilder

Overrides:

generatePKBasedRef in class BaseSQLBuilderImpl

generateRefAndOID

public java.lang.Object[] generateRefAndOID(EntityImpl entityContext)

Description copied from interface: SQLBuilder

Generates an object Ref and OID for an Entity Object. This is used for an object table.

Note: this method is subject to change.

Specified by:

generateRefAndOID in interface SQLBuilder

Overrides:

generateRefAndOID in class BaseSQLBuilderImpl

isStreamType

public boolean isStreamType(int sqlTypeId)

Description copied from interface: SQLBuilder

Check if a given type provides streaming support.

Note: this method is subject to change.

Specified by:

isStreamType in interface SQLBuilder

Overrides:

isStreamType in class BaseSQLBuilderImpl

getSchemaList

public java.util.Vector getSchemaList(java.sql.Connection connection)
                               throws java.lang.Exception

Description copied from interface: SQLBuilder

Return a list of schemas for this database (note that for Oracle this is synonymous with users)

Note: this method is subject to change.

Specified by:

getSchemaList in interface SQLBuilder

Overrides:

getSchemaList in class BaseSQLBuilderImpl

Throws:

java.lang.Exception

getTables

public com.sun.java.util.collections.ArrayList getTables(java.sql.Connection conn,
                                                         java.lang.String defaultUserName,
                                                         java.lang.String userName,
                                                         boolean bTable,
                                                         boolean bAlias,
                                                         boolean bView,
                                                         boolean bSnap)
                                                  throws java.lang.Exception

Description copied from interface: SQLBuilder

Return a list of tables visible in this connection.

Note: this method is subject to change.

Specified by:

getTables in interface SQLBuilder

Overrides:

getTables in class BaseSQLBuilderImpl

Throws:

java.lang.Exception

getTables

public com.sun.java.util.collections.ArrayList getTables(java.sql.Connection conn,
                                                         java.lang.String defaultUserName,
                                                         java.lang.String userName,
                                                         boolean bTable,
                                                         boolean bAlias,
                                                         boolean bView,
                                                         boolean bSnap,
                                                         boolean bIncludeNested)
                                                  throws java.lang.Exception

Description copied from interface: SQLBuilder

Return a list of tables visible in this connection. Same as getTables(Connection, String, String, boolean, boolean, boolean, boolean) with an additional parameter to fetch nested tables. Nested tables are fetched only for Oracle database and OLite.

Note: this method is subject to change.

Specified by:

getTables in interface SQLBuilder

Overrides:

getTables in class BaseSQLBuilderImpl

Throws:

java.lang.Exception

needsQuotedTableName

protected boolean needsQuotedTableName(java.lang.String tableName)

Description copied from class: BaseSQLBuilderImpl

Inspects the table name if it needs to be escaped with quotes.

Overrides:

needsQuotedTableName in class BaseSQLBuilderImpl

Parameters:

tableName - the table name.

Returns:

true if quotes are needed, false otherwise.

getTableListSqlStatement

protected static java.lang.String getTableListSqlStatement(java.lang.String defaultUserName,
                                                           java.lang.String userName,
                                                           boolean bTable,
                                                           boolean bAlias,
                                                           boolean bView,
                                                           boolean bSnap,
                                                           boolean bCount)

A helper method for getTableList. Generates the SQL statement for selecting different object types from the database.

Parameters:

defaultUserName - the user name of the connection. This is will also be treated as the schema name for non-oracle databases.

userName - the user name for which the tables need to be listed.

bTable - flag to include Table objects in the list.

bAlias - flag to include Synonyms in the list - Oracle database only.

bView - flag to include View objects in the list.

bSnap - flag to include Snapshot objects in the list.

bCount - flag to retrieve the number of objects that will be fetched based on the object type flags.

Returns:

a SQL Statement that could be used to fetch the list of objects from the database.

getTableListSqlStatement

protected static java.lang.String getTableListSqlStatement(java.lang.String defaultUserName,
                                                           java.lang.String userName,
                                                           boolean bTable,
                                                           boolean bAlias,
                                                           boolean bView,
                                                           boolean bSnap,
                                                           boolean bCount,
                                                           boolean bIncludeNested)

A helper method for getTableList. Generates the SQL statement for selecting different object types from the database.

Parameters:

defaultUserName - the user name of the connection. This is will also be treated as the schema name for non-oracle databases.

userName - the user name for which the tables need to be listed.

bTable - flag to include Table objects in the list.

bAlias - flag to include Synonyms in the list - Oracle database only.

bView - flag to include View objects in the list.

bSnap - flag to include Snapshot objects in the list.

bCount - flag to retrieve the number of objects that will be fetched based on the object type flags.

bIncludeNested - flag to include nested tables.

Returns:

a SQL Statement that could be used to fetch the list of objects from the database.

addSqlTypeText

protected static java.lang.String addSqlTypeText(java.lang.String sqlText,
                                                 java.lang.String inputType)

A helper method for getTableList. Adds a clause to select a different object type to the list.

Parameters:

sqlText - a String containing a list of object types included so far.

inputType - a new object type to be added to the list.

Returns:

an updated object type list.

getConstraintsList

public com.sun.java.util.collections.ArrayList getConstraintsList(java.sql.Connection conn,
                                                                  java.lang.String catalog,
                                                                  java.lang.String schema,
                                                                  java.lang.String table)
                                                           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

getBaseTable

public java.lang.String getBaseTable(java.sql.Connection conn,
                                     java.lang.String schema,
                                     java.lang.String name)
                              throws java.sql.SQLException

Description copied from interface: SQLBuilder

Unroll any synonyms that may be present, and get the real objectname.

Note: this method is subject to change.

Specified by:

getBaseTable in interface SQLBuilder

Overrides:

getBaseTable in class BaseSQLBuilderImpl

Throws:

java.sql.SQLException

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.

Specified by:

getJDBCDriverClassName in class BaseSQLBuilderImpl

Parameters:

url - JDBC Connection url.

Returns:

the default driver class name based on the url and database flavor.

getFormattedRHSCompareFragment

protected java.lang.String getFormattedRHSCompareFragment(ViewObject vo,
                                                          ViewCriteria vc,
                                                          AttributeDef attrDef,
                                                          int sqlType,
                                                          java.lang.String rhs)

Description copied from class: BaseSQLBuilderImpl

Override this method to provide a formatted right-hand-comparator fragment of a comparision in a where clause for the given column.

Overrides:

getFormattedRHSCompareFragment in class BaseSQLBuilderImpl

Parameters:

vo - the view object definition.

vc - the view criteria definition.

attrDef - the definition of the attribute.

sqlType - the type of the attribute value.

rhs - the value of the attribute.

Returns:

a String containing the SQL fragment.

getFormattedLHSCompareFragment

protected java.lang.String getFormattedLHSCompareFragment(ViewObject vo,
                                                          ViewCriteria vc,
                                                          AttributeDef attrDef,
                                                          int sqltype,
                                                          java.lang.String lhs,
                                                          java.lang.Object rhs)

Description copied from class: BaseSQLBuilderImpl

Override this method to provide a formatted left-hand-comparator fragment of a comparision in a where clause for the given column.

Overrides:

getFormattedLHSCompareFragment in class BaseSQLBuilderImpl

Parameters:

vo - the view object definition.

vc - the view criteria definition.

attrDef - the definition of the attribute.

sqltype - the type of the attribute value.

rhs - the value of the attribute.

Returns:

a String containing the SQL fragment.

getSqlVariantLockTrailer

protected java.lang.String getSqlVariantLockTrailer(EntityImpl entityContext)

Invokes the default getSqlVariantLockTrailer() method.

Parameters:

entityContext - - currently unused.

Returns:

the row locking clause.

getSqlVariantLockTrailer

protected java.lang.String getSqlVariantLockTrailer()

Description copied from class: BaseSQLBuilderImpl

This defines the string that will be post-fixed to SQL statements to have the rows locked - if the DB is incapable of this then it should return null. Examples are: SQL Server - "WITH (HOLDLOCK)" Oracle - "FOR UPDATE NOWAIT"

Overrides:

getSqlVariantLockTrailer in class BaseSQLBuilderImpl

Returns:

the lock clause.

getDbTimeQuery

public java.lang.String getDbTimeQuery()

Description copied from class: BaseSQLBuilderImpl

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

Specified by:

getDbTimeQuery in class BaseSQLBuilderImpl

Returns:

a String containing the SQL statement.

getDropTableSQL

public java.lang.String getDropTableSQL(java.lang.String dbObjectName)

Description copied from interface: SQLBuilder

Returns a SQL statement that drops a specified table. For Oracle database it also deletes the constraints for the table.

Note: this method is subject to change.

Specified by:

getDropTableSQL in interface SQLBuilder

Specified by:

getDropTableSQL in class BaseSQLBuilderImpl

isDisplayBindValueUI

public boolean isDisplayBindValueUI()

Description copied from interface: SQLBuilder

For Oracle database the test SQL wizards provide additional functionality to bind the parameters with test values. For other databases this functionality is not supported.

Specified by:

isDisplayBindValueUI in interface SQLBuilder

Specified by:

isDisplayBindValueUI in class BaseSQLBuilderImpl

getCreateSequenceInsertTriggerSQL

public java.lang.String getCreateSequenceInsertTriggerSQL(java.lang.String triggerName,
                                                          java.lang.String tableName,
                                                          java.lang.String sequenceName,
                                                          java.lang.String colName)

Description copied from interface: SQLBuilder

Returns a SQL statement that creates a trigger that updates a column with the value from a sequence upon the creation of a new row.

Supported for Oracle database only.

Note: this method is subject to change.

Specified by:

getCreateSequenceInsertTriggerSQL in interface SQLBuilder

Specified by:

getCreateSequenceInsertTriggerSQL in class BaseSQLBuilderImpl

getCreateSequenceSQL

public java.lang.String getCreateSequenceSQL(java.lang.String sequenceName,
                                             int startVal)

Description copied from interface: SQLBuilder

Returns a SQL statement that creates a Sequence with an initial value specified in the argument.

Note: this method is subject to change.

Specified by:

getCreateSequenceSQL in interface SQLBuilder

Specified by:

getCreateSequenceSQL in class BaseSQLBuilderImpl

getDropSequenceSQL

public java.lang.String getDropSequenceSQL(java.lang.String sequenceName)

Description copied from interface: SQLBuilder

Returns a SQL statement that drops a specified Sequence.

Note: this method is subject to change.

Specified by:

getDropSequenceSQL in interface SQLBuilder

Specified by:

getDropSequenceSQL in class BaseSQLBuilderImpl

isConnectionAlive

public boolean isConnectionAlive(java.sql.Connection conn)

Description copied from interface: SQLBuilder

Detects if a connection is alive.

Specified by:

isConnectionAlive in interface SQLBuilder

Overrides:

isConnectionAlive in class BaseSQLBuilderImpl

convertValueToStorageType

public java.lang.Object convertValueToStorageType(java.lang.Object value)

Description copied from interface: SQLBuilder

This method is used to convert the Java type to a JDBC type so that it could be used to bind as a parameter for SQL execution.

Note: this method is subject to change.

Specified by:

convertValueToStorageType in interface SQLBuilder

Overrides:

convertValueToStorageType in class BaseSQLBuilderImpl

jdbcClientSideSecurity

public void jdbcClientSideSecurity(java.util.Properties info,
                                   java.util.Hashtable env)

Description copied from interface: SQLBuilder

Populates the properties with known security attributes found in the environment. Used for Oracle JDBC connectivity only. The values are copied into the Properties from the Session's environment.

Note: this method is subject to change.

Specified by:

jdbcClientSideSecurity in interface SQLBuilder

Overrides:

jdbcClientSideSecurity in class BaseSQLBuilderImpl

compareFetchedValue

public boolean compareFetchedValue(EntityImpl entity,
                                   AttributeDefImpl ad,
                                   java.lang.Object cacheValue,
                                   java.lang.Object fetchedValue)

Overridden for Oracle because in OracleDB, in cache we may have "" string that was posted and DB assumes that string as null and returns null on fetch again. This method should return true for such cases.

Specified by:

compareFetchedValue in interface SQLBuilder

Overrides:

compareFetchedValue in class BaseSQLBuilderImpl

Parameters:

entity - the entity object.

ad - the attribute definition of the value being compared.

cacheValue - the cached value.

fetchedValue - the new fetched value.

Returns:

true if the values are same, false otherwise.

bindParamValue

protected int bindParamValue(int bindingStyle,
                             java.lang.Object value,
                             DBTransactionImpl trans,
                             java.sql.PreparedStatement stmt,
                             AttributeDefImpl attrDef,
                             int bindIndex,
                             boolean skipNull)
                      throws java.sql.SQLException

Description copied from class: BaseSQLBuilderImpl

Binds a parameter value to the Statement's bind index dealing with Null values appropriately.

Overrides:

bindParamValue in class BaseSQLBuilderImpl

Parameters:

bindingStyle - one of the SQLBuilder binding style constants.

value - the object value to bind.

trans - the transaction object.

stmt - the Statement object carrying out the SQL.

attrDef - the defintion of the attribute to which the value belongs.

bindIndex - the parameter index in the PreparedStatement.

skipNull - indicates if the null values need to be bound or skipped.

Returns:

a new bind index value so that this method can be invoked in a loop.

Throws:

java.sql.SQLException

processException

public void processException(java.lang.String errorCode,
                             java.lang.Exception sqlEx,
                             java.lang.Object[] params)

Description copied from interface: SQLBuilder

Handle SQL exceptions by wrapping into SQLStmtException or JboException.

Note: this method is subject to change.

Specified by:

processException in interface SQLBuilder

Overrides:

processException in class BaseSQLBuilderImpl

invalidDatumFactoryUsage

public boolean invalidDatumFactoryUsage(java.lang.String colType,
                                        int id,
                                        java.lang.Class clz)

Returns false only for types where raw-bytes may be used to create the desired attribute values while fetching data from jdbc.

Specified by:

invalidDatumFactoryUsage in interface SQLBuilder

Overrides:

invalidDatumFactoryUsage in class BaseSQLBuilderImpl