com.ibm.pdq.runtime.datasource.datadirect
Class EnhancedDataSourceForOracle
- java.lang.Object
com.ibm.pdq.runtime.datasource.datadirect.EnhancedDataSourceForOracle
public class EnhancedDataSourceForOracle extends Object implements EnhancedDataSource, DataSourceA wrapper for the class
com.ddtek.jdbcx.oracle.OracleDataSource
that provides support for pureQuery.
com.ddtek.jdbcx.oracle.OracleDataSource
supports JDBC 3.0.
Field Summary
Modifier and Type | Field and Description |
---|---|
|
serialVersionUID
|
Constructor Summary
Constructor and Description |
---|
EnhancedDataSourceForOracle()
Constructs an instance of
EnhancedDataSourceForOracle .
|
Method Summary
Modifier and Type | Method and Description |
---|---|
getPdqProperties()
|
|
|
setPdqProperties(String pdqProperties)
|
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
EnhancedDataSourceForOracle
public EnhancedDataSourceForOracle( ) 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.
EnhancedDataSourceForOracle
.