Hill, Ronald wrote:
It's much simpler than that. You need two sentences:I agree that database persistence is an important topic and should be-----Original Message----- Grant McLean wrote:Nathan Torkington wrote:Current recipe list:Database persistence is an important topic but it's hard to say whether one directive ...
[gnat:~] grep head1 Ora/pcb2/ch21.pod =head1 Introduction
=head1 Authenticating in mod_perl
=head1 Setting Cookies in mod_perl
=head1 Accessing Cookie Values from mod_perl
=head1 Redirecting the Browser from mod_perl
=head1 Interrogating Headers in mod_perl Handlers
=head1 Accessing Form Parameters from mod_perl
=head1 Receiving Uploaded Files in mod_perl
PerlModule Apache::DBI
... constitutes a 'recipe'
included
in the perl Cookbook. However, Apache::DBI is not always the answer.
Example:
I currently have a need to use database persistence for an Ingres Database.
So I
installed the DBD::Ingres Module and attempted to use Apache::DBI. Needless
to asy
it did not work :-( After much searching/posting I got my answer.
Henrik Tougaard wrote: (from comp.databases.ingres)
I wouldn't bet on Apache::DBi working with DBD::Ingres!
Reason: cached statementhandles are not implemented (currently) in
DBD::Ingres and Apache::DBI uses them. (It's on my todo list, but not
scheduled right now - i seem to have run out of tuits).
I assume that the only way of getting permanent connections is to have
another process hold them for you - but the hassle of accessing the
connections would be so great, that it might be just as easy to avoid CGI
entirely and go straight for mod_perl.
OK, so now what? This type of situation could be discussed then talk about the Apache::DBI module.
1) under mod_perl, globals remember their values from the previous request, so you can cache the connection with:
$dbh ||= myconnect();
2) If you rdbms supports cached statement handles (which most do), you can use Apache::DBI which caches database connection without needing to change any of your code.
But of course I agree that it's a good idea to mention this topic. I suggest that many other topics are to be mentioned but replace discussions with pointers to the relevant chapters of the mod_perl books and online documentation. So newbies, know what to look for. It's not obvious that database connections can be cached.
__________________________________________________________________
Stas Bekman JAm_pH ------> Just Another mod_perl Hacker
http://stason.org/ mod_perl Guide ---> http://perl.apache.org
mailto:[EMAIL PROTECTED] http://use.perl.org http://apacheweek.com
http://modperlbook.org http://apache.org http://ticketmaster.com