[teiid-users] Issue using MySQL

Hi all, I'm using Teiid to connect to a Derby and MySQL databases. The designer (version pre-6.0.0) works well, but when I trying to connect from my application I have the follow error: 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 'sql-mode = 'ANSI'' at line 1 The cause is line 84 in MySQLTranslator.java: stmt.execute("set SESSION sql-mode = 'ANSI'"); //$NON-NLS-1$ The correct syntax it would be: set SESSION sql_mode = 'ANSI I have take this syntax from: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html I have compiled the source and now it works. -- Davide Cerbo ----------- http://www.pronetics.it http://www.sourcesense.com http://www.jesty.it http://jugsalerno.wordpress.com -----------