> Tomcat log files seems as a good starting point.
It just hangs. No logs are generated. It drives me crazy for hours.
Oh, there's another thing to say. Sometimes a test JSP page with
direct JDBC connect succeeds to connect sometimes immediately,
sometimes in about 30 seconds.
Manish Pandit - 18 Aug 2007 05:26 GMT
On Aug 17, 9:07 pm, ky...@naver.com wrote:
> > Tomcat log files seems as a good starting point.
>
[quoted text clipped - 3 lines]
> direct JDBC connect succeeds to connect sometimes immediately,
> sometimes in about 30 seconds.
Run 'top' and check if you see tomcat eating up CPU or memory while it
blocks on a db call.
Given the network latency issue, you can try traceroute from tomcat
box to oracle box and check if you are not seeing any dropped packets
(* in the output). This will also give you an idea of the hops and
latency per hop. Run it a couple of times to get more data points...
-cheers,
Manish
kymmx@naver.com - 18 Aug 2007 05:39 GMT
Sorry, it seems to be the problem in my application. One of my web
page tried to connect to a shutdown server and it hanged all of other
database connections.
Never mind this threads.
Arne Vajhøj - 18 Aug 2007 13:39 GMT
>> Tomcat log files seems as a good starting point.
>
> It just hangs. No logs are generated. It drives me crazy for hours.
Tomcat should generate a log file even if it is running fine.
Arne