Re: dbConnection in servlet/jsp

2000-09-06 Thread yashmehta
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

Re: dbConnection in servlet/jsp

2000-09-06 Thread Filippos Slavik
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

Re: dbConnection in servlet/jsp

2000-09-06 Thread Kevin Mukhar
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

Re: dbConnection in servlet/jsp

2000-09-06 Thread Filippos Slavik
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

Re: dbConnection in servlet/jsp

2000-09-06 Thread Geeta Ramani
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

Re: dbConnection in servlet/jsp

2000-09-06 Thread Kevin Mukhar
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