Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1559

Allow specifying auto-commit mode in the connection URL or connection properties

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.3.0, 3.3.0
    • None
    • None

    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.

      Attachments

        1. PHOENIX-1559-part2.patch
          7 kB
          Gabriel Reid
        2. PHOENIX-1559.patch
          6 kB
          Gabriel Reid

        Activity

          People

            gabriel.reid Gabriel Reid
            gabriel.reid Gabriel Reid
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: