There doesn't seem to be any support for 'FOR UPDATE':
SELECT * FROM test_data WHERE test_id = 1 FOR UPDATE
At the bare minimum, there should be an SQL way to lock an entire table.
At this moment we do not provide this feature to lock the entire table in SQL and currently do not have plans on implementing this feature in our upcoming version. Maybe later.
There a programmatic way, though, to lock the records (still not table) in PHP and CCI APIs. See http://www.php.net/manual/en/function.cubrid-lock-read.php.
Also in SQL you can control the level of consistency and concurrency specific to a service by setting appropriate transaction isolation level. See http://www.cubrid.org/manual/syntax/syntax_tran_isolation_repeatcom.htm. But this will lock all SELECT statements, too, not the user specified ones.
I will keep this issue open, so that once we set plans for it in one of our Milestones, I will inform here.
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.