sybperl-l Archive

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.