[ 
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)

Reply via email to