I'm looking at addressing TEIID-525, TEIID-124, and TEIID-203, which all impact the Connector API. If there are additional comments on these or any other changes needed to the Connector API in the 6.1.0 cycle, please create let us know.
Starting with release Teiid 6.0.0 (Designer and Embedded) the support
for the vendor supplied JDBC drivers is extended to include
Microsoft SQL Server
Teiid Designer will provide templates for you to use the vendor's JDBC
drivers to import and preview data from database. Embedded will work
with the native drivers in building a respective Connector connections.
Note that we *DO NOT* bundle any vendor JDBC drivers with Teiid kits,
you are still required for providing these drivers to be used with Teiid
Designer and Teiid Embedded and configuring them correctly to make use
"Data Direct" based JDBC templates for importing and building Connectors
are removed from community versions. Please note that you could still
use the "Data Direct" drivers, but pre-built customized templates are
not available. We will give directions on how you can use "Data Direct"
in forth coming WIKI article soon.
If you are looking for a specific Database support, please be sure to
let us know, and open up a JIRA.
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:
I have compiled the source and now it works.