Please consider the example application created using JDeveloper 18.104.22.168.0
It has a bounded task-flow with a page-fragment on which data is shown from two View Objects instances, each from a different Application Module.
It also has its Default run-configuration configured with "-Djbo.doconnectionpooling=true -Djbo.txn.disconnect_level=1".
(see also documentation section "44.3.2 What You May Need to Know About Database User State and jbo.doconnectionpooling = true"
The following scenario (sc1) can be tried:
Run the tryTwoAppMod view activity in adfc-config.xml which will show in an af:region the bounded task-flow two-app-mod-btf with data from two View Object instances in two Application Modules.
Use the IntegratedWebLogicServer console (via http://localhost:7101/console ) to navigate via Deployments to the application UnavailableConnApp and to its connHR JDBC module.
Check the Monitoring tab to see the column values (selected via the "Customize this table" link):
Connections Total Count = 2, Current Capacity = 2, Number Available = 2, Number Unavailable = 0
After stopping/undeploying the application the following scenario (sc2) can be tried:
On the Behaviour tab of the two-app-mod-btf task-flow change the Transaction option to "Use Existing Transaction if Possible".
Run the tryTwoAppMod view activity in adfc-config.xml and check the connHR JDBC module Monitoring tab to see the column values:
Connections Total Count = 1, Current Capacity = 1, Number Available = 0, Number Unavailable = 1
- (q1) Why is "Number Unavailable = 1" for scenario (sc2) and not "Number Unavailable = 0" as in scenario (sc1), given the "-Djbo.doconnectionpooling=true -Djbo.txn.disconnect_level=1" configuration?
- (q2) What should be configured to get the connHR JDBC module Monitoring tab to show the column values:
Connections Total Count = 1, Current Capacity = 1, Number Available = 1, Number Unavailable = 0
Trying similar scenario's using JDeveloper 12c (22.214.171.124.0) shows similar behaviour.