We have been facing this Database connection hanging problem in our wM Integration Server.
Once we see this problem we can’t do any manipulation on this database. After restart the Integration Server (v 4.6 sp2) then we are able to access this database again with out any changes in Database side.
Currently we enabled database connection pooling with following params in server.cnf.
3.watt.server.db.testSQL=select 1 from dual
Also we created each database alias with
minimum connecitons = 2 and maximum connections = 10 with timeout 60000 ms.
Database: Oracle 9.2
We have taken care of closing the db connections while processing the request in our code. (both try and catch blocks).
Once we see this problem, if we try to run any db command(say exec sql) it is not throwing any error or even not timing out. I think timeout (300 sec - 5 mins in server.cnf) is not working.
Any body see this problem?.