When use avatica connect Phoenix QueryServer, I create an AvaticaConnection:
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