Re: DBI sudden exit on MySQL insert

my $dbh = DBI->connect($data_source, $username, $password, { RaiseErro
+r => 1 });
[download]

maybe you just forgot the RaiseError attribute?

Comment on Re: DBI sudden exit on MySQL insert Download Code

Replies are listed 'Best First'.
Re^2: DBI sudden exit on MySQL insert by cormanaz (Deacon) on Apr 19, 2007 at 15:21 UTC
I indeed did not have that set, so I will give it a try. I'm not sure that explains the bad behavior though. The DBI docs say it will "force errors to raise exceptions rather than simply return error codes in the normal way." I'm not getting error codes or anything--just an unexplained halt. Docs also say "Typically RaiseError is used in conjunction with eval { ... } to catch the exception that's been thrown and followed by an if ($@) { ... } block to handle the caught exception" and I'm not trying to trap errors in an eval.	[reply]

Replies are listed 'Best First'.

Re^2: DBI sudden exit on MySQL insert
by cormanaz (Deacon) on Apr 19, 2007 at 15:21 UTC

I'm not sure that explains the bad behavior though. The DBI docs say it will "force errors to raise exceptions rather than simply return error codes in the normal way." I'm not getting error codes or anything--just an unexplained halt.

Docs also say "Typically RaiseError is used in conjunction with eval { ... } to catch the exception that's been thrown and followed by an if ($@) { ... } block to handle the caught exception" and I'm not trying to trap errors in an eval.

[reply]