|
Oracle Fusion Middleware Java API Reference for Oracle ADF Model 11g Release 1 (11.1.1.7.0) E10653-08 |
||||||||
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.CriteriaAdapterImpl
oracle.jbo.server.BaseSQLBuilderImpl
oracle.jbo.server.OracleSQLBuilderImpl
public class OracleSQLBuilderImpl
Oracle specific implementation of the SQLBuilder interface.
Field Summary | |
---|---|
protected static java.lang.String |
ORACLE_ROWID_COLUMN
Oracle specific column name for ROWID. |
Fields inherited from class oracle.jbo.server.BaseSQLBuilderImpl |
---|
LOGGER_NAME |
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, MAX_COLUMN_IDENTIFIER_LEN, RANGE_PAGE_BIND_HIGH_ROWNUM, RANGE_PAGE_BIND_LOW_ROWNUM |
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,
java.util.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. |
void |
bindRangePagingParams(java.sql.PreparedStatement stmt,
ViewObjectImpl vo,
int nextParamIndex,
int rangeStart,
int rangeSize)
|
int |
bindUpdateStatement(EntityImpl entityContext,
java.sql.PreparedStatement stmt,
AttributeDefImpl[] cols,
AttributeDefImpl[] retrCols,
AttributeDefImpl[] retrKeyCols,
java.util.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. |
void |
buildDefaultViewObjectFromClause(java.lang.StringBuffer fromClause,
java.util.List 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)
|
java.util.HashMap |
buildDefaultViewObjectWhereClause(java.lang.StringBuffer whereClause,
java.util.List eRefs,
java.util.List forcedERefs,
EntityReference[][] newEntRefsArr,
boolean isInlineViewForFroms)
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.String |
buildEffDtDateDayAddStatement()
Returns a statement that returns a date that is 'x' number of days apart from the specified date. |
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. |
java.lang.String |
buildRangePagingQuery(ViewObjectImpl vo,
java.lang.String qry,
int noUserParams)
|
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 |
buildSelectString(DBTransactionImpl trans,
java.lang.StringBuffer buffer,
java.lang.String sourceName,
java.lang.String sourceAlias,
AttributeDefImpl[] attrs,
boolean withIntoClause,
int bindingStyle)
Build a list of columns that could be used in a SELECT statement. |
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 |
doEntitySelectForAltKey(EntityImpl entityContext,
int keyIndex,
boolean lock)
|
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. |
java.lang.String |
getClauseForDateLiteral(java.util.Date date)
Creates a database platform specific clause for converting a date string literal to date datatype. |
java.util.ArrayList |
getConstraintsList(java.sql.Connection conn,
java.lang.String catalog,
java.lang.String 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.util.ArrayList sequenceNames,
java.util.ArrayList colNames)
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.util.ArrayList |
getDBOperationList(java.sql.Connection connection,
java.lang.String userName,
java.lang.String packageFilter,
java.lang.String operationFilter)
Return a list of packages visible in this connection. |
java.util.ArrayList |
getDBPackageList(java.sql.Connection connection,
java.lang.String userName,
java.lang.String packageFilter)
Return a list of packages visible in this connection. |
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. |
java.lang.String |
getFormattedLHSCompareFragment(ViewObject vo,
ViewCriteria vc,
AttributeDef attrDef,
int sqltype,
java.lang.String lhs,
java.lang.Object rhs)
This method provides a formatted left-hand-comparator fragment of a comparision in a where clause for the given column. |
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. |
java.lang.Class<OracleConnection> |
getNativeConnectionType()
Returns the type used to represent a JDBC connection used in each specific implementation of this interface. |
java.util.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. |
protected static java.lang.String |
getTableListSqlStatement(java.lang.String defaultUserName,
java.lang.String userName,
java.lang.String nameFilter,
boolean bTable,
boolean bAlias,
boolean bView,
boolean bSnap,
boolean bCount,
boolean bIncludeNested)
A helper method for getTableList. |
java.util.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. |
java.util.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.util.ArrayList |
getTables(java.sql.Connection conn,
java.lang.String defaultUserName,
java.lang.String userName,
java.lang.String nameFilter,
boolean bTable,
boolean bAlias,
boolean bView,
boolean bSnap)
Return a list of tables visible in this connection. |
java.util.ArrayList |
getTables(java.sql.Connection conn,
java.lang.String defaultUserName,
java.lang.String userName,
java.lang.String nameFilter,
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. |
protected boolean |
isDateOrTimeTypeVariable(Variable var)
|
boolean |
isDisplayBindValueUI()
For Oracle database the test SQL wizards provide additional functionality to bind the parameters with test values. |
boolean |
isNCharType(java.sql.Statement stmt,
int index)
Tests if the select statement at a given column index corresponds to an international character column. |
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 . |
ADFDatabaseChangeListener |
registerDatabaseChangeListener(QueryCollection listener,
java.sql.Connection conn,
java.sql.Statement stmt)
Register a Query Collection to listen to database data change events. |
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. |
void |
setSessionTimeZone(java.sql.Connection conn,
java.lang.String regionName)
Sets the user session timezone on the Connection object. |
boolean |
shouldPutJoinConstraintInFromClause()
Checks if the FROM clause allows view criteria. |
boolean |
supportsReturningClause()
Oracle database supports RETURNING clause. |
boolean |
supportsRowNumQuery()
Oracle database supports rownum in a query. |
OracleConnection |
unwrapConnection(java.sql.Connection dataSourceConn)
Unwraps a native JDBC connection from a java.sql.Connection instance borrowed from a DataSource. |
Methods inherited from class oracle.jbo.server.CriteriaAdapterImpl |
---|
formatAttributeValue, getBindValsForSqlGen, getFormattedLHSCompareFragment, getFormattedRHSCompareFragment, getRowSetForSqlGen, getViewCriteriaClause, getWhereFragmentFromVO, isCriteriaItemOuterJoined, isLHSFragmentOptional, setupBindVarExtendedData |
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 |
---|
protected static final java.lang.String ORACLE_ROWID_COLUMN
Constructor Detail |
---|
protected OracleSQLBuilderImpl()
Method Detail |
---|
public static SQLBuilder getInterface()
public java.lang.String getVersion()
SQLBuilder
getVersion
in interface SQLBuilder
getVersion
in class BaseSQLBuilderImpl
public java.lang.String getDbType()
SQLBuilder
getDbType
in interface SQLBuilder
getDbType
in class BaseSQLBuilderImpl
public java.lang.String getTypeMapName()
getTypeMapName
in interface SQLBuilder
getTypeMapName
in class BaseSQLBuilderImpl
public java.util.ArrayList getNestedTables(java.sql.Connection conn) throws java.sql.SQLException
SQLBuilder
Note: this method is subject to change.
getNestedTables
in interface SQLBuilder
getNestedTables
in class BaseSQLBuilderImpl
conn
- the connection.
java.sql.SQLException
public java.lang.String getPersistManagerClassName()
SQLBuilder
getPersistManagerClassName
in interface SQLBuilder
getPersistManagerClassName
in class BaseSQLBuilderImpl
public int getDefaultBindingStyle()
getDefaultBindingStyle
in interface SQLBuilder
getDefaultBindingStyle
in class BaseSQLBuilderImpl
public void executeBatch(java.sql.PreparedStatement stmt) throws java.sql.SQLException
SQLBuilder
Note: this method is subject to change.
executeBatch
in interface SQLBuilder
executeBatch
in class BaseSQLBuilderImpl
stmt
- a PreparedStatement object.
java.sql.SQLException
public void doEntityDML(EntityImpl entityContext, int operation, TransactionEvent e)
SQLBuilder
Note: this method is subject to change.
doEntityDML
in interface SQLBuilder
doEntityDML
in class BaseSQLBuilderImpl
entityContext
- the Entity Object.operation
- one of DML_INSERT, DML_UPDATE, or DML_DELETE.e
- the transaction.public void doEntitySelectForAltKey(EntityImpl entityContext, int keyIndex, boolean lock)
doEntitySelectForAltKey
in interface SQLBuilder
doEntitySelectForAltKey
in class BaseSQLBuilderImpl
public void doStatementSetRowPrefetch(java.sql.Statement ps, int prefetchSize) throws java.sql.SQLException
SQLBuilder
doStatementSetRowPrefetch
in interface SQLBuilder
doStatementSetRowPrefetch
in class BaseSQLBuilderImpl
ps
- the Statement object.prefetchSize
- the fetch size.
java.sql.SQLException
public void doStatementSetBindingStyle(java.sql.Statement ps, int bindingStyle)
SQLBuilder
doStatementSetBindingStyle
in interface SQLBuilder
doStatementSetBindingStyle
in class BaseSQLBuilderImpl
ps
- the Statement object.bindingStyle
- valid values are BINDING_STYLE_JDBC, BINDING_STYLE_ORACLE,
BINDING_STYLE_ORACLE_NAME.public void doStatementSetBindingStyleDefault(java.sql.Statement ps)
SQLBuilder
Note: this method is subject to change.
doStatementSetBindingStyleDefault
in interface SQLBuilder
doStatementSetBindingStyleDefault
in class BaseSQLBuilderImpl
ps
- the Statement object.public void doPreparedStatementDefineColumnType(java.sql.PreparedStatement ps, int colnum, int sqltype) throws java.sql.SQLException
SQLBuilder
Note: this method is subject to change.
doPreparedStatementDefineColumnType
in interface SQLBuilder
doPreparedStatementDefineColumnType
in class BaseSQLBuilderImpl
ps
- the PreparedStatement object.colnum
- the column number.sqltype
- the type of the column.
java.sql.SQLException
public void doPreparedStatementDefines(java.sql.PreparedStatement stmt, AttributeDefImpl[] columns)
SQLBuilder
Note: this method is subject to change.
doPreparedStatementDefines
in interface SQLBuilder
doPreparedStatementDefines
in class BaseSQLBuilderImpl
stmt
- the PreparedStatement object.columns
- the attribute definitions.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)
SQLBuilder
Note: this method is subject to change.
doLoadFromResultSet
in interface SQLBuilder
doLoadFromResultSet
in class BaseSQLBuilderImpl
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 java.lang.Object[] doLoadBulkFromResultSet(AttributeDefImpl[] attrDefs, int attrIndex, java.sql.ResultSet rs, int index, DBTransactionImpl trans)
SQLBuilder
Note: this method is subject to change.
doLoadBulkFromResultSet
in interface SQLBuilder
doLoadBulkFromResultSet
in class BaseSQLBuilderImpl
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 doLoadFromStatement(java.lang.Object theTypeFactory, java.lang.Object theElemFactory, java.lang.Class theJavaType, java.sql.PreparedStatement ps, int index, Transaction trans)
SQLBuilder
Note: this method is subject to change.
doLoadFromStatement
in interface SQLBuilder
doLoadFromStatement
in class BaseSQLBuilderImpl
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.
public void setSavepoint(java.sql.Connection conn, java.lang.String id) throws java.sql.SQLException
SQLBuilder
setSavepoint
in interface SQLBuilder
setSavepoint
in class BaseSQLBuilderImpl
conn
- the Connection used to create a savepoint.id
- the id for a savepoint.
java.sql.SQLException
public void rollbackToSavepoint(java.sql.Connection conn, java.lang.String id) throws java.sql.SQLException
SQLBuilder
rollbackToSavepoint
in interface SQLBuilder
rollbackToSavepoint
in class BaseSQLBuilderImpl
conn
- the Connection used to rollback the savepoint.id
- the id for a savepoint
java.sql.SQLException
public void releaseSavepoint(java.sql.Connection conn, java.lang.String id) throws java.sql.SQLException
SQLBuilder
releaseSavepoint
in interface SQLBuilder
releaseSavepoint
in class BaseSQLBuilderImpl
conn
- the Connection used to release the savepoint.id
- the id for a savepoint
java.sql.SQLException
public boolean supportsReturningClause()
supportsReturningClause
in interface SQLBuilder
supportsReturningClause
in class BaseSQLBuilderImpl
public boolean supportsRowNumQuery()
supportsRowNumQuery
in interface SQLBuilder
supportsRowNumQuery
in class BaseSQLBuilderImpl
public java.lang.String buildRangePagingQuery(ViewObjectImpl vo, java.lang.String qry, int noUserParams)
buildRangePagingQuery
in interface SQLBuilder
buildRangePagingQuery
in class BaseSQLBuilderImpl
public void bindRangePagingParams(java.sql.PreparedStatement stmt, ViewObjectImpl vo, int nextParamIndex, int rangeStart, int rangeSize)
bindRangePagingParams
in interface SQLBuilder
bindRangePagingParams
in class BaseSQLBuilderImpl
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
buildUpdateStatement
in class BaseSQLBuilderImpl
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 void buildReturningClause(java.lang.StringBuffer sqlBuffer, DBTransactionImpl trans, AttributeDefImpl[] retrCols, AttributeDefImpl[] retrKeyCols, boolean batchMode, boolean oracleBinding)
sqlBuffer
- the StringBuffer object to which the RETURNING clause is appended.trans
- the transaction objectretrCols
- 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.public int bindInsertStatement(EntityImpl entityContext, java.sql.PreparedStatement stmt, AttributeDefImpl[] cols, AttributeDefImpl[] retrCols, AttributeDefImpl[] retrKeyCols, java.util.HashMap retrList, boolean batchMode) throws java.sql.SQLException
SQLBuilder
Note: this method is subject to change.
bindInsertStatement
in interface SQLBuilder
bindInsertStatement
in class BaseSQLBuilderImpl
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.
java.sql.SQLException
public int bindUpdateStatement(EntityImpl entityContext, java.sql.PreparedStatement stmt, AttributeDefImpl[] cols, AttributeDefImpl[] retrCols, AttributeDefImpl[] retrKeyCols, java.util.HashMap retrList, boolean batchMode) throws java.sql.SQLException
SQLBuilder
Note: this method is subject to change.
bindUpdateStatement
in interface SQLBuilder
bindUpdateStatement
in class BaseSQLBuilderImpl
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.
java.sql.SQLException
protected int bindWhereAttrValue(EntityImpl entityContext, DBTransactionImpl trans, java.sql.PreparedStatement stmt, AttributeDefImpl attrDef, int bindIndex, boolean skipNull) throws java.sql.SQLException
BaseSQLBuilderImpl
bindWhereAttrValue
in class BaseSQLBuilderImpl
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.
java.sql.SQLException
protected java.lang.Object getROWID(EntityImpl entityContext)
BaseSQLBuilderImpl
getROWID
in class BaseSQLBuilderImpl
entityContext
- the entity object.
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
buildWhereClause
in class BaseSQLBuilderImpl
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 void buildOptUpdateWhereClause(EntityImpl entityContext, java.lang.StringBuffer buffer, AttributeDefImpl[] cols)
BaseSQLBuilderImpl
buildOptUpdateWhereClause
in class BaseSQLBuilderImpl
entityContext
- the entity definition.buffer
- the storage for the WHERE clause.cols
- the attributes to be considered for fetching.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
buildInsertStatement
in class BaseSQLBuilderImpl
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 buildDeleteStatement(EntityImpl entityContext)
SQLBuilder
Note: this method is subject to change.
buildDeleteStatement
in interface SQLBuilder
buildDeleteStatement
in class BaseSQLBuilderImpl
entityContext
- the entity object.
public void buildSelectString(DBTransactionImpl trans, java.lang.StringBuffer buffer, java.lang.String sourceName, java.lang.String sourceAlias, AttributeDefImpl[] attrs, boolean withIntoClause, int bindingStyle)
Note: this method is subject to change.
buildSelectString
in interface SQLBuilder
buildSelectString
in class BaseSQLBuilderImpl
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.trans
- a reference to the transaction object.sourceAlias
- the database object alias.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 java.lang.Object generatePKBasedRef(EntityImpl entityContext)
SQLBuilder
Note: this method is subject to change.
generatePKBasedRef
in interface SQLBuilder
generatePKBasedRef
in class BaseSQLBuilderImpl
entityContext
- the entity object reference.public java.lang.Object[] generateRefAndOID(EntityImpl entityContext)
SQLBuilder
Note: this method is subject to change.
generateRefAndOID
in interface SQLBuilder
generateRefAndOID
in class BaseSQLBuilderImpl
entityContext
- the entity object reference.public boolean isStreamType(int sqlTypeId)
SQLBuilder
Note: this method is subject to change.
isStreamType
in interface SQLBuilder
isStreamType
in class BaseSQLBuilderImpl
sqlTypeId
- the type to check for streaming support.public java.util.Vector getSchemaList(java.sql.Connection connection) throws java.lang.Exception
SQLBuilder
Note: this method is subject to change.
getSchemaList
in interface SQLBuilder
getSchemaList
in class BaseSQLBuilderImpl
java.lang.Exception
public java.util.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
SQLBuilder
getTables(Connection, String, String, String, boolean, boolean, boolean, boolean)
with
no filter on the table name.
Note: this method is subject to change.
getTables
in interface SQLBuilder
getTables
in class BaseSQLBuilderImpl
conn
- the connection object.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 Materialized View objects in the list.
java.lang.Exception
public java.util.ArrayList getTables(java.sql.Connection conn, java.lang.String defaultUserName, java.lang.String userName, java.lang.String nameFilter, boolean bTable, boolean bAlias, boolean bView, boolean bSnap) throws java.lang.Exception
SQLBuilder
Note: this method is subject to change.
getTables
in interface SQLBuilder
getTables
in class BaseSQLBuilderImpl
conn
- the connection object.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.nameFilter
- the filter for the name of the table 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 Materialized View objects in the list.
java.lang.Exception
public java.util.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
SQLBuilder
getTables(Connection, String, String, String, boolean, boolean, boolean, boolean)
with
no filter on the table name and an additional parameter to fetch nested tables. Nested
tables are fetched only for Oracle database and OLite.
Note: this method is subject to change.
getTables
in interface SQLBuilder
getTables
in class BaseSQLBuilderImpl
conn
- the connection object.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 Materialized View objects in the list.bIncludeNested
- flag to include Nested table objects in the list.
java.lang.Exception
public java.util.ArrayList getTables(java.sql.Connection conn, java.lang.String defaultUserName, java.lang.String userName, java.lang.String nameFilter, boolean bTable, boolean bAlias, boolean bView, boolean bSnap, boolean bIncludeNested) throws java.lang.Exception
SQLBuilder
getTables(Connection, String, 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.
getTables
in interface SQLBuilder
getTables
in class BaseSQLBuilderImpl
conn
- the connection object.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.nameFilter
- the filter for the name of the table 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 Materialized View objects in the list.bIncludeNested
- flag to include Nested table objects in the list.
java.lang.Exception
public java.util.ArrayList getDBPackageList(java.sql.Connection connection, java.lang.String userName, java.lang.String packageFilter) throws java.lang.Exception
SQLBuilder
getDBPackageList(Connection conn, String userName)
.
Note: this method is subject to change.
getDBPackageList
in interface SQLBuilder
getDBPackageList
in class BaseSQLBuilderImpl
connection
- the connection object.userName
- the user name for which database packages need to be listed.packageFilter
- the filter the database packages need to be listed.
java.lang.Exception
public java.util.ArrayList getDBOperationList(java.sql.Connection connection, java.lang.String userName, java.lang.String packageFilter, java.lang.String operationFilter) throws java.lang.Exception
SQLBuilder
Note: this method is subject to change.
getDBOperationList
in interface SQLBuilder
getDBOperationList
in class BaseSQLBuilderImpl
connection
- the connection object.userName
- the user name for which the database functions and procedures need to be listed.packageFilter
- the filter the database packages in which the functions and procedures need to be listed.operationFilter
- the filter the database functions and procedures need to be listed.
java.lang.Exception
protected boolean needsQuotedTableName(java.lang.String tableName)
BaseSQLBuilderImpl
needsQuotedTableName
in class BaseSQLBuilderImpl
tableName
- the table name.
protected static java.lang.String getTableListSqlStatement(java.lang.String defaultUserName, java.lang.String userName, boolean bTable, boolean bAlias, boolean bView, boolean bSnap, boolean bCount)
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.
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)
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.
protected static java.lang.String getTableListSqlStatement(java.lang.String defaultUserName, java.lang.String userName, java.lang.String nameFilter, boolean bTable, boolean bAlias, boolean bView, boolean bSnap, boolean bCount, boolean bIncludeNested)
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.nameFilter
- the filter of the 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.
protected static java.lang.String addSqlTypeText(java.lang.String sqlText, java.lang.String inputType)
sqlText
- a String containing a list of object types included so far.inputType
- a new object type to be added to the list.
public java.util.ArrayList getConstraintsList(java.sql.Connection conn, java.lang.String catalog, java.lang.String schema, java.lang.String table) throws java.sql.SQLException
SQLBuilder
1 String constraint_name
2 String constraint_type
3 String table_name
4 String search_condition
5 Integer delete_rule (cascade)
6 Integer status (enabled)
7 Integerdeferrable
8 Integer deferred
9 Integer validated
10 String column_name
11 Integer position
12 String fkname
13 String fkother
Note: this method is subject to change.
getConstraintsList
in interface SQLBuilder
getConstraintsList
in class BaseSQLBuilderImpl
conn
- the connection object.catalog
- the database catalog.schema
- the database schema.table
- the name of the table.
java.sql.SQLException
public java.lang.String getBaseTable(java.sql.Connection conn, java.lang.String schema, java.lang.String name) throws java.sql.SQLException
SQLBuilder
Note: this method is subject to change.
getBaseTable
in interface SQLBuilder
getBaseTable
in class BaseSQLBuilderImpl
conn
- the connection object.schema
- the database schema.name
- the name of the potential synonym.
java.sql.SQLException
protected java.lang.String getJDBCDriverClassName(java.lang.String url)
BaseSQLBuilderImpl
getJDBCDriverClassName
in class BaseSQLBuilderImpl
url
- JDBC Connection url.
public java.lang.String getFormattedRHSCompareFragment(ViewObject vo, ViewCriteria vc, AttributeDef attrDef, int sqlType, java.lang.String rhs)
BaseSQLBuilderImpl
getFormattedRHSCompareFragment
in interface SQLBuilder
getFormattedRHSCompareFragment
in class BaseSQLBuilderImpl
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.
protected boolean isDateOrTimeTypeVariable(Variable var)
public java.lang.String getFormattedLHSCompareFragment(ViewObject vo, ViewCriteria vc, AttributeDef attrDef, int sqltype, java.lang.String lhs, java.lang.Object rhs)
SQLBuilder
getFormattedLHSCompareFragment
in interface SQLBuilder
getFormattedLHSCompareFragment
in class BaseSQLBuilderImpl
vo
- the view object instance, could be null if unavailable in the contextvc
- the view criteria instance, could be null if unavailable in the contextattrDef
- the definition of the attribute.sqltype
- the type of the attribute value.rhs
- the value of the attribute.
protected java.lang.String getSqlVariantLockTrailer(EntityImpl entityContext)
entityContext
- - currently unused.
protected java.lang.String getSqlVariantLockTrailer()
BaseSQLBuilderImpl
getSqlVariantLockTrailer
in class BaseSQLBuilderImpl
public java.lang.String getDbTimeQuery()
BaseSQLBuilderImpl
getDbTimeQuery
in class BaseSQLBuilderImpl
public java.lang.String getDropTableSQL(java.lang.String dbObjectName)
SQLBuilder
Note: this method is subject to change.
getDropTableSQL
in interface SQLBuilder
getDropTableSQL
in class BaseSQLBuilderImpl
dbObjectName
- name of the Table.
public boolean isDisplayBindValueUI()
SQLBuilder
isDisplayBindValueUI
in interface SQLBuilder
isDisplayBindValueUI
in class BaseSQLBuilderImpl
public java.lang.String getCreateSequenceInsertTriggerSQL(java.lang.String triggerName, java.lang.String tableName, java.util.ArrayList sequenceNames, java.util.ArrayList colNames)
SQLBuilder
Supported for Oracle database only.
Note: this method is subject to change.
getCreateSequenceInsertTriggerSQL
in interface SQLBuilder
getCreateSequenceInsertTriggerSQL
in class BaseSQLBuilderImpl
triggerName
- the name of the trigger.tableName
- the name of the table for which the trigger is created.sequenceNames
- the array of names of the sequence.colNames
- the arrya of names of the column to which the value of the sequence
is copied to.
public java.lang.String getCreateSequenceSQL(java.lang.String sequenceName, int startVal)
SQLBuilder
Note: this method is subject to change.
getCreateSequenceSQL
in interface SQLBuilder
getCreateSequenceSQL
in class BaseSQLBuilderImpl
sequenceName
- name of the Sequence.startVal
- the initial value of the Sequence.
public java.lang.String getDropSequenceSQL(java.lang.String sequenceName)
SQLBuilder
Note: this method is subject to change.
getDropSequenceSQL
in interface SQLBuilder
getDropSequenceSQL
in class BaseSQLBuilderImpl
sequenceName
- name of the Sequence.
public boolean isConnectionAlive(java.sql.Connection conn)
SQLBuilder
isConnectionAlive
in interface SQLBuilder
isConnectionAlive
in class BaseSQLBuilderImpl
conn
- the connection object.
public java.lang.Object convertValueToStorageType(java.lang.Object value)
SQLBuilder
Note: this method is subject to change.
convertValueToStorageType
in interface SQLBuilder
convertValueToStorageType
in class BaseSQLBuilderImpl
value
- the object that needs to be converted.
public void jdbcClientSideSecurity(java.util.Properties info, java.util.Hashtable env)
SQLBuilder
Note: this method is subject to change.
jdbcClientSideSecurity
in interface SQLBuilder
jdbcClientSideSecurity
in class BaseSQLBuilderImpl
info
- the properties object to which the values are copied to.env
- the environment object to lookup the security attributes.public boolean compareFetchedValue(EntityImpl entity, AttributeDefImpl ad, java.lang.Object cacheValue, java.lang.Object fetchedValue)
compareFetchedValue
in interface SQLBuilder
compareFetchedValue
in class BaseSQLBuilderImpl
entity
- the entity object.ad
- the attribute definition of the value being compared.cacheValue
- the cached value.fetchedValue
- the new fetched value.
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
BaseSQLBuilderImpl
bindParamValue
in class BaseSQLBuilderImpl
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.
java.sql.SQLException
public void processException(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
processException
in class BaseSQLBuilderImpl
errorCode
- the SQL execution errorcode.sqlEx
- the Exception object.params
- the query parameters.public boolean invalidDatumFactoryUsage(java.lang.String colType, int id, java.lang.Class clz)
invalidDatumFactoryUsage
in interface SQLBuilder
invalidDatumFactoryUsage
in class BaseSQLBuilderImpl
public void buildDefaultViewObjectFromClause(java.lang.StringBuffer fromClause, java.util.List eRefs, BaseViewCriteriaManagerImpl vcManager)
SQLBuilder
ViewDefImpl.setFromClauseFlags(ViewDefImpl.CLAUSE_GENERATE_RT)
buildDefaultViewObjectFromClause
in interface SQLBuilder
buildDefaultViewObjectFromClause
in class BaseSQLBuilderImpl
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
shouldPutJoinConstraintInFromClause
in class BaseSQLBuilderImpl
public java.util.HashMap buildDefaultViewObjectWhereClause(java.lang.StringBuffer whereClause, java.util.List eRefs, java.util.List forcedERefs, EntityReference[][] newEntRefsArr, boolean isInlineViewForFroms)
SQLBuilder
ViewDefImpl.setWhereClauseFlags(ViewDefImpl.CLAUSE_GENERATE_RT)
buildDefaultViewObjectWhereClause
in interface SQLBuilder
buildDefaultViewObjectWhereClause
in class BaseSQLBuilderImpl
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.String buildEffDtDateDayAddStatement()
SQLBuilder
buildEffDtDateDayAddStatement
in interface SQLBuilder
buildEffDtDateDayAddStatement
in class BaseSQLBuilderImpl
String
that contains the necessary SQL.public java.lang.String getClauseForDateLiteral(java.util.Date date)
SQLBuilder
date
- The date object that will be formatted and passed as a String
public void setSessionTimeZone(java.sql.Connection conn, java.lang.String regionName)
SQLBuilder
setSessionTimeZone
in interface SQLBuilder
setSessionTimeZone
in class BaseSQLBuilderImpl
conn
- Connection objectregionName
- timezone region, for example: America/New_Yorkpublic ADFDatabaseChangeListener registerDatabaseChangeListener(QueryCollection listener, java.sql.Connection conn, java.sql.Statement stmt)
SQLBuilder
registerDatabaseChangeListener
in interface SQLBuilder
registerDatabaseChangeListener
in class BaseSQLBuilderImpl
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 boolean isNCharType(java.sql.Statement stmt, int index)
SQLBuilder
isNCharType
in interface SQLBuilder
isNCharType
in class BaseSQLBuilderImpl
stmt
- A select statement that has been executedindex
- The position of the column to be tested for international character typepublic OracleConnection unwrapConnection(java.sql.Connection dataSourceConn)
SQLBuilder
unwrapConnection
in interface SQLBuilder
unwrapConnection
in class BaseSQLBuilderImpl
dataSourceConn
- a Connection borrowed from a DataSource.
public java.lang.Class<OracleConnection> getNativeConnectionType()
SQLBuilder
getNativeConnectionType
in interface SQLBuilder
getNativeConnectionType
in class BaseSQLBuilderImpl
|
Oracle Fusion Middleware Java API Reference for Oracle ADF Model 11g Release 1 (11.1.1.7.0) E10653-08 |
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |