By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,905 Members | 1,646 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,905 IT Pros & Developers. It's quick & easy.

row-level locking with Pear Database & MySQL

P: n/a
OK, anyone have some advice on implementing the likes of SELECT ... FOR
UPDATE / SELECT ... LOCK IN SHARE MODE?

I'm trying to get it working in conjunction with the transaction
facilities built into Pear DB.

Obvious answer to obvious question: yes, I'm using InnoDB-formatted
tables within MySQL.

So far, all of the stuff I've put in place certainly isn't stopping me
from INSERTing, UPDAT[E]ing, but it doesn't seem to be locking the rows
down.

I've created a transaction class with all of the nice autoExecute() and
executeMultiple() methods to make things ultra easy. Which,
incidentally, are all working fine.

So, for example: I open up record ID: 15 in browser A and the same
record in another browser B.

I can then make changes in browser B before COMMIT[t]ing my changes in
browser A.

Obviously, this isn't supposed to happen.

Any help would be great...
--
wayne smallman ][ octane interactive

Jul 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.