com.ibm.pdq.runtime.datasource.oracle
Class EnhancedXADataSourceForOracle
- java.lang.Object
oracle.jdbc.pool.OracleDataSource
oracle.jdbc.pool.OracleConnectionPoolDataSource
oracle.jdbc.xa.OracleXADataSource
oracle.jdbc.xa.client.OracleXADataSource
com.ibm.pdq.runtime.datasource.oracle.EnhancedXADataSourceForOracle
public class EnhancedXADataSourceForOracle extends oracle.jdbc.xa.client.OracleXADataSource implements EnhancedDataSource, DataSourceExtends the class
oracle.jdbc.xa.client.OracleXADataSource
to provide support for pureQuery.
Field Summary
Modifier and Type | Field and Description |
---|---|
|
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 |
---|---|
getPdqProperties()
|
|
|
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
Constructor Detail
EnhancedXADataSourceForOracle
public EnhancedXADataSourceForOracle( ) throws SQLException
Method Detail
getPdqProperties
public String getPdqProperties( )
EnhancedDataSource
EnhancedDataSource.setPdqProperties(String pdqProperties)
. If setPdqProperties(String pdqProperties)
is not
invoked, returns null
.
getPdqProperties
in interface EnhancedDataSource
EnhancedDataSource.setPdqProperties(String pdqProperties)
. Returns null
if
setPdqProperties(String pdqProperties)
is not invoked. setPdqProperties
public void setPdqProperties(String pdqProperties)
EnhancedDataSource
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.
- A file named
pdq.appwide.properties
in the classpath of the application - A file named
pdq.
dataSourceName.properties
in the classpath of the application - The string of properties specified to
setPdqProperties(String pdqProperties)
- A file named
pdq.properties
in the classpath that is used to loadpdq.jar
setPdqProperties
in interface EnhancedDataSource
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.
EnhancedXADataSourceForOracle
.