My Oracle Support Banner

WDT discoverDomain.sh Can Not Discover Some JDBC Parameters (Doc ID 2989461.1)

Last updated on DECEMBER 04, 2023

Applies to:

Oracle Verrazzano Enterprise Container Platform - Version 1.6.5 and later
Information in this document applies to any platform.

Symptoms

WDT discoverDomain.sh  can not discover some JDBC parameters in case of default boolean is true as following parameters.

IgnoreInUseConnectionsEnabled
RemoveInfectedConnections
WrapTypes
KeepConnAfterLocalTx
UseXaDataSourceInterface
KeepXaConnTillTxComplete
ResourceHealthMonitoring


If it is set as false, WDT should detect it as false , but it is not educed.

For example, here is jdbc config for connection pool.

<jdbc-connection-pool-params>
<ignore-in-use-connections-enabled>false</ignore-in-use-connections-enabled>
<test-table-name>SQL SELECT 1 FROM DUAL</test-table-name>
<remove-infected-connections>false</remove-infected-connections>
<pinned-to-thread>true</pinned-to-thread>
<wrap-types>false</wrap-types>
</jdbc-connection-pool-params>

Discover domain result is here

JdbcResource:
JDBCConnectionPoolParams:
PinnedToThread: true
TestTableName: SQL SELECT 1 FROM DUAL

In JDBC config.xml, ignore-in-use-connections-enabled,remove-infected-connections and wrap-types  are set as false. (default is true)
It did not set RemoveInfectedConnections, IgnoreInUseConnectionsEnabled, WrapTypes in WDT yaml. So migrated JDBC config will be different as original setting.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.