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: "Avis, Ed" <avised at kbcfp dot com>
Subject: Feature request: turn off the multiple statement handle emulation
Date: Mar 22 2006 3:33PM

If AutoCommit is off and you try to open two statement handles at the
same time then DBD::Sybase silently opens a new database connection.
This is documented, but I think it's a trap for the unwary, since just
forgetting to put 'finish $sth' earlier in your program will trigger it
and there is no warning.

I think there should be a safe mode where DBD::Sybase will never open a
new database connection unless you explicitly ask for it.  I would even
suggest that this mode should be the default, but it may be too late to
change that.

Ed Avis 

-----This message may contain confidential, proprietary, or legally privileged information.  No confidentiality or privilege is waived by any transmission to an unintended recipient.  If you are not an intended recipient, please notify the sender and delete this message immediately.  Any views expressed in this message are those of the sender, not those of KBC Financial Products or any affiliate thereof. 
This message does not create any obligation, contractual or otherwise, on the part of any such entity.  It is not an offer (or solicitation of an offer) of, or a recommendation to buy or sell, any financial product.  Any prices or other values included in this message are indicative only, and do not necessarily represent current market prices, the prices at which any KBC entity would enter into a transaction or the prices at which similar transactions may be carried on that entity's own books.   The information contained in this message is provided "as is", without representations or warranties, express or implied, of any kind.  Past performance is not indicative of future returns.