Fw: Apache::DBI using 'reauthenticate' instead of caching

[Jeff Horn <je...@intralect.com>]

Gentlemen:

Have you had any time to look at this?  I'm attatching my modified version of Apache::DBI.  Please send me your comments and concerns as I would like to send this out to the mod_perl and DBI community very shortly.  I thank you for your time!

----- Original Message ----- 
From: Jeff Horn 
To: E.Mergl@bawue.de ; dougm@cp.net ; Tim.Bunce@ig.co.uk 
Sent: Tuesday, June 20, 2000 7:50 PM
Subject: RFC: Apache::DBI using 'reauthenticate' instead of caching


Gentlemen:

John Groenveld suggested that I run this by each of you.  I have made a hack to Apache::DBI which uses the Oracle specific DBD call to
$dbh->func($user, $pwd, 'reauthenticate') to maintain a single connection per Oracle database and then simply reauthenticate on the existing connection.  This turns out to be 5-6 times faster than initiating a brand new connect for each script.

Now, this is slower than straight Apache::DBI in an environment where the same connect string is used for every script running on a web server.  However, it is a definite win in situations where database level security is being used and there are large numbers of logins!

If you have any time to look at this I'd be most appreciative.  I'd like to contribute this to CPAN as soon as I run it by a few more people and add a few bells and whistles.  Your suggestions as to what to name the new module would also be appreciated.  Currently it's implemented as a replacement for Apache::DBI (and steals the name), but before I submit it I want to rename the module (perhaps to something like Apache::DBI::Reauth).

One problem that needs to be addressed before making this generally available is that I need to set DBI attributes back to their defaults and then reset any specified in the connect string before returning the database handle.  This is not a problem in my current environment, but will be in a general environment.  Any other problems you see with the code are appreciated!

Thank you so much for your valuable time!

-- Jeff Horn