JDBC adapter explicit transaction help

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


John,

Do you have any start and commit/rollback’s in the wrapper services?

Also, FYI there is a fix174 available for incomplete explicit commit/rollback. The fix will check the service completion logic and will clean the transaction if necessary.

Thanks,
SATYA.

Satya,
No, we do not have commit/rollback in both wrapper services. Is it needed?

Also, Fix 174 is for IS4.6 right? We are in IS61 sp1.

Thanks,
John

John,

Yes, it is Fix 174.

I was just asking whether you have any commit/rollback in your wrapper service in order to analyze the code. As a best practice keep the start transaction before the TOP sequence.

Thanks,
SATYA.