Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.4.3, 3.0.0
    • Fix Version/s: 2.4.4, 3.1.0
    • Component/s: jdbc
    • Labels:

      Description

      When running the SchemaTool for db initialization, an exception is reported:

      MySQLNonTransientConnectionException: Can't call rollback when autocommit=true
      

      No tables are created, and the OpenJPA initialization fails.

      The problem is originated in SchemaTool#executeSQL where a rollback is issued before any DDL statement is effectively run, and this causes troubles to MySQL.

      Prior to version 8, the MySQL JDBC Driver used to provide a property relaxAutocommit=true to append to the JDBC URL, which could be leveraged as workaround; now this option was removed.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                ilgrosso Francesco Chicchiriccò
                Reporter:
                ilgrosso Francesco Chicchiriccò
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: