psdi.server

Class CustomDriverProxyManage

java.lang.Object

psdi.server.CustomDriverProxyManage

All Implemented Interfaces:

java.sql.Driver, FixedLoggerNames, FixedLoggers

public class CustomDriverProxyManage
extends java.lang.Object
implements java.sql.Driver, FixedLoggers

CustomDriverProxyManage is a means of configuring the database driver without having to make changes to the DBManager class, same as existing CustomDriverProxy (not working for oracle jdbc options) The class was created to support connection with custom jdbc options to oracle db from Manage Assumption : Manage appends prefix 'proxy-:' to the db url if the the connection has jdbc-options

To use CustomDriverProxyManage, do the following:

1. Specify CustomDriverProxyManage in the maximo.properties file as follows:
   mxe.db.driver=psdi.server.CustomDriverProxyManage //append prefix 'proxy-:' to the db url
2. Create a new file named customdriver.properties in the properties folder. Within this file, define the name of the "real" driver and any additional properties you want to configure. For example, you would define the "real" Oracle driver like this:
   realdriverclass=oracle.jdbc.OracleDriver
   Additional property names would be prepended with "properties." in the customdriver.properties file. In the example below, we have configured the property oracle.net.encryption_client:
   property.oracle.net.encryption_client=REQUIRED

The CustomDriverProxyManage class is provided as a convenience. The product does not support every conceivable combination of drivers and properties. It is the responsibility of the client to verify that the requested configuration works properly.

Field Summary

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
CustomDriverProxyManage()

Method Summary

Modifier and Type	Method and Description
boolean	acceptsURL(java.lang.String url)
java.sql.Connection	connect(java.lang.String url, java.util.Properties info)
int	getMajorVersion()
int	getMinorVersion()
java.util.logging.Logger	getParentLogger()
java.sql.DriverPropertyInfo[]	getPropertyInfo(java.lang.String url, java.util.Properties info)
java.lang.String	getRealUrl(java.lang.String url)
boolean	jdbcCompliant()

Methods inherited from class java.lang.Object

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

Constructor Detail

CustomDriverProxyManage

public CustomDriverProxyManage()

Method Detail

getRealUrl

public java.lang.String getRealUrl(java.lang.String url)

acceptsURL

public boolean acceptsURL(java.lang.String url)
                   throws java.sql.SQLException

Specified by:

acceptsURL in interface java.sql.Driver

Throws:

java.sql.SQLException

connect

public java.sql.Connection connect(java.lang.String url,
                                   java.util.Properties info)
                            throws java.sql.SQLException

Specified by:

connect in interface java.sql.Driver

Throws:

java.sql.SQLException

getMajorVersion

public int getMajorVersion()

Specified by:

getMajorVersion in interface java.sql.Driver

getMinorVersion

public int getMinorVersion()

Specified by:

getMinorVersion in interface java.sql.Driver

getPropertyInfo

public java.sql.DriverPropertyInfo[] getPropertyInfo(java.lang.String url,
                                                     java.util.Properties info)
                                              throws java.sql.SQLException

Specified by:

getPropertyInfo in interface java.sql.Driver

Throws:

java.sql.SQLException

jdbcCompliant

public boolean jdbcCompliant()

Specified by:

jdbcCompliant in interface java.sql.Driver

getParentLogger

public java.util.logging.Logger getParentLogger()
                                         throws java.sql.SQLFeatureNotSupportedException

Specified by:

getParentLogger in interface java.sql.Driver

Throws:

java.sql.SQLFeatureNotSupportedException