You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Francesco Chicchiriccò (JIRA)" <ji...@apache.org> on 2018/06/29 05:37:00 UTC
[jira] [Created] (OPENJPA-2742) SchemaTool fails with MySQL
Francesco Chicchiriccò created OPENJPA-2742:
-----------------------------------------------
Summary: 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: 3.0.0, 2.4.3
Reporter: Francesco Chicchiriccò
Assignee: Francesco Chicchiriccò
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)