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: Matthew dot Persico at Lazard dot com
Subject: Timeouts
Date: Jan 3 2003 4:34PM

Is there a way, with DBD::Sybase, on a statement handle level, to either detect
a lock or set a timeout on a statement execution?

Our situation is that we have two competing processes that sometimes deadlock,
which we can detect and retry.

Other times, one process gets the lock and the other waits forever. We'd rather
detect the page/table  lock, and abort the statement.

If we cannot detect the page/table lock, we want to set a timeout on the
statement.

If we cannot do either, then we will need to write some external monitor. Yuk!

Thanks
-
Matthew Persico
Vice President
Lazard
30 Rockefeller Plaza
New York, NY 10020, USA
Phone Number: 212 632 8255
Fax Number: 212 332 5904
Email: matthew.persico@lazard.com