com.ibm.pdq.runtime.datasource.oracle

Class EnhancedXADataSourceForOracle

  1. java.lang.Object
  2. extended byoracle.jdbc.pool.OracleDataSource
  3. extended byoracle.jdbc.pool.OracleConnectionPoolDataSource
  4. extended byoracle.jdbc.xa.OracleXADataSource
  5. extended byoracle.jdbc.xa.client.OracleXADataSource
  6. extended bycom.ibm.pdq.runtime.datasource.oracle.EnhancedXADataSourceForOracle
All implemented interfaces:
EnhancedDataSource, Serializable, Wrapper, Referenceable, CommonDataSource, ConnectionPoolDataSource, DataSource, XADataSource

public class EnhancedXADataSourceForOracle
extends oracle.jdbc.xa.client.OracleXADataSource
implements EnhancedDataSource, DataSource
Extends the class oracle.jdbc.xa.client.OracleXADataSource to provide support for pureQuery.
See Also:
Serialized Form

Field Summary

Modifier and Type Field and Description
  1. static
  2. long
serialVersionUID
Fields inherited from class oracle.jdbc.xa.client.OracleXADataSource
BUILD_DATE, PRIVATE_TRACE, TRACE
Fields inherited from class oracle.jdbc.pool.OracleDataSource
isOracleDataSource

Constructor Summary

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

Method Summary

Modifier and Type Method and Description
  1. String
getPdqProperties()
  1. void
setPdqProperties(String pdqProperties)
Methods inherited from class oracle.jdbc.xa.client.OracleXADataSource
getPooledConnection, getPooledConnection, getXAConnection, getXAConnection, getXAConnection
Methods inherited from class oracle.jdbc.xa.OracleXADataSource
getNativeXA, setNativeXA
Methods inherited from class oracle.jdbc.pool.OracleConnectionPoolDataSource
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
Methods inherited from interface javax.sql.CommonDataSource
getLoginTimeout, getLogWriter, setLoginTimeout, setLogWriter
Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap

Field Detail

serialVersionUID

public static final long serialVersionUID
See Also:

Constructor Detail

EnhancedXADataSourceForOracle

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

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:
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:

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:

  • capturedOnly (true|false)
  • captureMode (ON|OFF)
  • captureStatementBatchSQL (ON|OFF)
  • enableDynamicSQLReplacement (true|false)
  • maxNonParmSQL (maxNonParameterized-SQL-Integer)
  • maxStackTracesCaptured (maxStackTracesCapture-Integer)
  • outputPureQueryXml (outputPureQueryXmlFilePath)
  • packagePrefixExclusions (multiplePrefixesSeparatedBy|)
  • pureQueryXml (pureQueryXmlFilePath)
  • stackTraceDepth (maxStackTraceDepth-Integer)
  • sqlLiteralSubstitution (NOT_SET|ENABLE|DISABLE)

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:
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.