[CALCITE-524] Connection timeout and keep-alive in remote JDBC driver

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: avatica
• Assignee: Unassigned
• Reporter: Julian Hyde
• Created: 10/Dec/14 23:19
• Updated: 27/Apr/22 03:34

Description

Implement a timeout policy, whereby a connection that is inactive for a given period is closed.

Also implement a way for the remote JDBC client to tell the server that the connection is still in use.

Test that executing an operation, say createStatement, on a connection that has been closed server-side gives a good error from JDBC client, and that the connection's state is then set to closed (per Connection.isClosed).

Also, document how keep-alive works in the documentation produced by CALCITE-517.

Issue Links

• is related to: CALCITE-5099 ResultSetEnumerable.enumeratorBasedOnStatement cause the backend connection leak