Hi
You can use connection using ConnectionPooling.(bean)
In this u open some initial say 5-10 connections.
& you release connection after completion of every jsp u using.
In each jsp u should include above bean, this bean should be such that
this give a connection from the pool to jsp, if
At 09:01 ðì 6/9/2000 -0600, you wrote:
>Filippos Slavik wrote:
> >
> > At 07:04 ðì 6/9/2000 -0600, you wrote:
> > >Chin Cedric Sung Kit wrote:
> > > >
> > > > i initialize my oracle-jdbc
> > > > database connection in my LoginServlet. how do i re-use this
> connection
> > > > in my other jsp page
Filippos Slavik wrote:
>
> At 07:04 ðì 6/9/2000 -0600, you wrote:
> >Chin Cedric Sung Kit wrote:
> > >
> > > i initialize my oracle-jdbc
> > > database connection in my LoginServlet. how do i re-use this connection
> > > in my other jsp pages, so that i will not have to open so many
> > > connect
At 07:04 ðì 6/9/2000 -0600, you wrote:
>Chin Cedric Sung Kit wrote:
> >
> > i initialize my oracle-jdbc
> > database connection in my LoginServlet. how do i re-use this connection
> > in my other jsp pages, so that i will not have to open so many
> > connections?
>
>You don't re-use your connecti
Hi Ced:
I am not sure of how good/bad the following suggestion is, but it's an idea:
How about setting a session variable to that initial connection object and then
reusing it in your other jsps?
Geeta
Chin Cedric Sung Kit wrote:
> hi,
>
> i have question on the database connection. i initial
Chin Cedric Sung Kit wrote:
>
> i initialize my oracle-jdbc
> database connection in my LoginServlet. how do i re-use this connection
> in my other jsp pages, so that i will not have to open so many
> connections?
You don't re-use your connection. At a minimum, you should use a new
connection fo