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