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

java.lang.Object
  oracle.apps.fnd.appltest.diagfwk.common.DiagBaseFactory
      oracle.apps.fnd.appltest.diagfwk.engine.provider.connection.ConnectionProvider
          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