We are having JDBC Local Transaction connection and there is a insert adapter service which calls a store procedure on DB.
Even though the transaction type is local we havent used the start, commit and rollback transaction to manage the transactions.
My question is if we are not manage the transaction using art services does the IS will open a connection when there is a request and close it after there is sucessfull or unscuessfull insert.
This is because on the IS we are seeing Available Thread reached 0% and systems gets hanged.
We believe that when we use Local JDBC transaction we have to manage the transaction because the IS Resource Manger will try to roll back in case if there is any error and returns the connection to the pool but in our case it is not happening because we dont have implicit commit or roll back.
Does my statement is true or any other things on IS is causing us this problem.
Apperciate your quick response.