perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Perrin Harkins <per...@elem.com>
Subject Re: DBD:Pg (Postgres) + Apache::DBI
Date Mon, 20 Mar 2006 20:50:42 GMT
On Mon, 2006-03-20 at 15:22 -0500, Jonathan Vanasco wrote:
> I did a bunch of tracing this morning it seems that apache::dbi isn't  
> always issuing the rollback at cleanup

It only does that if you connect with AutoCommit off.

> if there's an invalid sql command executed in my transaction though,
> ==============CLEANUP
> 
> is all i get.  no cleanup is issued (rollback/closure/etc) on the  
> dbi, and i'm still using a bad cached handle on subsequent page  
> views , necessitating a page start.

Can you give an example of an invalid SQL command, and what was "bad"
about the cached handle on the next page?

Also, set $Apache::DBI::DEBUG = 2 and it will tell you if it ran a
cleanup or not.

- Perrin


Mime
View raw message