(jeffa) 3Re: One module for both Apache::DBI and DBI?

"... a regular DB module could probably be used under Apache as well ..."

A regular DB module? Are you wanting to create another database handle, in addition to the persistent ones provided by Apache::DBI? One that is not persistent?

If so then check out recipe 2.13 from the mod_perl Developer's Cookbook. The idea is to use the optional %attr parameter in DBI->connect to allow uncached connections to be created - set dbi_connect_method to the value connect:

my $dbh = DBI->connect(
   'dbi:AnyData:',
   {dbi_connect_method => 'connect'}, 
);
[download]

This will not affect the previously cached connections.

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)

Comment on (jeffa) 3Re: One module for both Apache::DBI and DBI? Download Code