Hi,

I have a need for persistent DBI database connections using windows, perl and webserver.

I'm currently using: Windows 2003 server (i know, i know), Apache 2.2. Oracle with Apache::DBI, ActivePerl 5.10,mod_perl2(ppm)

I've also tried PerlEx but didn't get it to work - also PerlEx seems mostly abandoned and undocumented. Didn't find anything helpful on Google either.

The Apache/activestate/mod_perl2 trinity seems very flaky. A mess on weird warnings, random behaviour etc etc (surely mostly my own fault but still..). While i do have persistent DBI connection currently, i'd like to know if there are better options. Especially those that dont require to mod_perl-ize my existing plain CGI scripts. The components that i can't swap out are the Win2003 server and Oracle.

So what are my options? Which combinations are known to work well? What are you using and why?