While there are connection pools (I have not used them but others on the
list can point you to them), I find the easiest solution is a session
variable. Then make a function you can call with the session and db
connection info. The function checks the session for the DB varaible. If
it's not there it creates the connection and adds it to the session. Then
returns the DB. That way the call to get the connection looks nice and clean
(no nasty if statements to cloud up your HTML on the JSP).
Regards,
Paul
-----Original Message-----
From: John Coonrod [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 4:19 PM
To: [EMAIL PROTECTED]
Subject: Speeding up database accesses
I would like to leave my oracle database connection open from one page to
another within a session - is that possible? Is it possible to pool one
connection for the entire webserver? If so, how? Thanks.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
