On Thu, 2003-11-13 at 10:32, Christophe Musielak wrote:
> My question is : is it safe to use transactions of multiple objects,
> doing a commit or rollback at the end as i'm sure i will stay in the
> same interpreter space and that no other user can ask for the same
> database handle to do some stuff while i'm working?
Yes. Database handles are not shared between interpreters.
> btw, ApacheDBI is always returning me a handle with the default
> parameters i used when issuing the connection ( {AutoCommit => 1} for
> example), even if i changed the parameters with
> local->{dbh}->{AutoCommit} = 0.
Hmmm... Was I talking to you about this on Perlmonks?
It sounds like maybe you don't understand what local() does, which is
not surprising since hardly anyone does. Any change you make with
local() only lasts for the current scope. If you change things without
local(), it will change the cached handle permanently.
- Perrin
--
Reporting bugs: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
