I am a database professional and I have recently been charged with discovering why we can't run database admin activities in the middle of the night. Basically we need exclusive access and we can't seem to get it because there are tomcat connections still active. These often include conections that have been active for more than 12 hours but from the database admin tools I have been able to determine that these connections haven't communicated with the database for as much as 12 hours.
I have just done some more investigations and have discovered that these connections eventually get cleared the next morning and the time they are cleared seems to vary according to the app server they are coming from. I am sure this is a tomcat problem, but that is where I need help. Is there any way in which I can ensure that connections are cleared when they have been idle for about 1 hour? Is there any way that I can run a command to clear all tomcat connections.
I have tried shutting down the database server and bringing it up again, and then running the database admin activities but when I do this the users complain that they can't run certain tomcat driven activities the next day until tomcat is restarted.
Any help would be much appreciated.