Re: Transactions errors with DBD-Sybase-1.05

"David Barnwell" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds,gmane.comp.lang.perl.modules.dbi.sybase
Message-ID <00a501c52fae$91537d30$bf2e4381@wellbarnwell>
Hi Michael,

Thanks for your mail.

> Why do you call finish() here?

I tried it without the $sth->finish. I now get a similar error with
DBD-Sybase-1.04, but this time the commit fails rather than the execute, and
the rollback is successful. To summarise:

with the $sth->finish statement:
  DBD-Sybase-1.04 OK
  DBD-Sybase-1.05 execute fails, rollback fails silently.

without the $sth->finish statement:
  DBD-Sybase-1.04 commit fails, rollback succeeds
  DBD-Sybase-1.05 execute fails, rollback fails silently

I also tested DBD-Sybase-1.04 with FreeTDS 0.62.1. The results are the same
as DBD-Sybase-1.04 with FreeTDS 0.63RC10.

I've added DBI->trace(5) and put the output from all these combinations at 
http://www.well.ox.ac.uk/~barnwell/tests_2005-03-23/

Thanks,
David Barnwell
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.