DBI HandleError callback not being called

crazyinsomniac has asked for the wisdom of the Perl Monks concerning the following question:

Hi. Why isn't my HandleError callback being called?
( and yes, I know i could local $SIG{__WARN__}, but that's what HandleError is for)

use strict;
use DBI;

##$SIG{__WARN__} = sub { die "warning why\n\n".shift(@_) };

{
    my $db_user      = 'null'; #read only
    my $db_pass      = 'nullnull';
    my $db_name      = 'null'; # the name of the db
    my $db_host      = 'localhost';
    my $db_driver    = 'mysql';
    my $db_serverstr = "DBI:$db_driver:$db_name";

    my $db_h = DBI->connect(
                "$db_serverstr",
                "$db_user",
                "$db_pass",
                { HandleError => sub { die "WHYYYY\n".shift(@_) }},
            );
}

__END__
DBI is 1.201
This is perl, v5.6.1 built for MSWin32-x86-multi-thread
[download]

p.s. i did do a mighty google but to no avail ;(

______crazyinsomniac_____________________________
Of all the things I've lost, I miss my mind the most.
perl -e "$q=$_;map({chr unpack qq;H*;,$_}split(q;;,q*H*));print;$q/$q;"

Comment on DBI HandleError callback not being called Download Code

Replies are listed 'Best First'.
(jeffa) Re: DBI HandleError callback not being called by jeffa (Bishop) on Jun 02, 2002 at 15:11 UTC
i don't _think_ you can do that. The problem is that you need a handle before you can access the 'HandleError' attribute. You can't even set $DBI::errstr or $DBI::err. There _might_ be a way of tricking Perl into 'reblessing' an object, but i think you will have to settle for something along the lines of: `{ my $db_h = DBI->connect( $db_serverstr, $db_user, $db_pass, {HandleError => sub {die "WHYYYY\n".shift(@_)} } ) or die "WHYYYY\n" . $DBI::errstr; my $sth = $db_h->selectall_arrayref(' grab me stuff from that table '); }` [download] 'HandleError' will be used for all subsequent errors. UPDATE 'RaiseError' will not magically make this work - i thought that it would at first, as well that you need to turn 'PrintError' off, which you don't. jeffa L-LL-L--L-LL-L--L-LL-L-- -R--R-RR-R--R-RR-R--R-RR B--B--B--B--B--B--B--B-- H---H---H---H---H---H--- (the triplet paradiddle with high-hat)	[reply] [d/l]
Re: DBI HandleError callback not being called by Aristotle (Chancellor) on Jun 02, 2002 at 15:12 UTC
Maybe you need `RaiseError => 1`? Update: Doh, jeffa++ beat me to it, and his point makes more sense too. `____________` Makeshifts last the longest.	[reply] [d/l]