Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

Re: DB Error Handling Not Working

by poj (Monsignor)
on Aug 13, 2014 at 09:20 UTC ( #1097236=note: print w/replies, xml ) Need Help??

in reply to DB Error Handling Not Working

Try with RaiseError and/or PrintError set.
my $dbh = DBI->connect("dbi:ODBC:$DSN",{RaiseError => 1, PrintError => + 1});

Replies are listed 'Best First'.
Re^2: DB Error Handling Not Working
by sowais (Sexton) on Aug 13, 2014 at 17:47 UTC

    Tried that but didn't work either. Trace showed that the error occurred but was again cleared by the 'disconnect' call.

      Sorry, the connection string should be DBI->connect($data_source, $username, $password, \%attr) so either use
      my $dbh = DBI->connect("DBI:ODBC:$DSN",'','', {RaiseError => 1, PrintError => 1}) or die (Error connecting " $DBI::errstr");
      or move the username/password out of the $DSN.

      Update : To get current date/time you could just use
      my ($now) = $dbh->selectrow_array('SELECT CURRENT_TIMESTAMP');


      If the error is cleared by the disconnect call, then pull the disconnect out of the block and put it after the end of the eval block. If you feel you need similar error checking for the disconnect, wrap that in its own eval block.


      When your only tool is a hammer, all problems look like your thumb.

        sorry, didn't realize i was logged out for the earlier post.. Tried that but eval didn't capture it. Against my better judgement I put in a 'die' statement next to the execute statement and that seems to work! I would prefer not to have an error handler within an error handler but unfortunately I've burned way too much time troubleshooting 'eval's failrue to capture the error.
        eval { $dbh = DBI->connect("dbi:ODBC:$DSN"); ... $sth->execute() or die "Execute Failed: $!"; $dbh->disconnect(); }; if($@) { print "DB Failure: $@"; }

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1097236]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (3)
As of 2018-03-25 04:00 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (300 votes). Check out past polls.