I have a flow service which calls internally two adapter service’s A and B . Both these services uses different database connections and both are created as NO_TRANSACTION. Below is the sequence .
Flow Service start
Adapter service A (using connection A(NO_TRANSACTION))
Adapter service B (using connection B(NO_TRANSACTION))
Flow Service End
If Adapter Service B is struck at database waiting for the response for about 5 mins . will the connection used by Adapter service A is released to the pool as its execution is already complete or will it wait for the entire service to complete the execution .
Question is whether connection pool of connection A is affected if the threads from connection B are all exhausted and busy.
Appreciate your responses on this .