Wait_for_Lock (Additional Parameter)

Previous Next

See Also

This is where you specify the behavior of your application when lock statements are sent to the database. Allowed values are : Default (the default), Wait and Don't Wait. If you specify Wait, every locking attempt will wait until it obtains the lock (or is timed out by the database). If you specify Don't Wait, every locking attempt will return immediately when it fails.

If you accept Default, the Rules Engine will use runtime internal algorithms to decide when to wait for a lock and when to return control to the user. For instance, if the Rules Engine detects that locks are required on a number of foreign keys in different tables, or on a constellation of subtype tables, it will return control to the user on lock failure.

By choosing Wait or Don't Wait, you enforce uniform lock behavior for all transactions and across the entire application.