We are using SimpleJdbcCall to call oracle stored procedure from IBM WebSphere Application Server (WAS). The transaction management is maintained in stored procedure (at database level). We have given QueryTimeout to procedure call. Consider below scenario.
Invoked stored procedure ABC.
Connection is returned to WAS Connection Pool.
Invoked stored procedure ABC for next request
Now received exception ORA-02067: transaction or savepoint rollback required as earlier Transaction is not committed or rolled back due to QueryTimeoutException. Please find attached exception log.