Up Prev Next
From: Matthew E Studley <matthew at coms dot com>
Subject: apache + locking
Date: Oct 3 2000 12:34PM
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.
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
Technical Architect coms.com
126-128 New Kings Rd
+44 (0) 7080 810 101 London SW6 3LZ.