Skip to end of metadata
Go to start of metadata

MySQL Translator (mysql/mysql5)

Also see common JDBC Translator Information

MySQL/MariaDB translation is supported by 2 translators.

mysql

The Mysql translator, known by the type name mysql, is for use with MySQL version 4.x.

mysql5

The Mysql5 translator, known by the type name mysql5, is for use with MySQL version 5 or later.

Also supports compatible MySQL derivatives including MariaDB.

Usage

The MySQL Translators expect the database or session to be using ANSI mode. If the database is not using ANSI mode, an initialization query should be used on the pool to set ANSI mode:

If you may deal with null timestamp values, then set the connection property zeroDateTimeBehavior=convertToNull. Otherwise you'll get conversion errors in Teiid that '0000-00-00 00:00:00' cannot be converted to a timestamp.
Labels:
None
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.