AnsweredAssumed Answered

Database Import Wizard error in MySQL DB Connector

Question asked by paul_kryla274185 on Jul 15, 2018
Latest reply on Oct 16, 2018 by bolubajo7862468

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