wMusers,
Can you tell me if there is something wrong with the logic if flow service? This is an explicit call with 2 XA transactions.
We get connections that are not getting closed properly. It shows as “busy” when run getConnectionStatistics but “inactive” in Oracle. When the service hits the max # of connections allowed by the pool, we get a:
“Unable to get a connection to resource AdapterConnections:DBS_ORAFIN_XA.
The pool doesn’t have a connection available for the request.”
Thanks.
IS 6.1 SP1 w/
TNS_6-1_Fix15
IS_6-1_FP2
IS_6-1_SP1_Fix36
IS_6-1_SP1
TNS_6-1_Fix9
JDBC6.0.3, Oracle 9 db, classes12.zip.
Sequence TOP:
startTransaction
Sequence TRY:
folder1:wrapper_service_XA1 (invokes other service with XA insert)
Branch on /isError:
Sequence FALSE:
folder2:wrapper_service_XA2 (invokes other service wtih XA update)
Branch on /isError:
Sequence FALSE:
commitTransaction
Sequence Default:
rollbackTransaction
Sequence Default:
rollbackTransaction
Exit on success:
Sequence CATCH:
rollbackTransaction