March 12th, 2012, 11:44 PM
|
|
Contributing User
|
|
Join Date: Oct 2009
Posts: 59
Time spent in forums: 11 h 27 m 24 sec
Reputation Power: 4
|
|
|
Flash Remoting - 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?
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
