[ https://issues.apache.org/jira/browse/CALCITE-2882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16782300#comment-16782300 ]
shining commented on CALCITE-2882: ---------------------------------- when reopen the connecion, ConnectionProperties In the Meta already set dirty false, therefore the parameters such as autocommit cannot be synchronized to PhoenixConnection. > ConnectionProperties lose effectiveness when connection reopen after expired > ---------------------------------------------------------------------------- > > Key: CALCITE-2882 > URL: https://issues.apache.org/jira/browse/CALCITE-2882 > Project: Calcite > Issue Type: Bug > Components: avatica > Affects Versions: 1.12.0 > Environment: Phoenix 5.1 > avatca 1.12 > Reporter: shining > Priority: Major > Attachments: image-2019-02-28-17-25-39-478.png, > image-2019-02-28-17-28-31-926.png > > > When use avatica connect Phoenix QueryServer, I create an AvaticaConnection: > {code:java} > Connection conntion = DriverManage.getConnection(url); > connection.setAutoCommit(true); > {code} > Avatica keep PhoenixConnection alive in the Cache, which will be expired > after 10min by default. > I still use the older AvaticaConnection , it will reopen an > PhoenixConnection, but the ConnectionProperties is loss, such as AutoCommit. > I use sqlline-thin.py to reappear the problem: > 1) sqlline-thin.py http://localhost:8765 > 2) upsert one row and select > !image-2019-02-28-17-25-39-478.png! > 3) after 10 min, upsert again, the connection will be recreate, but select > null > !image-2019-02-28-17-28-31-926.png! -- This message was sent by Atlassian JIRA (v7.6.3#76005)