MySQL ODBC - OLE DB Provider [-2147217900]

[ecsgz]

Hello,

please help and support me to solve this error, while trying to use MySQL server and EA. The EA_InnoDB schema has been set successfully before (http://www.sparxsystems.com/resources/corporate/index.html#sql_scripts) and a ea data model was successfully transformed to the database.

Error:

Microsoft OLE DB Provider for ODBC Drivers [-2147217900]

[MySQL][ODBC 5.1 Driver][mysql-5.6.22-log]Your have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Partition as Signed)' at line 1


Error occurs with software:

EA (32 Bit) Version: 9.3.5, 10.x

MySQL ODBC driver (32 Bit) Version 5.1.5, 5.1.13, 5.3.4

Community MySQL Server Version: 5.6.17 (@server, 64 Bit), 5.6.22 (@local, 64 Bit)

Desktop: Windows 7, 64 Bit

 
Description:

Access to EA model without any problem, except of this:

=> Login and connection to database via EA Tool without any problem. EA model can be accessed.

=> Everytime a diagram is opened (to which access is granted), the error warning occurs.

[Pawel Miechowiecki]

MySQL from version 5.1 provides partitioning. Some SQL statements generated by Enterprise Architect uses word 'partition' because some of columns are called as the restricted key word 'partition'.
See:

Code: [Select]

select * from information_schema.columns where column_name='partition'The workaround is downgrade MySQL to 5.0 or earlier, but indeed this issue needs patch for EA

[hd]

... or upgrade to the current build of EA. The MySQL Partition issue was fixed in build 1009.

[jakson]

Like it was mentioned, this bug was fixed in newer EA versions:

Enterprise Architect 9.2 (9.2.921.23) - generates SQL error
Select * from t_xref where `Type`='swimlane' and Client='{...}' order by Cast(Partition as Signed);

Enterprise Architect 11 (11.1.1113.5) - no SQL error
Select t_xref.* from t_xref,t_diagram where `Type`='swimlane' and Client=t_diagram.ea_guid and t_diagram.Diagram_ID = ...  order by Cast(`Partition` as Signed);