|
Oracle Fusion Middleware Java API Reference for Oracle ADF Mobile Client 11g Release 1 (11.1.1) E17503-02 |
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectoracle.jbo.common.CommonCriteriaAdapter
oracle.jbo.server.BaseSQLBuilderImpl
public class BaseSQLBuilderImpl
Field Summary | |
---|---|
static java.lang.Class |
CLASS_INSTANCE
|
Fields inherited from class oracle.jbo.common.CommonCriteriaAdapter |
---|
BETWEEN, IN, IS, LIKE, LIKE_QOT, NOT, NULL, QOT, QOTSTR |
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 | |
---|---|
BaseSQLBuilderImpl()
|
Method Summary | |
---|---|
static void |
baseBuildSelectList(java.lang.StringBuffer buffer,
AttributeDefImpl[] attrs,
java.lang.String sourceName,
boolean forViewObject)
Creates a list of columns to be selected skipping the persistent and derived attributes. |
int |
bindDeleteStatement(EntityImpl entityContext,
PreparedStatement stmt)
Binds the values in the entity attribute storage with the DELETE statement. |
int |
bindInsertStatement(EntityImpl entityContext,
PreparedStatement stmt,
AttributeDefImpl[] cols,
AttributeDefImpl[] retrCols,
AttributeDefImpl[] retrKeyCols,
java.util.Hashtable retrList,
boolean batchMode)
Binds the entity attribute storage with the parameters in the INSERT statement. |
int |
bindInsertStatement(EntityImpl entityContext,
PreparedStatement stmt,
AttributeDefImpl[] cols,
AttributeDefImpl[] retrCols,
AttributeDefImpl[] retrKeyCols,
Map retrList,
boolean batchMode)
Binds the entity attribute storage with the parameters in the INSERT statement. |
int |
bindOptUpdateWhereClause(EntityImpl entityContext,
PreparedStatement stmt,
int bindIndex)
This method binds the unfetched attributes or a changed attribute of an entity definition. |
void |
bindParametersForStmt(int bindingStyle,
java.lang.Object[] params,
PreparedStatement stmt)
Bind parameter values for a SQL execution. |
protected int |
bindParamValue(int bindingStyle,
java.lang.Object value,
DBTransactionImpl trans,
PreparedStatement stmt,
AttributeDefImpl attrDef,
int bindIndex,
boolean skipNull)
|
int |
bindUpdateStatement(EntityImpl entityContext,
PreparedStatement stmt,
AttributeDefImpl[] cols,
AttributeDefImpl[] retrCols,
AttributeDefImpl[] retrKeyCols,
java.util.Hashtable retrList,
boolean batchMode)
Binds the entity attribute storage with the parameters in the UPDATE statement. |
int |
bindUpdateStatement(EntityImpl entityContext,
PreparedStatement stmt,
AttributeDefImpl[] cols,
AttributeDefImpl[] retrCols,
AttributeDefImpl[] retrKeyCols,
Map retrList,
boolean batchMode)
Binds the entity attribute storage with the parameters in the UPDATE statement. |
protected int |
bindWhereAttrValue(EntityImpl entityContext,
DBTransactionImpl trans,
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. |
int |
bindWhereClause(EntityImpl entityContext,
PreparedStatement stmt,
AttributeDefImpl[] keyCols,
java.lang.Object rowid,
int bindIndex)
Bind the Primary key values for the designated Statement. |
int |
bindWhereClause(EntityImpl entityContext,
PreparedStatement stmt,
java.lang.Object rowid,
int bindIndex)
|
void |
buildDefaultViewObjectFromClause(java.lang.StringBuffer fromClause,
Vector eRefs,
BaseViewCriteriaManagerImpl vcManager)
This method is used to generate the "from" clause if the following conditions are met: The View Object definition does not have an expert mode query The View Object definition is set to generate "from" clause during runtime, either in metadata or by calling ViewDefImpl.setFromClauseFlags(ViewDefImpl.CLAUSE_GENERATE_RT) |
void |
buildDefaultViewObjectWhereClause(java.lang.StringBuffer whereClause,
Vector eRefs)
This method is used to generate the "where" clause if the following conditions are met: The View Object definition does not specify "where" clause The View Object definition is set to generate "where" clause during runtime, either in metadata or by calling ViewDefImpl.setWhereClauseFlags(ViewDefImpl.CLAUSE_GENERATE_RT) |
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. |
void |
buildSelectList(java.lang.StringBuffer buffer,
AttributeDefImpl[] attrs,
java.lang.String sourceAlias,
boolean forViewObject)
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. |
protected void |
buildSelectString(java.lang.StringBuffer buffer,
java.lang.String sourceName,
AttributeDefImpl[] attrs,
boolean withIntoClause)
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. |
protected boolean |
capabilityCanReuseLockStatements()
Check if the a cached prepared statement to lock a row can be reused for this database flavor. |
boolean |
compareFetchedValue(EntityImpl entity,
AttributeDefImpl ad,
java.lang.Object cacheValue,
java.lang.Object fetchedValue)
Compare the cacheValue with fetchedValue and if they are equal return true This API is used when comparing cached entity with a faulted in entity. |
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. |
protected LongRunningStatementHandle |
createHandleForCancellableStatements(DBTransactionImpl trans,
Statement stmt)
Creates a handle that could be used later to terminate a long running statment. |
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. |
void |
doEntitySelectForAltKey(EntityImpl entityContext,
int keyIndex,
boolean lock)
|
java.lang.Object[] |
doLoadBulkFromResultSet(AttributeDefImpl[] attrDefs,
int attrIndex,
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,
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,
PreparedStatement ps,
int index,
Transaction trans)
Loads an object from a result set. |
void |
doPreparedStatementDefineColumnType(PreparedStatement ps,
int colnum,
int sqltype)
Performs the equivalent of defineColumnType() on a prepared statement. |
void |
doPreparedStatementDefines(PreparedStatement ps,
AttributeDefImpl[] attrs)
Defines the column types of the attributes based on the meta-data. |
void |
doRefreshSQL(EntityImpl entityContext,
int operation,
AttributeDefImpl[] columns,
AttributeDefImpl[] retrKeyCols)
Refreshes the entity after an update on the database. |
void |
doStatementSetBindingStyle(Statement ps,
int bindingStyle)
Sets the binding style for the statement. |
void |
doStatementSetBindingStyleDefault(Statement ps)
Sets the binding style to the default value of the database type. |
void |
doStatementSetRowPrefetch(Statement ps,
int prefetchSize)
Performs the equivalent of setRowPrefetch() on a statement. |
protected java.lang.Object |
formatAttributeValue(ViewCriteria vc,
AttributeDef curDef,
java.lang.String valString)
|
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.Object |
generateRowID(EntityImpl entityContext)
Get the ROWID attribute. |
static int |
getBindingStyleValue(java.lang.String bindingStyleStr)
|
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 |
getDbType()
Returns a string uniquely identifying this type of SQLBuilder. |
int |
getDefaultBindingStyle()
Unless overridden, the binding style is set to JDBC (Oracle versions change this). |
protected boolean |
getLockTrailerIsAtEnd()
For some databases like SQLServer that row lock clause is placed before the WHERE clause while for some other databases like Oracle it is at the end of SQL Statement. |
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.Object |
getROWID(EntityImpl entityContext)
Get the ROWID attribute. |
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 boolean |
getSupportsAliasInUpdateStatements()
Assume that aliases are permitted, unless a builder denies it |
ViewCriteriaAdapter |
getViewCriteriaAdapter()
Returns a ViewCriteriaAdapter for the SQLBuilder object. |
java.lang.String |
getViewCriteriaClause(ViewObject vo,
ViewCriteria vc)
|
protected java.lang.String |
getWarningText(java.lang.String message)
For use withinn DebugDiagnostic messages. |
void |
populateCompOpers()
|
void |
processException(java.lang.Class callingClass,
java.lang.String callingMethod,
java.lang.String errorCode,
java.lang.Exception sqlEx,
java.lang.Object[] params)
Handle SQL exceptions by wrapping into SQLStmtException or
JboException . |
java.lang.Object |
registerDatabaseChangeListener(QueryCollection listener,
Connection conn,
Statement stmt)
Register a Query Collection to listen to database data change events. |
void |
releaseSavepoint(Connection conn,
java.lang.String id)
Release SAVEPOINT if possible. |
void |
rollbackToSavepoint(Connection conn,
java.lang.String id)
Rollback to SAVEPOINT if possible. |
void |
setSavepoint(Connection conn,
java.lang.String id)
Issue a SAVEPOINT if possible. |
protected java.lang.String |
setupBindVarExtendedData(ViewCriteria criteria,
java.lang.String criteriaClause)
Subclasses should overwrite this method if it needs to set up extended data for bind variables for JDBC positional binding style, and to replace the name bind variables in the where clause if necessary. |
boolean |
shouldPutJoinConstraintInFromClause()
Checks if the FROM clause allows view criteria. |
protected boolean |
shouldSkipDML(EntityImpl entityContext,
int operation,
TransactionEvent e)
Checks if the entity needs to be posted to the database or not. |
boolean |
supportsRowNumQuery()
Checks if the database supports "rownum" identifier. |
void |
unregisterDatabaseChangeListener(java.lang.Object handle)
UnRegister a previous registration to listen to database data change events. |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public static final java.lang.Class CLASS_INSTANCE
Constructor Detail |
---|
public BaseSQLBuilderImpl()
Method Detail |
---|
public java.lang.StringBuffer buildDeleteStatement(EntityImpl entityContext)
SQLBuilder
Note: this method is subject to change.
buildDeleteStatement
in interface SQLBuilder
entityContext
- the entity object.
public java.lang.StringBuffer buildInsertStatement(EntityImpl entityContext, AttributeDefImpl[] cols, AttributeDefImpl[] retrCols, AttributeDefImpl[] retrKeyCols, boolean batchMode)
SQLBuilder
Note: this method is subject to change.
buildInsertStatement
in interface SQLBuilder
entityContext
- the entity object.cols
- the columns to be included in the INSERT statement.retrCols
- the Columns whose values need to be fetched after the INSERT succeeds.retrKeyCols
- the Columns that are used as Keys to fetch post-insert values.batchMode
- a flag to indicate if the INSERT statement needs to be optimized for batch mode.
public java.lang.StringBuffer buildUpdateStatement(EntityImpl entityContext, AttributeDefImpl[] cols, AttributeDefImpl[] retrCols, AttributeDefImpl[] retrKeyCols, boolean batchMode)
SQLBuilder
Note: this method is subject to change.
buildUpdateStatement
in interface SQLBuilder
entityContext
- the entity object.cols
- the columns to be included in the UPDATE statement.retrCols
- the Columns whose values need to be fetched after the UPDATE succeeds.retrKeyCols
- the Columns that are used as Keys to fetch post-update values.batchMode
- a flag to indicate if the UPDATE statement needs to be optimized for batch mode.
protected int bindWhereAttrValue(EntityImpl entityContext, DBTransactionImpl trans, PreparedStatement stmt, AttributeDefImpl attrDef, int bindIndex, boolean skipNull) throws SQLException
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.
SQLException
protected boolean shouldSkipDML(EntityImpl entityContext, int operation, TransactionEvent e)
entityContext
- the entity object.operation
- the type of operation. For example INSERT, UPDATE.e
- the transaction event triggered.
public void doEntityDML(EntityImpl entityContext, int operation, TransactionEvent e)
SQLBuilder
Note: this method is subject to change.
doEntityDML
in interface SQLBuilder
entityContext
- the Entity Object.operation
- one of DML_INSERT, DML_UPDATE, or DML_DELETE.e
- the transaction.public java.lang.String getDbType()
SQLBuilder
getDbType
in interface SQLBuilder
public void buildWhereClause(EntityImpl entityContext, java.lang.StringBuffer buffer, AttributeDefImpl[] keyCols, java.lang.Object rowId)
SQLBuilder
Note: this method is subject to change.
buildWhereClause
in interface SQLBuilder
entityContext
- the entity object.buffer
- the StringBuffer object to which the WHERE clause is appended.keyCols
- the key attributes.rowId
- a rowid object if present.public int bindUpdateStatement(EntityImpl entityContext, PreparedStatement stmt, AttributeDefImpl[] cols, AttributeDefImpl[] retrCols, AttributeDefImpl[] retrKeyCols, java.util.Hashtable retrList, boolean batchMode) throws SQLException
SQLBuilder
Note: this method is subject to change.
bindUpdateStatement
in interface SQLBuilder
entityContext
- the entity object.stmt
- the statement handle executing the UPDATE statement.cols
- the columns involved in the UPDATE statement.retrCols
- the columns whose values need to be fetched after a successful insert.retrKeyCols
- the columns that act as a key to fetch the newly inserted values.retrList
- a map containing the references to store the fetched values.batchMode
- flag to indicate binding for batchMode.
SQLException
public int bindWhereClause(EntityImpl entityContext, PreparedStatement stmt, AttributeDefImpl[] keyCols, java.lang.Object rowid, int bindIndex) throws SQLException
SQLBuilder
The presence or absence of the ROWID value determines whether the ROWID will be used for Row access.
Note: this method is subject to change.
bindWhereClause
in interface SQLBuilder
entityContext
- the Entity row.stmt
- the statement to bind the columns to.rowid
- the ROWID for the row if known.bindIndex
- the baseline idx for performing the bind operations.
SQLException
public int bindInsertStatement(EntityImpl entityContext, PreparedStatement stmt, AttributeDefImpl[] cols, AttributeDefImpl[] retrCols, AttributeDefImpl[] retrKeyCols, java.util.Hashtable retrList, boolean batchMode) throws SQLException
SQLBuilder
Note: this method is subject to change.
bindInsertStatement
in interface SQLBuilder
entityContext
- the entity object.stmt
- the statement handle executing the INSERT statement.cols
- the columns involved in the INSERT statement.retrCols
- the columns whose values need to be fetched after a successful insert.retrKeyCols
- the columns that act as a key to fetch the newly inserted values.retrList
- a map containing the references to store the fetched values.batchMode
- flag to indicate binding for batchMode.
SQLException
public int bindDeleteStatement(EntityImpl entityContext, PreparedStatement stmt) throws SQLException
SQLBuilder
Note: this method is subject to change.
bindDeleteStatement
in interface SQLBuilder
entityContext
- the entity object.stmt
- the statement handle executing the DELETE statement.
SQLException
public void bindParametersForStmt(int bindingStyle, java.lang.Object[] params, PreparedStatement stmt) throws SQLException
SQLBuilder
Note: this method is subject to change.
bindParametersForStmt
in interface SQLBuilder
bindingStyle
- specifies if Oracle, Oracle named parameter or JDBC binding style is used.params
- the list of parameters.stmt
- the statement to be executed.
SQLException
protected int bindParamValue(int bindingStyle, java.lang.Object value, DBTransactionImpl trans, PreparedStatement stmt, AttributeDefImpl attrDef, int bindIndex, boolean skipNull) throws SQLException
SQLException
public static void baseBuildSelectList(java.lang.StringBuffer buffer, AttributeDefImpl[] attrs, java.lang.String sourceName, boolean forViewObject)
buffer
- the storage for the WHERE clause.attrs
- the attributes to be considered for the select list.sourceName
- the name of the table - unused.public void buildSelectList(java.lang.StringBuffer buffer, AttributeDefImpl[] attrs, java.lang.String sourceAlias, boolean forViewObject)
SQLBuilder
Note: this method is subject to change.
buildSelectList
in interface SQLBuilder
buffer
- the StringBuffer object to which the SELECT list is appended.attrs
- the list of attribute definitions to be considered for the SELECT list.sourceAlias
- the database object name that contains the attributes.public void buildDefaultViewObjectFromClause(java.lang.StringBuffer fromClause, Vector eRefs, BaseViewCriteriaManagerImpl vcManager)
SQLBuilder
ViewDefImpl.setFromClauseFlags(ViewDefImpl.CLAUSE_GENERATE_RT)
buildDefaultViewObjectFromClause
in interface SQLBuilder
fromClause
- A StringBuffer
object that would be appended with the generated "from"
clause.eRefs
- The EntityReference
objects that should be considered for generation
of the "from" clause.vcManager
- In ANSI generation, view criteria associated with the EntityAssociationReference are
part of the FROM clause, and vcManager is used to build the where clause fragment. if
NULL, view criteria won't be builtpublic boolean shouldPutJoinConstraintInFromClause()
SQLBuilder
shouldPutJoinConstraintInFromClause
in interface SQLBuilder
public ViewCriteriaAdapter getViewCriteriaAdapter()
SQLBuilder
Note: this method is subject to change.
getViewCriteriaAdapter
in interface SQLBuilder
public java.lang.String getViewCriteriaClause(ViewObject vo, ViewCriteria vc)
getViewCriteriaClause
in interface ViewCriteriaAdapter
protected java.lang.Object formatAttributeValue(ViewCriteria vc, AttributeDef curDef, java.lang.String valString)
formatAttributeValue
in class CommonCriteriaAdapter
public void buildDefaultViewObjectWhereClause(java.lang.StringBuffer whereClause, Vector eRefs)
SQLBuilder
ViewDefImpl.setWhereClauseFlags(ViewDefImpl.CLAUSE_GENERATE_RT)
buildDefaultViewObjectWhereClause
in interface SQLBuilder
whereClause
- A StringBuffer
object that would be appended with the generated
"where" clause.eRefs
- The EntityReference
objects that should be considered for generation
of the "where" clause.public java.lang.Object convertValueToStorageType(java.lang.Object value)
SQLBuilder
Note: this method is subject to change.
convertValueToStorageType
in interface SQLBuilder
value
- the object that needs to be converted.
public void doStatementSetBindingStyle(Statement ps, int bindingStyle)
SQLBuilder
doStatementSetBindingStyle
in interface SQLBuilder
ps
- the Statement object.bindingStyle
- valid values are BINDING_STYLE_JDBC, BINDING_STYLE_ORACLE, BINDING_STYLE_ORACLE_NAME.public void doStatementSetRowPrefetch(Statement ps, int prefetchSize) throws SQLException
SQLBuilder
doStatementSetRowPrefetch
in interface SQLBuilder
ps
- the Statement object.prefetchSize
- the fetch size.
SQLException
public java.lang.String getClauseForDateLiteral(java.util.Date date)
SQLBuilder
getClauseForDateLiteral
in interface SQLBuilder
date
- The date object that will be formatted and passed as a String
public boolean supportsRowNumQuery()
SQLBuilder
Note: this method is subject to change.
supportsRowNumQuery
in interface SQLBuilder
public static int getBindingStyleValue(java.lang.String bindingStyleStr)
public java.lang.Object doLoadFromResultSet(java.lang.Object theTypeFactory, java.lang.Object theElemFactory, java.lang.Class theJavaType, byte attrLoad, ResultSet rs, int index, DBTransactionImpl trans)
SQLBuilder
Note: this method is subject to change.
doLoadFromResultSet
in interface SQLBuilder
theTypeFactory
- a custom factory to be used for constructing new instances.theElemFactory
- currently unused.theJavaType
- the Java datatype of the Object to be created.attrLoad
- specifies if the load type is
ATTR_LOAD_EACH
,
ATTR_LOAD_BULK
or
ATTR_LOAD_SKIP
rs
- the resultset.index
- the index of the object to be loaded.trans
- the reference to the transaction object used to fetch the resultset.
public void doEntitySelect(EntityImpl entityContext, boolean lock)
SQLBuilder
Note: this method is subject to change. Note: this method is subject to change.
doEntitySelect
in interface SQLBuilder
entityContext
- the Entity Object.lock
- if true, a "SELECT for UPDATE" statement is used.protected boolean capabilityCanReuseLockStatements()
protected void buildSelectString(java.lang.StringBuffer buffer, java.lang.String sourceName, AttributeDefImpl[] attrs, boolean withIntoClause)
buffer
- the area into which the SELECT statement will be placed.sourceName
- the database object from which the Columns are selected.attrs
- the attributes that are selected from the database object.withIntoClause
- a boolean that indicates if an INTO Clause needs to be generated.public void doEntitySelectForAltKey(EntityImpl entityContext, int keyIndex, boolean lock)
doEntitySelectForAltKey
in interface SQLBuilder
protected java.lang.String getSqlVariantLockTrailer()
protected boolean getLockTrailerIsAtEnd()
public java.lang.Object generateRowID(EntityImpl entityContext)
SQLBuilder
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.
Note: this method is subject to change.
generateRowID
in interface SQLBuilder
entityContext
- the entity object reference.
public java.lang.Object[] generateRefAndOID(EntityImpl entityContext)
SQLBuilder
Note: this method is subject to change.
generateRefAndOID
in interface SQLBuilder
entityContext
- the entity object reference.public boolean compareFetchedValue(EntityImpl entity, AttributeDefImpl ad, java.lang.Object cacheValue, java.lang.Object fetchedValue)
SQLBuilder
Note: this method is subject to change.
compareFetchedValue
in interface SQLBuilder
entity
- the entity object.ad
- the attribute definition of the value being compared.cacheValue
- the cached value.fetchedValue
- the new fetched value.
public java.lang.Object[] doLoadBulkFromResultSet(AttributeDefImpl[] attrDefs, int attrIndex, ResultSet rs, int index, DBTransactionImpl trans)
SQLBuilder
Note: this method is subject to change.
doLoadBulkFromResultSet
in interface SQLBuilder
attrDefs
- the list of attributes to be loaded.attrIndex
- a particular attribute from the list - Currently unused.rs
- the ResultSet containing the objects.index
- the index of the object in the result set to be loaded.trans
- the reference to the transaction object used to fetch the resultset.
public java.lang.Object registerDatabaseChangeListener(QueryCollection listener, Connection conn, Statement stmt)
SQLBuilder
registerDatabaseChangeListener
in interface SQLBuilder
listener
- The Query Collection that holds the qualifying rowsconn
- Connection objectstmt
- The SQL Statement that needs to be monitored for the
database to trigger notifications.
public void doPreparedStatementDefines(PreparedStatement ps, AttributeDefImpl[] attrs)
SQLBuilder
Note: this method is subject to change.
doPreparedStatementDefines
in interface SQLBuilder
ps
- the PreparedStatement object.attrs
- the attribute definitions.public void processException(java.lang.Class callingClass, java.lang.String callingMethod, java.lang.String errorCode, java.lang.Exception sqlEx, java.lang.Object[] params)
SQLBuilder
SQLStmtException
or
JboException
.
Note: this method is subject to change.
processException
in interface SQLBuilder
errorCode
- the SQL execution errorcode.sqlEx
- the Exception object.params
- the query parameters.public void unregisterDatabaseChangeListener(java.lang.Object handle)
SQLBuilder
unregisterDatabaseChangeListener
in interface SQLBuilder
public void populateCompOpers()
public java.lang.Object generatePKBasedRef(EntityImpl entityContext)
SQLBuilder
Note: this method is subject to change.
generatePKBasedRef
in interface SQLBuilder
entityContext
- the entity object reference.public int bindWhereClause(EntityImpl entityContext, PreparedStatement stmt, java.lang.Object rowid, int bindIndex) throws SQLException
SQLException
protected LongRunningStatementHandle createHandleForCancellableStatements(DBTransactionImpl trans, Statement stmt)
trans
- the transaction object.stmt
- the statement handle.
public void rollbackToSavepoint(Connection conn, java.lang.String id) throws SQLException
SQLBuilder
rollbackToSavepoint
in interface SQLBuilder
conn
- the Connection used to rollback the savepoint.id
- the id for a savepoint
SQLException
public void setSavepoint(Connection conn, java.lang.String id) throws SQLException
SQLBuilder
setSavepoint
in interface SQLBuilder
conn
- the Connection used to create a savepoint.id
- the id for a savepoint.
SQLException
public void releaseSavepoint(Connection conn, java.lang.String id) throws SQLException
SQLBuilder
releaseSavepoint
in interface SQLBuilder
conn
- the Connection used to release the savepoint.id
- the id for a savepoint
SQLException
public void doRefreshSQL(EntityImpl entityContext, int operation, AttributeDefImpl[] columns, AttributeDefImpl[] retrKeyCols)
SQLBuilder
Note: this method is subject to change.
doRefreshSQL
in interface SQLBuilder
entityContext
- the Entity row.operation
- SQL Operationcolumns
- Columns to be selected.retrKeyCols
- Key columns to appear be to used to refresh, which appear in WHERE clause.public void buildSelectString(DBTransactionImpl trans, java.lang.StringBuffer buffer, java.lang.String sourceName, java.lang.String sourceAlias, AttributeDefImpl[] attrs, boolean withIntoClause, int bindingStyle)
SQLBuilder
Note: this method is subject to change.
buildSelectString
in interface SQLBuilder
trans
- a reference to the transaction object.buffer
- the StringBuffer object to which the SELECT statement is appended.sourceName
- the database object from which the Columns are selected.sourceAlias
- the database object alias.attrs
- the attributes that are selected from the database object.withIntoClause
- a boolean that indicates if an INTO Clause needs to be generated.bindingStyle
- specifies if Oracle, Oracle named parameter or JDBC binding style
is used in generating the parameter markers for the INTO clause.public int bindUpdateStatement(EntityImpl entityContext, PreparedStatement stmt, AttributeDefImpl[] cols, AttributeDefImpl[] retrCols, AttributeDefImpl[] retrKeyCols, Map retrList, boolean batchMode) throws SQLException
SQLBuilder
Note: this method is subject to change.
bindUpdateStatement
in interface SQLBuilder
entityContext
- the entity object.stmt
- the statement handle executing the UPDATE statement.cols
- the columns involved in the UPDATE statement.retrCols
- the columns whose values need to be fetched after a
successful insert.retrKeyCols
- the columns that act as a key to fetch the newly
inserted values.retrList
- a map containing the references to store the fetched
values.batchMode
- flag to indicate binding for batchMode.
SQLException
protected java.lang.Object getROWID(EntityImpl entityContext)
entityContext
- the entity object.
public int bindInsertStatement(EntityImpl entityContext, PreparedStatement stmt, AttributeDefImpl[] cols, AttributeDefImpl[] retrCols, AttributeDefImpl[] retrKeyCols, Map retrList, boolean batchMode) throws SQLException
SQLBuilder
Note: this method is subject to change.
bindInsertStatement
in interface SQLBuilder
entityContext
- the entity object.stmt
- the statement handle executing the INSERT statement.cols
- the columns involved in the INSERT statement.retrCols
- the columns whose values need to be fetched after a
successful insert.retrKeyCols
- the columns that act as a key to fetch the newly
inserted values.retrList
- a map containing the references to store the fetched
values.batchMode
- flag to indicate binding for batchMode.
SQLException
public java.lang.Object doLoadFromStatement(java.lang.Object theTypeFactory, java.lang.Object theElemFactory, java.lang.Class theJavaType, PreparedStatement ps, int index, Transaction trans)
SQLBuilder
Note: this method is subject to change.
doLoadFromStatement
in interface SQLBuilder
theTypeFactory
- a custom factory to be used for constructing new instances.theElemFactory
- currently unused.theJavaType
- the Java datatype of the Object to be created.ps
- the statement reference used to retrieve the Object.index
- the index of the object in the output list.trans
- the reference to the transaction object used to fetch the resultset.
protected boolean getSupportsAliasInUpdateStatements()
public void buildOptUpdateWhereClause(EntityImpl entityContext, java.lang.StringBuffer buffer, AttributeDefImpl[] cols)
entityContext
- the entity definition.buffer
- the storage for the WHERE clause.cols
- the attributes to be considered for fetching.public void doStatementSetBindingStyleDefault(Statement ps)
SQLBuilder
Note: this method is subject to change.
doStatementSetBindingStyleDefault
in interface SQLBuilder
ps
- the Statement object.public int getDefaultBindingStyle()
public java.lang.String getQueryHitCountSQL(RowSet rs)
SQLBuilder
Note: this method is subject to change.
getQueryHitCountSQL
in interface SQLBuilder
rs
- the RowSet object.
public void doPreparedStatementDefineColumnType(PreparedStatement ps, int colnum, int sqltype) throws SQLException
SQLBuilder
Note: this method is subject to change.
doPreparedStatementDefineColumnType
in interface SQLBuilder
ps
- the PreparedStatement object.colnum
- the column number.sqltype
- the type of the column.
SQLException
protected java.lang.String getWarningText(java.lang.String message)
message
- the warning message.
protected java.lang.String setupBindVarExtendedData(ViewCriteria criteria, java.lang.String criteriaClause)
CommonCriteriaAdapter
setupBindVarExtendedData
in class CommonCriteriaAdapter
criteria
- The view criteria that we are building the where clause forcriteriaClause
- The where clause that has been generated
public int bindOptUpdateWhereClause(EntityImpl entityContext, PreparedStatement stmt, int bindIndex) throws SQLException
entityContext
- the entity definition.stmt
- the Statement object.bindIndex
- the current bind index.
SQLException
|
Oracle Fusion Middleware Java API Reference for Oracle ADF Mobile Client 11g Release 1 (11.1.1) E17503-02 |
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |