Eclipse Community Forums: Eclipse Process Manager (Stardust) » Appropriate Mysql Version INNODB Error

Home » Eclipse Projects » Eclipse Process Manager (Stardust) » Appropriate Mysql Version INNODB Error(Appropriate Mysql Version INNODB Error)

Show: Today's Messages :: Show Polls :: Message Navigator

Appropriate Mysql Version INNODB Error [message #756697]

Mon, 14 November 2011 12:34

Vikram Kodak
Messages: 56
Registered: October 2011

Member

Hi,

We are getting following error while using the sysconsole command to create the Stardust DB schema on MySQL.

Error creating table 'XXXXX.process_trigger'. Reason: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version f
or the right syntax to use near 'TYPE=InnoDB' at line 1

Report message to a moderator

Re: Appropriate Mysql Version INNODB Error [message #756698 is a reply to message #756697]

Mon, 14 November 2011 12:35

Vikram Kodak
Messages: 56
Registered: October 2011

Member

There are MySQL versions that do not accept the type=INNODB at the end of "create table" statements anymore. However, this would imply that you are using a MySQL version that was not tested with your Stardust version (check the release notes).
If this is indeed the problem, then there is a workaround: Spool the SQL statements into a file as mentioned below (sysconsole ddl f ipp.sql) and replace "type=INNODB" with "engine=INNODB".

Report message to a moderator

Previous Topic:	Eclipse shows feature installation history although reinstalled
Next Topic:	Connect to SQLServer through JDBC using Windows Authentication

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 16:45:12 EDT 2013