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 E Studley <matthew at coms dot com>
Subject: apache + locking
Date: Oct 3 2000 12:34PM

Hi all

thanks for the responses to my last q. re. locking in transact-sql. 
We've got a bigger problem now...

Using Apache with Apache::Session, Mason, and DBD::Sybase to implement
www and integrate db.  

autocommit = 0

Apache seems to be getting exclusive lock that is not released.  E.g.

"begin tran
update table1 ....
error checking ok? commit tran
else rollback tran"

Appears to execute but we can't access this data using isql unless we
kill Apache and restart.  Obviously (?) a locking problem... any helpful
pointers greatly appreciated since I am now losing what little hair I
had when I started this job.

thanks in advance

matt

Matthew Studley
_____________________________________________________
Technical Architect		coms.com 
				126-128 New Kings Rd
+44 (0) 7080 810 101		London  SW6 3LZ.