Mailing-List: contact modperl-help@perl.apache.org; run by ezmlm
Precedence: bulk
From: "David Hofmann" <mor4321@hotmail.com>
To: modperl@perl.apache.org
Bcc: 
Subject: Apache::Session::Postgres Commit on ??
Date: Wed, 14 Apr 2004 16:30:53 -0400
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <Law10-F92ItKxlmjEPh0004a4aa@hotmail.com>

For some reason I keep getting a commit error.

commit ineffective with AutoCommit enabled at 
/usr/lib/perl5/site_perl/5.6.1/Apache/Session/Store/Postgres.pm line 92.

Here how I'm tieing, I have tried upper and lowercase on the commit:

unless ( eval { tie %sessionHash, 'Apache::Session::Postgres', $sid, {  
Commit => 0, Handle => $self->{'sql'}}; }) {
#  warn "  (MY::DBSession::_initialize) Invalid session cookie: $@";
  tie %sessionHash, 'Apache::Session::Postgres', undef, { Commit => 0, 
Handle => $self->{'sql'} };
  $sid = $sessionHash{_session_id};
}

Here my database call:

unless ($self->{'sql'}) {
  # add our all important database connection!
  $self->{'sql'} = DBI->connect( "dbi:Pg:dbname=sup","usename", "password")
     or &error('0','EN','CONNECT_SQL','CONNECT_SQL');
}

Any ideas ? It's not causing a problem but I hate errors in my log.

David

_________________________________________________________________
Check out MSN PC Safety & Security to help ensure your PC is protected and 
safe. http://specials.msn.com/msn/security.asp


-- 
Report problems: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/modperl.html
List etiquette: http://perl.apache.org/maillist/email-etiquette.html