Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-1347

setSavepoint() silently succeeds in auto-commit mode instead of throwing SQLException

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 4.0.0
    • Other
    • None

    Description

      setSavepoint() / setSavepoint(String) send SAVEPOINT without checking auto-commit. In auto-commit the statement succeeds, but SAVEPOINT starts no transaction, so the next statement's implicit commit discards it. The application thinks it holds a rollback point, the data is committed anyway, and the failure only surfaces later at the rollback.

      The java.sql.Connection javadoc documents clearly state to throw an SQLException when the connection "is currently in auto-commit mode".

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            diego dupin Diego Dupin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.