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?

In reply to Perl, Windows and persistent database connections by frn

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.