Hi guys,

I've just downloaded the new CDE and I'm trying to connect it to a mysql database.

The challenge I'm having is when I create a new connection, it does the test fine. It is when I get to the select tables that I get in to trouble.

I add the table I want and select the fact table, and push "Finish". The next screen tells me that is processing, but gets stuck.

The catalina.log displays the following error;

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1

I'm on a Mac system and the mysql version is 5.7.18.

Can you guys help me with this one?