• Post Reply Bookmark Topic Watch Topic
  • New Topic

Database connection maintained in Tomcat

 
Dhananjay Inamdar
Ranch Hand
Posts: 130
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello folk,
I am using a tomcat4.1 and oracle8i for my web-base project development. I am working on very big database, where normal queries take minimum 3 to 4 minutes to complete the execution.
We are calling these queries through JSP pages (Normal routine), but if i press the STOP button of the brower then the exceution of jsp get halts but tomcat is doing the query on database as it is holding this connection.
So, if immedietly after stoping the previous page if i try to open any another page with equally big query then it will take tremendous time to execute.
So, does any body know the solution for freeing the connection from tomcat after exceution fo the jsp page is halted.
 
Dhananjay Inamdar
Ranch Hand
Posts: 130
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Folks,
I am still strugulling with this problem, as it is badly hampering the problem of my pages.
If anybody knows the solution to this problem then please let me know.
- Dhananjay
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!