I read in an IBM faq site for Websphere that "Ensure that Connection Timeout is less than the transaction timeout"
But there is no explanation given on why this must be so ? Can any of the websphere gurus help me out on this ?
The problem that I am facing in my application is that many a times a transaction occurs which exceeds more than 30 mins (which is the transaction timeout set in WAS3.5), an I get a JTS/JTA Transaction aborted exception. But on the database end, that transaction keeps on going for hours togather till we get the session killed by the DBA. And while all this is happening the performance of the application deterioates, with a lot of users getting timeout pages on their screens.