Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: DBD-Sybase ApacheDBI and error recovery
Date: Jun 14 2002 3:26PM

On Thu, 2002-06-13 at 07:55, Kiriakos Georgiou wrote:
> BlankThose who use DBI, ApacheDBI (which gives you one persistent dbh per
> httpd) and DBD-Sybase for their website have probably noticed that if one of
> their SQL statements gives an error then subsequent requests to the same
> httpd process may have problems if they do anything with the database
> (depending on the nature of the error, for example you can expect problems
> if there are results pending from a query that didn't finish).

Hmmm.... that may very well be a bug in DBD::Sybase.

Would you have an example that illustrates the problem?

This is probably not limited to ApacheDBI - a normal script that reuses
a dbh after an error should be exposed to the same problem, btw.

Michael Peppler / / / ZetaTools, Inc /
ZetaTools: Call perl functions as Sybase stored procedures!