Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-2882

Connection properties are lost after timeout

    Details

      Description

      When use avatica connect Phoenix QueryServer, I create an AvaticaConnection:

      Connection conntion = DriverManage.getConnection(url);
      connection.setAutoCommit(true);
      

      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

      3) after 10 min, upsert again, the connection will be recreate, but select null

      link title

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                shining shining
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 2h 50m
                  2h 50m