On Sat, 2004-10-02 at 00:05, Henri Asseily wrote:
> Hello,
> I have the following code using DBD::Sybase under apache 1.3/mod_perl
> 1.xx, where AutoCommit is off:
>
> $dbh->{RaiseError} = 1;
> eval {
> $sth = $dbh->prepare_cached('exec xx ?');
prepare_cached() won't buy you anything here, although it probably
doesn't hurt.
> I know that the DBI docs say that we technically can simply rollback a
> dbh without worrying about finishing a sth, but is that certainly the
> case for all DBDs?
Theoretically, yes.
> I seem to have a problem where if the statement
> execute fails due to for example a unique index duplicate, the apache
> process hangs with infinite loop AFTER it successfully fully processes
> the request and returns properly.
Have you tried to attach to the spinning process with a debugger to see
where it was looping?
It may be related to the same problem we were discussing yesterday (i.e.
infinite loop in syb_st_finish() when syb_flush_finish is enabled).
Michael
--
Michael Peppler Data Migrations, Inc.
[EMAIL PROTECTED] http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html
