I think u should use JDBC POOL BEAN concept upto my knowledge after using
this concept it will not hang ur jsp page n by d way wht error it throw??
On 1/8/07, Andre Prasetya <andre.prasetya@(protected):
>
> When the jsp shows error, its about exception right ? what is the
> exception
> and what does it says ?
>
> On 1/6/07, Michael Ni <mikeni123@(protected):
> >
> > Hi i'm doing a web application to help manage players for the online
> game
> > Final Fantasy XI.
> >
> > Im using tomcat, sqlserver2000, and jsp.
> >
> > both sqlserver and tomcat are set up on the same computer.
> > computer is pentium 2.8 GHZ with 512 RAM.
> > im on cable internet
> >
> > the web application uses simple queries, like search a table for a
> certain
> > condition. i realize when multiple people access the database it hangs,
> > and
> > causes the jsp pages to error.
> >
> > Is it mainly tomcat, or sql server? anyone have any experience on
> setting
> > up websites to handle a lot of traffic?
> >
> > here is my site project
> > http://66.215.70.71/
> >
> > thx
> > mike
> >
> > _________________________________________________________________
> > Get FREE Web site and company branded e-mail from Microsoft Office Live
> > http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/
> >
> >
> > ---------------------------------------------------------------------
> > To start a new topic, e-mail: users@(protected)
> > To unsubscribe, e-mail: users-unsubscribe@(protected)
> > For additional commands, e-mail: users-help@(protected)
> >
> >
>
>
> --
> -Andre-
>
> People see things the way they are and say "why ?" I see things that never
> were and say "Why not ?"
>
>


--
Chaitya Shah