add option to specify timeout in WAIT clause of SET TRANSACTION, add LOCK_TIMEOUT in firebird.conf --------------------------------------------------------------------------------------------------
Key: CORE-3444 URL: http://tracker.firebirdsql.org/browse/CORE-3444 Project: Firebird Core Issue Type: Improvement Reporter: Pavel Zotov I think that the following syntax would be useful in some cases: SET TRANSACTION READ WRITE READ COMMITTED WAIT 10 (10 = timeout in seconds) Currently timeout can be specified only via isc_tpb_lock_timeout. Also, it will be convenient to have such parameter in firebird.conf like it was in Yaffil: LOCK_TIMEOUT -1 // default = infinite waiting -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel