March 13th, 2012, 12:44 AM
Table locking on mySQL
Converting Access to mySQL under ColdFusion 9 and all going fine. The cfc's all use CF's TRANSACTION to get rollback recovery and that works very well. I'd like to be able to lock specific tables but CF doesn't (to my knowledge) provide such a feature and isolation level seems to relate to persistent data between CFC's. If I use mySQL's LOCK TABLE statement and it can't get a lock, it waits the default timeout time (50 sec's) and then fails with:
Error opening URL "http://mydevel:8500/flashservices/gateway/"
and I can't easily trap that. I don't believe it's a mySQL problem, so is it Flash? CF? Remoting?