John--
Another thing you may want to look into is just doing an
"alter session set current_schema" call at the top of your mod_perl page.
This is actually significantly faster than Tim's reauthenticate solution
(about 7X, according to my benchmarks).
It has become a supported feature as of Oracle 8i. For details on what I
did, see http://www.lifespree.com/modperl/ (which is still a total mess
right now-- I'll get around to cleaning it up sometime soon, I promise!)
cheers,
Ed
-----Original Message-----
From: John D Groenveld [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 10, 2001 5:10 PM
To: Edmund Mergl
Cc: [EMAIL PROTECTED]
Subject: Re: Edmund Mergl
Good to see you alive, well, and still coding Perl.
Months ago, about the time of the Perl conference so it may have slipped
under everyone's radar, Jeff Horn from U of Wisconsin sent you some patches
to Apache::DBI to use Oracle 8's re-authenticate function instead of
creating and caching a separate Oracle connection for each user. Did you
decide whether to incorporate them or to suggest another module name for
him to use? I wasn't able to participate in the discussion at the time,
but I now have need for that functionality. I don't know if Jeff Horn is
still around, but I'll track him down if necessary and offer to work on it.
Also, I sent you a small patch to fix Apache::DBI warnings under Perl5.6.
I hate to be a pest, but I'm rolling out software where the installation
procedure requires the user to fetch Perl from Active State and Apache::DBI
from CPAN. I'd rather not ship my own version of yours or any CPAN module.
Thanks,
John
[EMAIL PROTECTED]
