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: "Kiriakos Georgiou" <kirig at library dot nrl dot navy dot mil>
Subject: DBD-Sybase ApacheDBI and error recovery
Date: Jun 13 2002 2:55PM

Received: from taku.cren.net (taku.cren.net [128.8.10.25]) by
	troll.peppler.org (8.11.6/8.11.6) with ESMTP id g5DEudF04494 for
	; Thu, 13 Jun 2002 07:56:40 -0700
Received: from localhost (localhost [127.0.0.1]) by taku.cren.net
	(Pro-8.9.3/Pro-8.9.3) with SMTP id KAA03114; Thu, 13 Jun 2002 10:53:55
	-0400 (EDT)
Received: from infoweb.nrl.navy.mil (infoweb.nrl.navy.mil
	[132.250.186.172]) by taku.cren.net (Pro-8.9.3/Pro-8.9.3) with ESMTP id
	KAA03108 for ; Thu, 13 Jun 2002 10:53:52 -0400
	(EDT)
Received: from library.nrl.navy.mil (library.nrl.navy.mil [132.250.186.14])
	by infoweb.nrl.navy.mil (8.8.8+Sun/8.8.8) with ESMTP id KAA27498 for
	; Thu, 13 Jun 2002 10:53:15 -0400 (EDT)
Received: from LIBRARY/SpoolDir by library.nrl.navy.mil (Mercury 1.48); 13
	Jun 02 10:48:55 -0500
Received: from SpoolDir by LIBRARY (Mercury 1.48); 13 Jun 02 10:48:33 -0500
Received: from 5220techlead1 (132.250.186.64) by library.nrl.navy.mil
	(Mercury 1.48); 13 Jun 02 10:48:31 -0500
From: "Kiriakos Georgiou" 
To: SybPerl Discussion List 
Subject: DBD-Sybase ApacheDBI and error recovery
Date: Thu, 13 Jun 2002 10:55:04 -0400
Message-ID: 
MIME-Version: 1.0
Content-Type: multipart/related; boundary="----=_NextPart_000_0153_01C212C8.C6152970"
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0)
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Importance: Normal
Reply-To: SYBPERL-L@list.cren.net
Sender: owner-SYBPERL-L@list.cren.net
X-Listprocessor-Version: 8.2.09/990901/11:28 -- ListProc(tm) by CREN
X-Filter: mailagent [version 3.0 PL73] for mpeppler@peppler.org
X-Evolution-Source: mbox:/var/spool/mail/mpeppler

This is a multi-part message in MIME format.

------=_NextPart_000_0153_01C212C8.C6152970
Content-Type: multipart/alternative; boundary="----=_NextPart_001_0154_01C212C8.C6152970"

------=_NextPart_001_0154_01C212C8.C6152970
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

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).

I may be missing something obvious here - in essence after an sql error it
would be good to reset $dbh for that httpd.  Is there a simple and elegant
way of doing this (could do it in the error detection code of each SQL
statement but that wouldn't be simple or elegant would it? :-)

regards,
--
Kiriakos Georgiou
(202) 404-2702 (icom 76)




------=_NextPart_001_0154_01C212C8.C6152970
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit


Blank





Those 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).
 
I may be missing something obvious here - in essence after an sql error it would be good to reset $dbh for that httpd.  Is there a simple and elegant way of doing this (could do it in the error detection code of each SQL statement but that wouldn't be simple or elegant would it? :-)
 
regards,

--
Kiriakos Georgiou
(202) 404-2702
(icom 76)

 

------=_NextPart_001_0154_01C212C8.C6152970-- ------=_NextPart_000_0153_01C212C8.C6152970 Content-Type: image/gif; name="Blank Bkgrd.gif" Content-Transfer-Encoding: base64 Content-ID: <538003614@13062002-1c33> R0lGODlhLQAtAID/AP////f39ywAAAAALQAtAEACcAxup8vtvxKQsFon6d02 898pGkgiYoCm6sq27iqWcmzOsmeXeA7uPJd5CYdD2g9oPF58ygqz+XhCG9Jp JGmlYrPXGlfr/Yo/VW45e7amp2tou/lWxo/zX513z+Vt+1n/tiX2pxP4NUhy 2FM4xtjIUQAAOw== ------=_NextPart_000_0153_01C212C8.C6152970--