sybperl-l Archive

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








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