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>
Copyright © TIBCO Software Inc. All rights reserved.