Re: CGI::Session + DBD::SQLite = closing dbh with active statement handles

[bash]

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};
    }
}