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: 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
-- 
Michael Peppler / mpeppler@peppler.org / http://www.mbay.net/~mpeppler
mpeppler@zetatools.com / ZetaTools, Inc / http://www.zetatools.com
ZetaTools: Call perl functions as Sybase stored procedures!