I reopened TEIID-379 and addressed this in 6.1.0. ----- Original Message ----- From: "Davide Cerbo" <d.cerbo(a)pronetics.it&gt; To: teiid-users(a)lists.jboss.org Sent: Monday, April 20, 2009 7:04:27 AM GMT -06:00 US/Canada Central Subject: [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 ----------- _______________________________________________ teiid-users mailing list teiid-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/teiid-users