|
|
sybperl-l Archive
Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Transactions errors with DBD-Sybase-1.05
Date: Mar 22 2005 7:12PM
On Tue, 2005-03-22 at 20:04, David Barnwell wrote:
> Hi,
>
> I've hit some problems executing transactions and rollbacks with
> DBD-Sybase-1.05 and FreeTDS 0.63RC10. My client system runs Red Hat
> Enterprise Linux 3 and perl-5.8.0-88.4, and the server is SQL Server 2000.
>
> The code I use is based on the example in DBI.pm. The central part is:
>
> $dbh->{AutoCommit} = 0;
> $dbh->{RaiseError} = 1;
>
> eval {
> my $sth = $dbh->prepare($sql);
> $sth->execute;
> $sth->finish;
Why do you call finish() here?
> $dbh->commit;
> };
> if ($@) {
> eval { $dbh->rollback };
> }
>
> The SQL statement executes a stored procedure that updates a table. This
> works fine with DBD-Sybase-1.04 and FreeTDS 0.63RC10. The procedure is
> executed OK and the table is updated.
>
> However, the program fails with DBD-Sybase-1.05. The SQL is executed and
> the table is updated, but the transaction fails with the following error
> message:
>
> Attempt to initiate a new SQL Server operation with results pending
Please post (or send me) a trace with DBI->trace(5).
Michael
--
Michael Peppler - mpeppler@peppler.org - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
|
