I tried 4 hours generating database with VISUAL PARADIGM using mysql java connector jar library, but still getting following error:
[Error] Setting Quote SQL Identifier option to Auto or Yes may solve this problem
my mysql version is 5.5.
Asked
Active
Viewed 802 times
0
hpaknia
- 2,769
- 4
- 34
- 63
2 Answers
0
the problem is MySQL 5.5 doesn't support "type" table option and the new option is "Engine". So simply you can change your mysql version to <5.5 or find a way to edit jdbc library to create querys with Engine Option, instead of type.
hpaknia
- 2,769
- 4
- 34
- 63
0
Visual Paradigm do support generating database for MySQL 5.5. Please make sure you have picked Version 5.0.5 or higher in the Database Configuration dialog to avoid this problem.
Rain Wong
- 21
- 1
-
I can not see any option in Visual Paradigm version 8.0 Enterprise edition. – hpaknia Feb 18 '13 at 09:38