[jira] [Commented] (ODE-966) SQL scripts fail on newest MySQL

["Tammo van Lessen (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ODE-966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13497625#comment-13497625 ] 

Tammo van Lessen commented on ODE-966:
--------------------------------------

Confirmed, thanks for reporting this. Unfortunately there is not stable release from openJPA's 1.3.x branch, so we cannot use it in a bugfix release. We try to address this for the next major release (1.4)
                
> SQL scripts fail on newest MySQL
> --------------------------------
>
>                 Key: ODE-966
>                 URL: https://issues.apache.org/jira/browse/ODE-966
>             Project: ODE
>          Issue Type: Bug
>    Affects Versions: 1.3.5
>         Environment: mysql 5.5.20, ubuntu 12.04
>            Reporter: Piotr Kubowicz
>             Fix For: 1.4
>
>
> ode-135-hib-mysql.sql and mysql.sql cause errors on the newest versions of MySQL. The reason is that the scripts use syntax like
>   TYPE=InnoDB;
> TYPE was replaced by ENGINE in MySQL and since MySQL 5.5 the old syntax is no longer supported. 
> Please use
>   ENGINE=InnoDB;
> instead.
> See OPENJPA-1530 for more details.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira