RE: DBI in a web context

I would definitely wrap the entire transaction in an eval {}. But, I'm
not sure if I would croak/die when a failure occurs vs. report the error
and go back.

rr

-----Original Message-----
From: Robert Hicks [mailto:sigzero@xxxxxxxxx]
Sent: Friday, November 10, 2006 1:40 PM
To: dbi-users@xxxxxxxx
Subject: DBI in a web context

I have a couple forms for an in-house application. The user fills out
the fields and then submits which update a back end Oracle database.

I have looked for examples but can't really find anything.

How is it best to catch errors when doing DBI stuff in web applications?

Wrap the insert "code" in an eval statement? Croak or die statements? I
am thinking eval because I can set autocommit to "off" and then do
rollbacks if $@ has an error.

Suggestions and comments welcome?

Robert

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

.

Relevant Pages

  • Res: RE: RE: Problems changing from 1.30 to 1.42
    ... With DBI 1.30 it works just it is: ... >>This electronic message transmission is a PRIVATE communication which contains ... >>intended recipient, please be aware that any disclosure, copying, distribution ... >>sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: RE: Problems changing from 1.30 to 1.42
    ... >This electronic message transmission is a PRIVATE communication which contains ... >intended recipient, please be aware that any disclosure, copying, distribution ... >sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: RE: DBI->Connect returning UNDEF in cgi but not in standalone prog
    ... You are returning undef. ... >This electronic message transmission is a PRIVATE communication which contains ... >intended recipient, please be aware that any disclosure, copying, distribution ... >sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: RE: Problems changing from 1.30 to 1.42
    ... >This electronic message transmission is a PRIVATE communication which contains ... >intended recipient, please be aware that any disclosure, copying, distribution ... >sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: make problem
    ... Perl may be copied only under the terms of either the Artistic License or the ... This electronic message transmission is a PRIVATE communication which contains information ... If you are not the intended recipient, please be aware that any disclosure, ... Please notify the sender ...
    (perl.dbi.users)