• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

my apache-tomcat webserver gets down time to time at very short intervals

 
AnupKumar Tripathi
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
our website is fameboxx.com. its up and a social networking site with a no.of modules(19 modules) having many tables(116 tables) and a single database.

the website gets down time to time at very short intervals. we want to get rid of this problem ASAP.

the server guys say, there is some problem in code.they are saying that mysql connections are not properly closed. while its not true. we have closed the connections on each pages and reopen when they need.

i m in great trouble , please help !
thanks in advance !!!
 
Ad Rajesh
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, What version of tomcat your are using?
 
AnupKumar Tripathi
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ad Rajesh wrote:Hi, What version of tomcat your are using?



we are using Apache tomcat 2.something.. not so clear ! you took interest in my question so thanks for this !! hope you will solve my problem ! please help !! Thanks in advance for it..
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64832
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tomcat 2? Or something? I don't think so!

If you are not going to provide any details, no one will be able to help you.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64832
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
P.S. You should be user container-managed connection pooling. Manually managing the connectionz is almost always a recipe for disaster.
 
AnupKumar Tripathi
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Bear Bibeault wrote:P.S. You should be user container-managed connection pooling. Manually managing the connectionz is almost always a recipe for disaster.



i can tell you tomorrow the correct version of the tomcat we are using,.
one thing more .. i m using a connection object on every page and closing the connection properly after page seizes to exist. for this i have made a simpe java program for connection and put its compiled(class file ) in classes directory of WEB-INF . i just create object of this class for establishing the connection. And while i know java does garbage collection for the objects used on a page when it gets unused further( when we switch from one page to another),,,, i have manually nullified each of the objects used on the page..
Thus i have done my best to overcome such saturation i m suffering with..
And most importantly as sever gets down and we make it restart by requesting from sever guys for it.. it gets well and behaves as it was never down. i mean , then it stats working very good.. but after some time .. it gets down again.
thanks again of your responses .. please help me by your further suggestion .and as you said we should use the connection pooling . please guide about connection pooling in java n provide the code for the connection pooling in java .. i would be very graceful to you.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64832
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Setting up Tomcat connection pooling has been covered in this forum before. Search back for details...
 
AnupKumar Tripathi
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Bear Bibeault wrote:Setting up Tomcat connection pooling has been covered in this forum before. Search back for details...


could you please justify how is the Approach i m using , is wrong..? please dont mind , i just want to know the stories behind its failure if it is..

And please tell me.. why does the whole server (the web server) get down only by unoptimized use of the mysql connection?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic