PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: AutoCommitt and DBD::Sybase
Date: Jun 11 1999 9:59PM

John Gilmore-Baldwin writes:
 > I'm using DBD-Sybase-0.17 and it seems to be working fine.  However, the
 > server prints out this error message with every query:
 > 
 > commit ineffective with AutoCommit at
 > /usr/local/lib/perl5/site_perl/5.005/RPC/PlServer.pm line 329.
 > 
 > Here's my test script:
 > 
 > #!/usr/local/bin/perl
 > 
 > use DBI;
 > 
 > my $dbh =
 > DBI->connect("dbi:Proxy:hostname=197.133.247.18;port=7100;dsn=dbi:Syba
 > se:server=NEWS_SERVER", "user", "password");
 > 
 > my $sth = $dbh->prepare(q{select id,name from news..story where name like
 > '11t%'
 > }) || die "Can't execute statement: $DBI::errstr";
 > 
 > my $rc = $sth->execute || die "Can't execute statement: $DBI::errstr";
 > 
 > while (($id, $name) = $sth->fetchrow_array)
 > {
 >     print "$id: $name\n";
 > }
 > 
 > die $sth->errstr if $sth->err;
 > 
 > $dbh->disconnect;
 > 

I suspect a bug with DBD::Proxy which sends a $dbh->commit although it 
hasn't set AutoCommit to 0.

You can safely ignore the warning, I think.

Michael
-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@peppler.org    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com