Description
As reported in PHOENIX-1543, the JDBC spec states that auto-commit should be enabled on all newly-created connections, but Phoenix currently disables auto-commit by default.
Some "enterprise" JDBC tools assume that auto-commit is enabled on all new connections, and don't work correctly unless it is.
It would be useful if it was possible to explicitly turn on auto-commit by supplying a setting in the connection URL or connection properties. This would not only make it possible to work with tooling that assumes that all JDBC drivers follow this spec, but it would also provide a kind of backwards-compatibility mode once PHOENIX-1543 is implemented.