in reply to CGI::Session + DBD::SQLite = closing dbh with active statement handles
New solution will be this:
We need to add new method to sqlite.pm from CGI::Session package. In this case we will be still able to cache prepared statement which is good for performance.
sub DESTROY { my $self = shift; unless ( $self->{Handle}->{AutoCommit} ) { $self->{Handle}->commit; } if ( $self->{_disconnect} ) { undef $self->{Handle}; } }
|
---|
In Section
Seekers of Perl Wisdom