Problem with Table name Groups

[eldologuzzo]

Renaming the table, the reverse engineering option was able to import the model into the structure of the table. The Compare with database operation does not work either.

-- AccessControl.Groups definition

CREATE TABLE Groups (
GroupIdentification char(32) NOT NULL,
Description varchar(80) DEFAULT NULL,
ProfileIdentificationDefault varchar(48) DEFAULT NULL,
ActionIdentificationDefault varchar(48) DEFAULT NULL,
UserCommunity varchar(48) DEFAULT NULL,
Configuration varchar(512) DEFAULT NULL,
Enable tinyint(1) DEFAULT NULL,
CreateUser char(48) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
CreateMoment datetime DEFAULT NULL,
UpdateUser char(48) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
UpdateMoment datetime DEFAULT NULL,
PRIMARY KEY (GroupIdentification)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[mirkosertic]

Thank you for this issue. Do you have the exact stack trace ERDesigner has shown in the error dialog? Which Database Version and OS are you using?

Thanks in advance,
Mirko

[eldologuzzo]

Hi Mirko, java.util.concurrent.ExecutionException: java.sql.SQLSyntaxErrorException: 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 'Groups' at line 1 at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122) at java.base/java.util.concurrent.FutureTask.get(FutureTask.java:191) at java.desktop/javax.swing.SwingWorker.get(SwingWorker.java:613) at de.erdesignerng.visual.LongRunningTask.run(LongRunningTask.java:62) Caused by: java.sql.SQLSyntaxErrorException: 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 'Groups' at line 1 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1200) at de.erdesignerng.dialect.mysql.MySQLReverseEngineeringStrategy.reverseEngineerAttribute(MySQLReverseEngineeringStrategy.java:65) at de.erdesignerng.dialect.JDBCReverseEngineeringStrategy.reverseEngineerTable(JDBCReverseEngineeringStrategy.java:325) at de.erdesignerng.dialect.JDBCReverseEngineeringStrategy.updateModelFromConnection(JDBCReverseEngineeringStrategy.java:750) at de.erdesignerng.visual.common.ReverseEngineerCommand$2.doWork(ReverseEngineerCommand.java:134) at de.erdesignerng.visual.common.ReverseEngineerCommand$2.doWork(ReverseEngineerCommand.java:125) at de.erdesignerng.visual.LongRunningTask$1.doInBackground(LongRunningTask.java:52) at java.desktop/javax.swing.SwingWorker$1.call(SwingWorker.java:304) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.desktop/javax.swing.SwingWorker.run(SwingWorker.java:343) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:835) Regards Eldo

…

On Sun, May 10, 2020 at 2:42 PM Mirko Sertic ***@***.***> wrote: Thank you for this issue. Do you have the exact stack trace ERDesigner has shown in the error dialog? Which Database Version and OS are you using? Thanks in advance, Mirko — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#101 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AB7DTXHRKQAWPJFUECWMBWLRQ37T5ANCNFSM4M43CIFQ> .

[eldologuzzo]

MySQL 8.0.13