• 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
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Tomcat Oracle issue

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
In our web development project, we have Oracle 9i installed on Win2K Prof Server.Tomcat ver -5.0.28 is also installed on the same.
Project architecture is having Struts framework (v1.2), Spring (1.1.2) & Hibernate framework (2.1). All these components are installed on a Intel-P4, 512Mb Ram windows box.
We are facing follwoing issue -
After login, it takes lot of time (20 - 30 minutes) to load further subsequent pages. We have tried to find out but have no idea why this is happening. We would like to know whether this is a Tomcat issue or a Oracle 9i (on Win2K) or hibernate framework issue. Highly appreciate, if someone can throw lights on this & guide us in identifing the root cause.
Thanks in advance.
- Prashant
[ December 13, 2004: Message edited by: pra gho ]
 
author
Posts: 14112
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What did you do to try to find out until now, and with what findings?
 
Ranch Hand
Posts: 231
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi,
This seems to ba a interesting problem. Are u trying to do any authentication with the login name if so, check if this reteives the expected result in the current duration.
Also check if somewhere something is going on infinite loop. so that the loops continues for say 20 mints after which the system may kill it(not sure).
Are u able to see the correct page after the time u specified, if yes then its some indexing issues in oracle or a logic problem (a guess)
Just try to refactor your code and try again.
 
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi
just try to use some existing profilers and find out where most of the time is spent, that is whetehr in your code, or in the tomcat, or in hibernate, so that you could have a clear pic of which method is taking most of time..and drill down into details of the method..if the method which has query is taking more time..then use some tool to find out the retrival time of query..so you could findout where max time is consumed

hope that it helps
 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi, I�ve got exactly the same problem, did you resolve it?

Have a nice day

Allen
reply
    Bookmark Topic Watch Topic
  • New Topic