Oracle ADF Model and Business Components API Reference 10.1.2 B14022-01

oracle.jbo.server
Class OLiteSQLBuilderImpl

java.lang.Object
  extended byoracle.jbo.server.BaseSQLBuilderImpl
      extended byoracle.jbo.server.OLiteSQLBuilderImpl
All Implemented Interfaces:
SQLBuilder, ViewCriteriaAdapter
Direct Known Subclasses:
WLSQLBuilderImpl

public class OLiteSQLBuilderImpl
extends BaseSQLBuilderImpl

OracleLite-specific implementation of the SQLBuilder interface.

Since:
JDeveloper 3.0

Field Summary
static int ERROR_OLITE_RESOURCE_BUSY_AND_NOWAIT_SPECIFIED
           
protected static java.lang.String ORACLE_ROWID_COLUMN
           
 
Fields inherited from interface oracle.jbo.server.SQLBuilder
BINDING_STYLE_JDBC, BINDING_STYLE_ORACLE, BINDING_STYLE_UNKNOWN, DML_DELETE, DML_INSERT, DML_UPDATE
 
Constructor Summary
protected OLiteSQLBuilderImpl()
          This is a singleton class
 
Method Summary
protected static java.lang.String addSqlTypeText(java.lang.String sqlText, java.lang.String inputType)
          helper for getTableList
protected  boolean capabilityCanReuseLockStatements()
           
 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 getCreateSequenceInsertTriggerSQL(java.lang.String triggerName, java.lang.String tableName, java.lang.String sequenceName, java.lang.String colName)
           
 java.lang.String getCreateSequenceSQL(java.lang.String sequenceName, int startVal)
           
 java.lang.String getDbTimeQuery()
           
 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)
 java.lang.String getDropSequenceSQL(java.lang.String sequenceName)
           
 java.lang.String getDropTableSQL(java.lang.String dbObjectName)
           
static SQLBuilder getInterface()
          Gets the singleton instance of this class.
protected  java.lang.String getJDBCDriverClassName()
          Concrete implementations of SQLBuilder must elect a default driver name
 java.lang.String getPersistManagerClassName()
          Returns the name of default PersistManager class name.
protected  java.lang.String getSqlVariantLockTrailer()
          This defines the string that will be post-fixed to SQL ststements to have the rows locked - if the DB is incapable of this then is should return null.
 java.util.Vector getTableList(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
protected static java.lang.String getTableListSqlStatement(java.lang.String _defaultUserName, java.lang.String userName, boolean bTable, boolean bAlias, boolean bView, boolean _bSnap, boolean bCount)
          helper for getTableList
 java.lang.String getTypeMapName()
          Returns a String identifying the preferred type map to use.
 java.lang.String getVersion()
          Gets a string describing the version of this implentation of this interface.
 boolean isDisplayBindValueUI()
           
 
Methods inherited from class oracle.jbo.server.BaseSQLBuilderImpl
bindDeleteStatement, bindInsertStatement, bindOptUpdateWhereClause, bindUpdateStatement, bindWhereAttrValue, bindWhereClause, bindWhereClause, buildDeleteStatement, buildInsertStatement, buildOptUpdateWhereClause, buildSelectString, buildSelectString, buildUpdateStatement, buildWhereClause, checkTableNameForQuotes, compareFetchedValue, convertFlags, convertValueToStorageType, convertValueToWhereFragment, convertValueToWhereFragment, doEntityDML, doEntitySelect, doLoadBulkFromResultSet, doLoadFromResultSet, doLoadFromStatement, doPreparedStatementDefineColumnType, doPreparedStatementDefines, doRefreshSQL, doRegisterDefaultDriver, doStatementSetBindingStyle, doStatementSetBindingStyleDefault, doStatementSetRowPrefetch, dumpConstraint, executeBatch, generatePKBasedRef, generateRefAndOID, generateRowID, getColumnNameWithFormatForQuery, getConstraints, getConstraintsList, getCurrentDbTime, getFormattedLHSCompareFragment, getFormattedLHSCompareFragment, getFormattedRHSCompareFragment, getFormattedRHSCompareFragment, getLockTrailerIsAtEnd, getQueryHitCountSQL, getQuotationMarkLeft, getQuotationMarkRight, getROWID, getSchemaList, getSchemas, getSupportsAliasInUpdateStatements, getTables, getViewCriteriaAdapter, getViewCriteriaClause, getWarningText, isCharType, isConnectionAlive, isDataSourceJTABased, isNumericType, isStreamType, jdbcClientSideSecurity, lookupDataSource, needsQuotedTableName, populateJboTypeMapEntries, releaseSavepoint, rollbackToSavepoint, setSavepoint, shouldSkipDML, supportsReturningClause, supportsRowNumQuery
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

ERROR_OLITE_RESOURCE_BUSY_AND_NOWAIT_SPECIFIED

public static final int ERROR_OLITE_RESOURCE_BUSY_AND_NOWAIT_SPECIFIED
See Also:
Constant Field Values

ORACLE_ROWID_COLUMN

protected static final java.lang.String ORACLE_ROWID_COLUMN
See Also:
Constant Field Values
Constructor Detail

OLiteSQLBuilderImpl

protected OLiteSQLBuilderImpl()
This is a singleton class

Method Detail

getInterface

public static SQLBuilder getInterface()
Gets the singleton instance of this class.


getJDBCDriverClassName

protected java.lang.String getJDBCDriverClassName()
Description copied from class: BaseSQLBuilderImpl
Concrete implementations of SQLBuilder must elect a default driver name

Specified by:
getJDBCDriverClassName in class BaseSQLBuilderImpl

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()
Description copied from interface: SQLBuilder
Returns a String identifying the preferred type map to use.

Specified by:
getTypeMapName in interface SQLBuilder
Specified by:
getTypeMapName in class BaseSQLBuilderImpl

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()
Description copied from class: BaseSQLBuilderImpl
unless overridden, the binding style is set to JDBC (Oracle versions change this)

Specified by:
getDefaultBindingStyle in interface SQLBuilder
Overrides:
getDefaultBindingStyle in class BaseSQLBuilderImpl

getTableList

public java.util.Vector getTableList(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

Specified by:
getTableList in interface SQLBuilder
Overrides:
getTableList in class BaseSQLBuilderImpl
Throws:
java.lang.Exception

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)
helper for getTableList


addSqlTypeText

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


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

Specified by:
getBaseTable in interface SQLBuilder
Overrides:
getBaseTable in class BaseSQLBuilderImpl
Throws:
java.sql.SQLException

capabilityCanReuseLockStatements

protected boolean capabilityCanReuseLockStatements()
Overrides:
capabilityCanReuseLockStatements in class BaseSQLBuilderImpl

getSqlVariantLockTrailer

protected java.lang.String getSqlVariantLockTrailer()
Description copied from class: BaseSQLBuilderImpl
This defines the string that will be post-fixed to SQL ststements to have the rows locked - if the DB is incapable of this then is should return null. Examples are: SQL Server - "WITH (HOLDLOCK)" Oracle - "FOR UPDATE NOWAIT"

Overrides:
getSqlVariantLockTrailer in class BaseSQLBuilderImpl

getDbTimeQuery

public java.lang.String getDbTimeQuery()
Specified by:
getDbTimeQuery in class BaseSQLBuilderImpl

getDropTableSQL

public java.lang.String getDropTableSQL(java.lang.String dbObjectName)
Specified by:
getDropTableSQL in interface SQLBuilder
Specified by:
getDropTableSQL in class BaseSQLBuilderImpl

isDisplayBindValueUI

public boolean isDisplayBindValueUI()
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)
Specified by:
getCreateSequenceInsertTriggerSQL in interface SQLBuilder
Specified by:
getCreateSequenceInsertTriggerSQL in class BaseSQLBuilderImpl

getCreateSequenceSQL

public java.lang.String getCreateSequenceSQL(java.lang.String sequenceName,
                                             int startVal)
Specified by:
getCreateSequenceSQL in interface SQLBuilder
Specified by:
getCreateSequenceSQL in class BaseSQLBuilderImpl

getDropSequenceSQL

public java.lang.String getDropSequenceSQL(java.lang.String sequenceName)
Specified by:
getDropSequenceSQL in interface SQLBuilder
Specified by:
getDropSequenceSQL in class BaseSQLBuilderImpl

Oracle ADF Model and Business Components API Reference 10.1.2 B14022-01

 

Copyright © 1997, 2004, Oracle. All rights reserved.