com.ibm.pdq.runtime.datasource.oracle
Class EnhancedConnectionPoolDataSourceForOracle

java.lang.Object
  extended by oracle.jdbc.pool.OracleDataSource
      extended by oracle.jdbc.pool.OracleConnectionPoolDataSource
          extended by com.ibm.pdq.runtime.datasource.oracle.EnhancedConnectionPoolDataSourceForOracle
All Implemented Interfaces:
EnhancedDataSource, Serializable, Referenceable, ConnectionPoolDataSource, DataSource

public class EnhancedConnectionPoolDataSourceForOracle
extends oracle.jdbc.pool.OracleConnectionPoolDataSource
implements EnhancedDataSource, DataSource

Extends the class oracle.jdbc.pool.OracleConnectionPoolDataSource to provide support for pureQuery.

See Also:
Serialized Form

Field Summary

Modifier and Type Field and Description
static long serialVersionUID
           

Fields inherited from class oracle.jdbc.pool.OracleConnectionPoolDataSource
BUILD_DATE, PRIVATE_TRACE, TRACE

Fields inherited from class oracle.jdbc.pool.OracleDataSource
isOracleDataSource

Constructor Summary

Constructor and Description
EnhancedConnectionPoolDataSourceForOracle()
          Constructs an instance of EnhancedConnectionPoolDataSourceForOracle.

Method Summary

Modifier and Type Method and Description
 String getPdqProperties()
          Returns the string of pureQuery properties that was set by using the method EnhancedDataSource.setPdqProperties(String pdqProperties).
 void setPdqProperties(String pdqProperties)
          Sets the pureQuery properties for this data source.

Methods inherited from class oracle.jdbc.pool.OracleConnectionPoolDataSource
getPooledConnection, getPooledConnection

Methods inherited from class oracle.jdbc.pool.OracleDataSource
close, filterConnectionProperties, getConnection, getConnection, getConnection, getConnection, getConnectionCacheName, getConnectionCacheProperties, getConnectionCachingEnabled, getConnectionProperties, getDatabaseName, getDataSourceName, getDescription, getDriverType, getExplicitCachingEnabled, getFastConnectionFailoverEnabled, getImplicitCachingEnabled, getLoginTimeout, getLogWriter, getMaxStatements, getNetworkProtocol, getONSConfiguration, getPortNumber, getReference, getServerName, getServiceName, getTNSEntryName, getURL, getUser, setConnectionCacheName, setConnectionCacheProperties, setConnectionCachingEnabled, setConnectionProperties, setDatabaseName, setDataSourceName, setDescription, setDriverType, setExplicitCachingEnabled, setFastConnectionFailoverEnabled, setImplicitCachingEnabled, setLoginTimeout, setLogWriter, setMaxStatements, setNetworkProtocol, setONSConfiguration, setPassword, setPortNumber, setServerName, setServiceName, setTNSEntryName, setURL, setUser

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface javax.sql.DataSource
getConnection, getConnection, getLoginTimeout, getLogWriter, setLoginTimeout, setLogWriter

Methods inherited from interface javax.sql.ConnectionPoolDataSource
getLoginTimeout, getLogWriter, setLoginTimeout, setLogWriter

 

Field Detail

serialVersionUID

public static final long serialVersionUID
See Also:
Constant Field Values

Constructor Detail

EnhancedConnectionPoolDataSourceForOracle

public EnhancedConnectionPoolDataSourceForOracle()
                                          throws SQLException
Constructs an instance of EnhancedConnectionPoolDataSourceForOracle.
Throws:
SQLException

Method Detail

getPdqProperties

public String getPdqProperties()
Description copied from interface: EnhancedDataSource
Returns the string of pureQuery properties that was set by using the method EnhancedDataSource.setPdqProperties(String pdqProperties). If setPdqProperties(String pdqProperties) is not invoked, returns null.
Specified by:
getPdqProperties in interface EnhancedDataSource
Returns:
the string of pureQuery properties that was set by using the method EnhancedDataSource.setPdqProperties(String pdqProperties). Returns null if setPdqProperties(String pdqProperties) is not invoked.
See Also:
EnhancedDataSource.getPdqProperties()

setPdqProperties

public void setPdqProperties(String pdqProperties)
Description copied from interface: EnhancedDataSource
Sets the pureQuery properties for this data source. The pureQuery properties control the pureQuery functionality of the data source.

pdqProperties must be a string of the pureQuery properties. The string must be in this format:
    property1Key(property1Value),property2Key(property2Value),property3Key(property3Value)...
Each property must be listed as the property name, followed by the value in parentheses. Properties must be separated by commas.

The following properties are supported:

This example properties string directs pureQuery to capture SQL that is executed by connections that are created by the data source. The SQL is captured in the capture file C:\directory\captureFile.pdqxml:
    captureMode(ON),pureQueryXml(C:\directory\captureFile.pdqxml)

pureQuery properties can also be specified in a properties file. For each property, pureQuery looks in the following places in the order listed. pureQuery uses the first value that it finds.

  1. A file named pdq.appwide.properties in the classpath of the application
  2. A file named pdq.dataSourceName.properties in the classpath of the application
  3. The string of properties specified to setPdqProperties(String pdqProperties)
  4. A file named pdq.properties in the classpath that is used to load pdq.jar
Specified by:
setPdqProperties in interface EnhancedDataSource
Parameters:
pdqProperties - A string that contains the pureQuery properties to set for this data source. Each property must be listed as the property name, followed by the value in parentheses. Properties must separated by commas.