Uploaded image for project: 'JBoss Enterprise SOA Platform'
  1. JBoss Enterprise SOA Platform
  2. SOA-3170

MySQL 5.5 - Type=InnoDB has changed to ENGINE=InnoDB

    XMLWordPrintable

    Details

    • Release Notes Text:
      Hide
      https://issues.jboss.org/browse/SOA-3170

      Users who upgraded to MySQL version 5.5 and tried to run SOA-P encountered an error message that stated, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB'".

      This was caused by the fact that 'TYPE=InnoDB' had been changed to 'ENGINE=InnoDB'. To rectify this issue, the BPEL engine has been updated to support the amended syntax.
      Show
      https://issues.jboss.org/browse/SOA-3170 Users who upgraded to MySQL version 5.5 and tried to run SOA-P encountered an error message that stated, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB'". This was caused by the fact that 'TYPE=InnoDB' had been changed to 'ENGINE=InnoDB'. To rectify this issue, the BPEL engine has been updated to support the amended syntax.
    • Release Notes Docs Status:
      Documented as Resolved Issue

      Description

      I upgraded system including MySQL to version 5.5 without notice and if I tried to run SOA-P I received this syntax error "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB'". I found that 'TYPE=InnoDB' has been changed to 'ENGINE=InnoDB'. Don't be afraid, 'ENGINE=InnoDB' is supported in previous versions too.
      I noticed that It's in deploy/riftsaw.sar/bpel-sql/mysql.sql but It can be somewhere else too.

        Gliffy Diagrams

          Attachments

            Issue Links

            cloned to

            Bug - A problem which impairs or prevents the functions of the product. RIFTSAW-409 MySQL 5.5 - Type=InnoDB has changed to ENGINE=InnoDB

            • Major - A request that should be considered seriously but is not a show stopper.
            • Closed

              Activity

                People

                • Assignee:
                  jcoleman Julian Coleman
                  Reporter:
                  ibek Ivo Bek
                  Writer:
                  David Le Sage
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: