[
https://issues.apache.org/jira/browse/OPENJPA-2742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Francesco Chicchiriccò resolved OPENJPA-2742.
---------------------------------------------
Resolution: Fixed
trunk: http://svn.apache.org/viewvc?rev=1834818&view=rev
2_4_X: http://svn.apache.org/viewvc?rev=1834819&view=rev
> 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: 2.4.4, 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)
