psdi.server

Class OracleProxyDBManager

java.lang.Object

psdi.server.DBManager

psdi.server.OracleProxyDBManager

All Implemented Interfaces:

FixedLoggerNames, FixedLoggers

public class OracleProxyDBManager
extends DBManager

This is a java.util.Vector of java.sql.Connections. In addition, it has a name, and a set of values required to establish the connection.

Version:

%I%, %G%

Author:

John Langley

See Also:

DBManager, MXServer

Field Summary

Fields

Modifier and Type	Field and Description
static int	MODECERTIFICATE
static int	MODEDN
static int	MODEUSERNAME
static int	MODEUSERNAMEPASSWORD
static java.lang.String	ORADBPROXYMODE The attribute name that can be set to MXSession to indicate the database proxy mode for the connecting user if different than the proxy mode set for the system.

Fields inherited from class psdi.server.DBManager

FASTFORWARD, FORWARDONLY, refQue, SCROLLINSENSITIVE, SCROLLSENSITIVE, SCROLLSENSITIVEONE, ssPropLoaded, stmtQueue

Fields inherited from interface psdi.util.logging.FixedLoggers

APPLOGGER, CRONTASKLOGGER, CRONTASKMGRLOGGER, CRONTASKMGRSQLLOGGER, DBCONNECTIONLOGGER, DDLOGGER, DMLOGGER, EVENTLOGGER, EXCEPTIONLOGGER, MAILLOGGER, MAXIMOLOGGER, MTLOGGER, NULLMBOPOINTER, SECURITY, SENDFAILEDLOGGER, SERVICELOGGER, SQLLOGGER

Fields inherited from interface psdi.util.logging.FixedLoggerNames

appenderPrefix, LOGGERNAME_APP, LOGGERNAME_CRONTASK, LOGGERNAME_CRONTASKMGR, LOGGERNAME_DBCONNECTION, LOGGERNAME_DD, LOGGERNAME_DM, LOGGERNAME_DMPREVIEW, LOGGERNAME_EVENT, LOGGERNAME_EXCEPTION, LOGGERNAME_MAIL, LOGGERNAME_MAXIMO, LOGGERNAME_MT, LOGGERNAME_NULLMBOPOINTER, LOGGERNAME_SECURITY, LOGGERNAME_SENDFAILED, LOGGERNAME_SERVICE, LOGGERNAME_SQL, LOGGERNAME_SQL_CRONTASKMGR, LOGGERNAME_TXN, loggerPrefix

Constructor Summary

Constructors

Constructor and Description
OracleProxyDBManager()

Method Summary

Modifier and Type	Method and Description
void	configure(java.util.Properties properties) configure the DBManager based on the information in the properties file read in.
void	destroy() Closes database connections, set's both the used and free vectors to null
void	freeConnectionDetail(ConnectionKey conKey)
java.sql.Connection	getConnectionDetail(ConnectionKey conKey) Get's a connection.
DBCredentialHandler	getCredentialHandler()
int	getDBAuthenticationType() Return the authentication type.
oracle.jdbc.pool.OracleOCIConnectionPool	getNewConnectionPool(java.lang.String url, java.lang.String userName, java.lang.String password)
ConRef	getProxyConnection(oracle.jdbc.pool.OracleOCIConnectionPool pool, java.lang.Object certi)
java.sql.Connection	getSequenceConnection() Returns the connection used for generating sequence for sqlserver This should not be used by any application services or business objects.
java.sql.Connection	getSystemConnection() Returns the system connection.
boolean	init() Loads a driver, and establishes a series of connections with the specified database.

Methods inherited from class psdi.server.DBManager

cleanupStatementQueue, finalization, finalization, flushFreeConnections, freeConnection, freeConnection, getConnection, getDatabaseProductName, getDatabaseProductSimpleVersion, getDatabaseProductVersion, getDB2Version, getDBConnFree, getDBConnTotal, getDBConnUsed, getDBPlatform, getDbSqlServerDriver, getLock, getName, getProperties, getReferenceQueue, getSchemaOwner, getSPID, getSQLTimeLimit, getSSCursorType, getSSDisableCursor, getSSFetchSize, getSSFetchUse, getSystemConnectionKey, getTenantUsedConnCount, logSQLPlan, needToLogSQLOnTimeLimit, needToLogSQLPlan, printStackTraceNoMsg, readSQLTimeLimit, reloadDBRefCount, reloadDBRowCount, reloadLogSQLPlan, reloadProperties, reloadSQLScanExclude, reloadSQLTimeLimit, sqlTableScanExclude

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

MODEUSERNAME

public static final int MODEUSERNAME

See Also:

Constant Field Values

MODEUSERNAMEPASSWORD

public static final int MODEUSERNAMEPASSWORD

See Also:

Constant Field Values

MODEDN

public static final int MODEDN

See Also:

Constant Field Values

MODECERTIFICATE

public static final int MODECERTIFICATE

See Also:

Constant Field Values

ORADBPROXYMODE

public static final java.lang.String ORADBPROXYMODE

The attribute name that can be set to MXSession to indicate the database proxy mode for the connecting user if different than the proxy mode set for the system.

See Also:

Constant Field Values

Constructor Detail

OracleProxyDBManager

public OracleProxyDBManager()

Method Detail

configure

public void configure(java.util.Properties properties)

Description copied from class: DBManager

configure the DBManager based on the information in the properties file read in.

Overrides:

configure in class DBManager

init

public boolean init()

Loads a driver, and establishes a series of connections with the specified database.

Overrides:

init in class DBManager

Returns:

true if connections succeed, false otherwise.

destroy

public void destroy()

Closes database connections, set's both the used and free vectors to null

Overrides:

destroy in class DBManager

getConnectionDetail

public java.sql.Connection getConnectionDetail(ConnectionKey conKey)

Get's a connection. Connections come from one of two places,

• from the list of connections already issued; this happens when the key is one already registred by a previous call to this method with the same key.
• from the free list; when the key has not been used a previous call to this method.

freeConnectionDetail

public void freeConnectionDetail(ConnectionKey conKey)

getSystemConnection

public java.sql.Connection getSystemConnection()

Returns the system connection. This should not be used by any application services or business objects.

getSequenceConnection

public java.sql.Connection getSequenceConnection()

Returns the connection used for generating sequence for sqlserver This should not be used by any application services or business objects.

Overrides:

getSequenceConnection in class DBManager

getNewConnectionPool

public oracle.jdbc.pool.OracleOCIConnectionPool getNewConnectionPool(java.lang.String url,
                                                                     java.lang.String userName,
                                                                     java.lang.String password)

getProxyConnection

public ConRef getProxyConnection(oracle.jdbc.pool.OracleOCIConnectionPool pool,
                                 java.lang.Object certi)

getDBAuthenticationType

public int getDBAuthenticationType()

Return the authentication type.

Overrides:

getDBAuthenticationType in class DBManager

getCredentialHandler

public DBCredentialHandler getCredentialHandler()

Overrides:

getCredentialHandler in class DBManager