Thanks for all for the help.
I found out that the problem is the way how I connect to the database.
With JRun I used
InitialContext ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("xxx");
con = ds.getConnection();
It didn't work with Tomcat for some reason, so I used
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("xxx");
con = ds.getConnection();
And this works very slow or went to sleep or I don't know what.
Now I tried "the good old" way through the DriverManager and it works
perfect.
What should I change in Tomcat configuration to use the first way?
On Sat, 19 Jun 2004 Yana Begun wrote :
>Hi,
>
>I have stand alone version of our web application running with Tomcat.
>
>Everything is fine, but after displaying 5-6 pages it starts to work
>VERY slowly. Like 30 minutes for one page.
>
>CPU is not busy at this moment. It seems like nothing happen or tomcat
>falling asleep.
>
>I thought that the problem is the cheap database that we use for this
>version, but when I tried to connect to the MSSQL, result was the same.
>
>Any recommendations, what I can check or how I can test this stuff?
>
>
>
>Thanks, Yana
>
>
>
<http://clients.rediff.com/signature/track_sig.asp>
