Re: Same $dbh under different pids?

[Richard Clarke]

harm wrote:

Moi,

a quick question: is it possible to have the 'same' dbh across the apache
children even if you do your best not to?

This minimalistic handler:
use strict;
package Foo;
use Apache::DBI;
use DBI;
use Apache::Constants qw':common';

my $dbh;

You haven't initialised this, so each request will get the same object that is made below.

$Apache::DBI::DEBUG = 1;

This should be in a start up file really.

sub handler {
  my $r = shift;
  $r->send_http_header;
  $r->print("ok");

You could just put,
   print "ok";

  $dbh ||= DBI->connect("dbi:mysql: ... etc);

Apache::DBI takes care of pooling connections.
Use,

   my $dbh = DBI->connect(@CONNECT);

and get rid of the global $dbh above.

Richard