Problems with Error Handling

[Don Mies]

I'm running the Perl DBI module with MySQL under cygwin on a Windows XP
system
and I'm having trouble using the DBI error handling/trapping procedures.

I'm running perl v5.8.7 built for cygwin-thread-multi-64int; DBI v1.50;
MySQL
5.0.18-nt.

Here is a snippet of what my program looks like:

     1 $dbHandle->{AutoCommit} = 0;
     2 $dbHandle->{PrintError} = 0;
     3 $dbHandle->{RaiseError} = 1;
     4
     5 ... Code to prepare the SQL statements is here
     6
     7 eval
     8 {
     9     while ( <INPUT> )
    10     {
    11         $stmtHandle->execute ( ... );
    12     }
    13     $dbHandle->commit();
    14 };
    15
    16 if ( $@ )
    17 {
    18     warn $@;
    19     $dbHandle->rollback();
    20 }

I've put together a test that tries to insert duplicate keys to test the
error handling logic and it does not work as I expected.  I've read all
the manual pages and FAQs I can get hold of and the all say this should
work but I have two questions/problems with the above:

1)  According to the manuals, enabling "RaiseError" should cause the
"eval" to
   fail the first time it gets an error.  In my program, it will print the
   error message and continue the inner loop until the input is exhausted.
   If I put a "|| die ..." on the "execute" statement, it fails the "eval"
   on the first error.

2)  Disabling the "PrintError" message is supposed to prevent the error
   message from being printed inside the inner loop but it does not.  Even
   if I add the "|| die ..." clause, it still prints the error message.

If I run the program as coded above with 3 lines of input, I get:

   DBD::mysql::st execute failed: Duplicate entry '...' for key 1 at ...
   DBD::mysql::st execute failed: Duplicate entry '...' for key 1 at ...
   DBD::mysql::st execute failed: Duplicate entry '...' for key 1 at ...

and the commit at line 13 is executed.

If I run the above with the "|| die ..." on line 11, I get:

   DBD::mysql::st execute failed: Duplicate entry '...' for key 1 at ...
   Duplicate entry '...' for key 1 at ...

where the first line is printed inside the loop and the second line is
printed
by line 18 above.

All I want to do is suppress the error messages and handle the errors myself
at the end of the "eval" block.  What am I doing wrong?

TIA


Don