AnsweredAssumed Answered

Database Import Wizard error in MySQL DB Connector

Question asked by paul_kryla274185 on Jul 15, 2018
Latest reply on Aug 2, 2018 by paul_kryla274185

I'm trying to import data via 'Database Import Wizard' (MySQL DB). But while trying to create the profile,I encounter this error message:

 

"Unable to extract database meta data. 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 'HAVING TABLE_TYPE IN ('TABLE',null,null,null,null) ORDER BY TABLE_TYPE, TABLE_SC' at line 1"

 

Few things to note:

- Atom connection to DB server was tested successfully. 

- Using MySQL version 8.0.1

- mysql-connector-java-8.0.11.jar is located in lib directory

- DB server is running

 

Outcomes