Re: Error-handling Question
From: Rudy Lippan (rlippan_at_remotelinux.com)
Date: 12/16/03
- Next message: Marcus Willemsen: "RE: Selects to MS SQL Server 2000"
- Previous message: Kevin Moore: "Re: Apache, Oracle, Perl DBI Problems"
- In reply to: Hardy Merrill: "Re: Error-handling Question"
- Next in thread: Michael A Chase: "Re: Error-handling Question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Mon, 15 Dec 2003 20:32:13 -0500 (EST) To: Hardy Merrill <hmerrill@redhat.com>
On Mon, 15 Dec 2003, Hardy Merrill wrote:
> Paul, you normally don't care about committing or rolling
> back unless you're actually updating the database by doing
> either an INSERT or an UPDATE. When you're just doing
> SELECT and fetches you really don't care about transaction
> processing. If you want to use eval and $@ to trap errors
> with fetches that's fine, but no need to have the rollback
> in the if ($@).
Agreed, but if you have autocommit turned off you should still
commit/rollback or somehow end the transaction at some point. Think about
a long running process that has autocommit turned off & only does selects
but has a transction isolation level of repeatable read or serializable
insead of read commited.
Rudy
- Next message: Marcus Willemsen: "RE: Selects to MS SQL Server 2000"
- Previous message: Kevin Moore: "Re: Apache, Oracle, Perl DBI Problems"
- In reply to: Hardy Merrill: "Re: Error-handling Question"
- Next in thread: Michael A Chase: "Re: Error-handling Question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
