• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Jeanne Boyarsky
  • Ron McLeod
Sheriffs:
  • Paul Clapham
  • Liutauras Vilda
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

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

 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 !!!
 
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi, What version of tomcat your are using?
 
AnupKumar Tripathi
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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..
 
Sheriff
Posts: 67753
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Sheriff
Posts: 67753
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Sheriff
Posts: 67753
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
Get off me! Here, read this tiny ad:
Smokeless wood heat with a rocket mass heater
https://woodheat.net
reply
    Bookmark Topic Watch Topic
  • New Topic