[ http://issues.apache.org/jira/browse/DERBY-505?page=comments#action_12318727 ]
Satheesh Bandaram commented on DERBY-505: ----------------------------------------- I would like to hear reasoning behind this new feature request. I see following issues with the suggestion: 1) System procedures and functions are used for admin and diagnostic purposes typically. Since there is no standard for these, every database vendor has their own way to perform admin and diagnostics. However, this proposal seems to define application behavior based on system procedure. 2) I would like to know why JDBC's setQueryTimeout mechanism is not sufficient... Not sure what the bug comment means by "query timeout functionality not only through JDBC, but also through SQL". Derby supports SQL only using JDBC currently. If the comment is refering to IJ, that is also a JDBC application and could be programmed to support query timeout using JDBC. > 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 > Versions: 10.1.1.0 > Reporter: Oyvind Bakksjo > Assignee: Oyvind Bakksjo > Priority: Minor > > Propose to add a system procedure: > SYSCS_UTIL.SYSCS_SET_STATEMENT_TIMEOUT(INT) > 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: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
