[jira] [Work started] (OPENJPA-2742) SchemaTool fails with MySQL

["Francesco Chicchiriccò (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OPENJPA-2742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on OPENJPA-2742 started by Francesco Chicchiriccò.
-------------------------------------------------------
> SchemaTool fails with MySQL
> ---------------------------
>
>                 Key: OPENJPA-2742
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2742
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc
>    Affects Versions: 2.4.3, 3.0.0
>            Reporter: Francesco Chicchiriccò
>            Assignee: Francesco Chicchiriccò
>            Priority: Major
>              Labels: mysql
>             Fix For: 3.0.1
>
>
> When running the SchemaTool for db initialization, an exception is reported:
> {code:java}
> MySQLNonTransientConnectionException: Can't call rollback when autocommit=true
> {code}
> 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|https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-properties-changed.html].



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)