Hi DBI using people can anyone tell me whether the following will work. I've got myself all confused over persistency (of every kind).
I'm using Mod_perl and apache (1.3) I have a httpd.conf containing PerlSetVar for the DB's datasource, username and password. I get these values in my perl module using $r->dir_config I then pass the values to various objects (other perl modules). eventually I hope to have just one instance of the modules on the server with paths and db vars all being sent to the modules with PerlSetVar. There will be several sites all using the same modules but each will have its own paths and config for the DB. Will this work? Will I have problems with variables becoming "shared" ie vars values getting mixed up between connections? Is PerlSetVar the best way to pass values from httpd.conf to perl securely? Do I need to open/close the connection in each of the modules too or can I pass the $dbh object to each of my external subroutines, or is there an even better way. I'm hoping to have a persistent database connection for each request, but not get values mixed up between requests and sites. I thought I'd ask the experts here before I go do something really bloated. Make sense? Thanks Angie
