Hi -
I am not sure on what type of application you are
building, but doing connection related stuff
(including running sql over already established
connection in jsp) isnt very good idea. Read about mvc
model if you are in design stage.
In anycase, if you still need access to pooled
connection, tomcat offers connection pooling (in the
default server.xml ) and refer to apache jsp taglib on
how to access one.
FYI
srini
--- phani <[EMAIL PROTECTED]> wrote: > Hi,
>
> I am using a bean to get connection for a db from my
> jsp page. But the problem is for each and every
> request the page fetches a connection from the
> bean. This becomes a over head to the system.
> What i want to do is i want to open n no (say 50 )
> of connection when the server is started and any
> request must be routed through these connection
> only.
>
> How to do this?
>
> Thanks in advance.
>
> phani
>
=====
Thanks and have great day
srini
________________________________________________________________________
Missed your favourite TV serial last night? Try the new, Yahoo! TV.
visit http://in.tv.yahoo.com
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>