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

Reply via email to