> -----Original Message-----
> From: Perrin Harkins [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 16, 2000 10:32 PM
> To: William Deegan
> Cc: [EMAIL PROTECTED]
> Subject: Re: Apache::DBI and autocommit
>
>
> On Tue, 16 May 2000, William Deegan wrote:
> > If autocommit is not set and a script exits the transaction will be
> > rolled back.
> >
> > The question I have is when the database handle is re-used will the
> > autocommit still be unset if the script that set it errors out?
>
> Yes, Apache::DBI doesn't touch your autocommit settings.
true, but Apache::DBI caches connections per connect string, so a database
handle called with AutoCommit=0 in one script and AutoCommit=1 in another
will result in two cached handles.
William - are you creating a $dbh and setting AutoCommit in a seperate
step/script? If so, I'm not sure that the new AutoCommit attribute will be
a part of the cached database handle, regardless of the exit status of the
script.
Can anyone confirm this?
--Geoff
>
> - Perrin
>
