[
https://issues.apache.org/jira/browse/CALCITE-640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14378867#comment-14378867
]
Julian Hyde commented on CALCITE-640:
-------------------------------------
Can you add connect-string parameters (in enum BuiltInConnectionProperty) for
connectionTimeout and statementTimeout with sensible defaults. Make them
strings so that people can write "10s" or "10000ms" if they want, and they mean
the same as "10".
In their doc, specify their time unit and note the fact that they are for
inactivity (on the part of both the server and client). If a connection has a
timeout of 1h and creates or closes a statement every 59m it will never time
out.
> Avatica server should expire stale connections/statements
> ---------------------------------------------------------
>
> Key: CALCITE-640
> URL: https://issues.apache.org/jira/browse/CALCITE-640
> Project: Calcite
> Issue Type: Improvement
> Reporter: Nick Dimiduk
> Assignee: Julian Hyde
> Labels: avatica
> Fix For: next
>
> Attachments: 640.txt
>
>
> To avoid resource leaks in a long-running server process, we should be
> expiring our connections and statement handles after some configurable period.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)