Apache::DBI and AutoCommit

antitrust has asked for the wisdom of the Perl Monks concerning the following question:

AutoCommit flag resets on my database handle, every time I call "connect_cached". Is this a known "feature" or am I missing something?

The problem is that I "begin_work" a transaction and do some queries. If now I call "connect_cached", it returns me the same handle (at least dbh with the same mysql_thread_id), but AutoCommit flag on that handle is set to 1! How is that possible?

Comment on Apache::DBI and AutoCommit

Replies are listed 'Best First'.
Re: Apache::DBI and AutoCommit by rdfield (Priest) on Feb 20, 2006 at 14:32 UTC
Apache::DBI is transparent in use (it says so in the docs), thus just calling "connect" is fine. The DBI docs say "the behaviour of this method differs in several respects from the behaviour of persistent connections implemented by Apache::DBI" about connect_cached. So I guess using Apache::DBI and then calling connect_cached could be the causing some conflicts. rdfield	[reply]

Back to Seekers of Perl Wisdom