db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Oyvind Bakksjo (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-505) Add system procedure to allow setting statement timeout
Date Fri, 12 Aug 2005 15:22:00 GMT
Add system procedure to allow setting statement timeout

         Key: DERBY-505
         URL: http://issues.apache.org/jira/browse/DERBY-505
     Project: Derby
        Type: New Feature
  Components: SQL  
    Reporter: Oyvind Bakksjo
 Assigned to: Oyvind Bakksjo 
    Priority: Minor

Propose to add a system procedure:


This procedure will enable the query timeout functionality not only through JDBC, but also
through SQL. I suggest the following semantics:

The timeout value (in seconds) set with this procedure will apply to all subsequent statements
executed on the current connection (the same connection on which the procedure was called),
until a different value is set with the same procedure. A value of 0 indicates no timeout.
Supplying a negative value will cause an exception. For each executed statement, the semantics
are the same as for using Statement.setQueryTimeout() through JDBC.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

View raw message