Oracle Fusion Middleware extensions for Logging and Diagnostic
11g Release 1 (11.1.1.6)

E22565-06

oracle.apps.fnd.appltest.diagfwk.engine.provider.connection
Class StandAloneConnectionProvider

java.lang.Object
  extended by oracle.apps.fnd.appltest.diagfwk.common.DiagBaseFactory
      extended by oracle.apps.fnd.appltest.diagfwk.engine.provider.connection.ConnectionProvider
          extended by oracle.apps.fnd.appltest.diagfwk.engine.provider.connection.StandAloneConnectionProvider
All Implemented Interfaces:
DiagConstants

public class StandAloneConnectionProvider
extends ConnectionProvider

Provides a standalone implementation of the ConnectionProvider class to be used during unit testing.

This implementation creates a connection based on the database properties and credentials specified in the file indicated by the APPCONNFILE system property. There is no security context in connection.

Additionally, this implementation uses a ThreadLocal in order to create a new Connection for each executing Thread. Hence, this implementation is not really meant for production usage and should only be used during unit testing.

Connections created by this provider will always have auto commit set to false.

Since:
release specific (what release of product did this appear in)
Version:
$Header: atgpf/appltest/applications/Diagnostics/Engine/src/oracle/apps/fnd/appltest/diagfwk/engine/provider/connection/StandAloneConnectionProvider.java /main/26 2009/07/23 20:16:55 ilawler Exp $
Author:
ppradhan

Nested Class Summary
 
Nested classes/interfaces inherited from interface oracle.apps.fnd.appltest.diagfwk.common.DiagConstants
DiagConstants.ExecutionMode, DiagConstants.Format, DiagConstants.LinkType, DiagConstants.Status
 
Field Summary
protected static java.lang.String SQL_CREATE_APPLSESSION
           
protected static java.lang.String SQL_TERMINATE_APPLSESSION
           
 
Fields inherited from interface oracle.apps.fnd.appltest.diagfwk.common.DiagConstants
APPS_MSG_ID_TAG_NAME, CFG_ADR_PROVIDER_CLASS, CFG_CACHE_PROVIDER_CLASS, CFG_CRED_PROVIDER_CLASS, CFG_DAO_FACTORY_CLASS, CFG_DB_CONN_INFO_PROVIDER_CLASS, CFG_DB_CONN_PROVIDER_CLASS, CFG_NLS_PROVIDER_CLASS, CFG_PLSQL_PROVIDER_CLASS, CFG_PROFILE_PROVIDER_CLASS, CFG_SECURITY_PROVIDER_CLASS, CFG_SESSION_INFO_PROVIDER_CLASS, CFG_URL_PROVIDER_FACTORY_CLASS, CFG_WLS_MBEANSRV_CONNINFO_PROVIDER_CLASS, DATA_SECURITY_PERMISSION_ALLOWED, DATA_SECURITY_PERMISSION_NOT_ALLOWED, DELIM_URL, EXEC_MODE_CLI, EXEC_MODE_ESS, EXEC_MODE_INCIDENT, EXEC_MODE_JAVA, EXEC_MODE_UI, EXECUTABLE_TYPE_JAVA, EXECUTABLE_TYPE_PLSQL, EXECUTABLE_TYPE_TESTREF, FORMAT_HTML, FORMAT_XML, GUID_ORACLE_MINUS1, GUID_ORACLE_ZERO, INPUTS_STATUS_ALL_OPT_INPUTS, INPUTS_STATUS_NO_INPUTS, INPUTS_STATUS_REQ_INPUTS_NO_DEFAULTS, INPUTS_STATUS_REQ_INPUTS_W_DEFAULTS, IO_FLAG_I, IO_FLAG_O, JMX_API_BASE_OBJECT_NAME, LINK_EXTERNAL, LINK_INTERNAL, LINK_METALINK, N, NLS_BUNDLE_JAVA_RES, NLS_BUNDLE_MSG_SVC, NLS_BUNDLE_RES_REF, NLS_BUNDLE_XLIFF, NO, NULL, ODF_MBEAN_DOMAIN_NAME, PARAM_MON_INTERVAL, PLSQL_DEBUG_ENABLED_SYSTEM_PROP, PREREQ_TYPE_TAG_VALUE, PREREQ_TYPE_TEST, SECONDS_IN_ONE_DAY, SECONDS_IN_ONE_HOUR, STATUS_CANCELED, STATUS_EXECERROR, STATUS_FAILURE, STATUS_RUNNING, STATUS_SUCCESS, STATUS_WARNING, SYS_PROP_MAX_MONITOR_INTERNVAL, SYS_PROP_MAX_NUM_THREADS, SYSPROP_APPCONNFILE, SYSPROP_DIAG_CONFIG_FILE, TAG_TYPE_DIAG, TAG_TYPE_TAXONOMY, TEST_TYPE_DECL, TEST_TYPE_JAVA, USER_NAME, WEB_APP_NAME_TAG_NAME, Y, YES
 
Constructor Summary
StandAloneConnectionProvider()
           
 
Method Summary
 void clean()
          Closes the connection if one exists.
protected static java.sql.Connection createConnection()
          Makes a JDBC Connection based on a properties file specified by the APPCONNFILE system property.
 java.sql.Connection getDBConnection()
          Returns a JDBC Connection object
protected static void initializeConnection(java.sql.Connection conn)
          Helper to createConnection to do that post-create initialize steps for Data Security
 void returnDBConnection(java.sql.Connection pCon)
          Returns the JDBC Connection object previously borrowed from the provider.
 
Methods inherited from class oracle.apps.fnd.appltest.diagfwk.engine.provider.connection.ConnectionProvider
cleanup, closeDBConnection, getConnection, getInstance, reset, returnConnection
 
Methods inherited from class oracle.apps.fnd.appltest.diagfwk.common.DiagBaseFactory
createClassLoader, loadClassFor
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

SQL_CREATE_APPLSESSION

protected static final java.lang.String SQL_CREATE_APPLSESSION
See Also:
Constant Field Values

SQL_TERMINATE_APPLSESSION

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

StandAloneConnectionProvider

public StandAloneConnectionProvider()
Method Detail

getDBConnection

public java.sql.Connection getDBConnection()
Description copied from class: ConnectionProvider
Returns a JDBC Connection object

Specified by:
getDBConnection in class ConnectionProvider

clean

public void clean()
Closes the connection if one exists.

Specified by:
clean in class ConnectionProvider

initializeConnection

protected static void initializeConnection(java.sql.Connection conn)
Helper to createConnection to do that post-create initialize steps for Data Security

Parameters:
conn -

createConnection

protected static java.sql.Connection createConnection()
                                               throws java.sql.SQLException
Makes a JDBC Connection based on a properties file specified by the APPCONNFILE system property.

Returns:
a database connection
Throws:
java.sql.SQLException

returnDBConnection

public void returnDBConnection(java.sql.Connection pCon)
Description copied from class: ConnectionProvider
Returns the JDBC Connection object previously borrowed from the provider.

Specified by:
returnDBConnection in class ConnectionProvider
Parameters:
pCon - JDBC Connection object to be returned to the provider

Oracle Fusion Middleware extensions for Logging and Diagnostic
11g Release 1 (11.1.1.6)

E22565-06

Copyright © 2012 Oracle. All Rights Reserved.