Hide Forgot
project_key: SOA 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.
Link: Added: This issue Cloned to RIFTSAW-409
Fix is in the RiftSaw 2.3.x branch; will be included in SOA-P 5.2.0.ER2.
Release Notes Docs Status: Added: Documented as Resolved Issue Writer: Added: dlesage Release Notes Text: Added: 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.
Will close as soon as we have the first version of release notes on the doc server,
Just to confirm - the bug was fixed in ER2 - the release note should inform users that both the old and new syntax are supported - correct?
Verified in SOA 5.2 ER6 and in release notes http://documentation-stage.bne.redhat.com/docs/en-US/JBoss_Enterprise_SOA_Platform/5/html-single/5.2.0_Release_Notes/index.html#sect-resolved_JIRAs