Setting up MySQL5 vendor driver

For the MySQL5 vendor driver to work with MySQL data sources that include TIMESTAMPS that can potentially be null, you must edit the template.

Procedure

In the MySQL5 data source template, locate the following section:

<connection-properties>
 <connection-property>
 <key>useDynamicCharsetInfo</key>
 <value>false</value>
 </connection-property>
</connection-properties>

Within the connection-properties tag, add the following code:

<connection-property>
 <key>noDatetimeStringSync</key>
 <value>true</value>
</connection-property>
<connection-property>
 <key>zeroDateTimeBehavior</key
 <value>convertToNull</value>
</connection-property>