Products | Versions |
---|---|
TIBCO Data Virtualization | 7.0.x and higher |
At the time of this writing, the current TDV v8.2 supports Mysql version 5.1 and version 5.5 as datasources. Mysql is currently vending their version 8.0 jdbc driver (Connector/J) that is documented by them as compatible with Mysql version 5.5 server.
If Mysql version 8 jar file (mysql-connector-java.jar) is used and is installed at the proper location in TDV under: \conf\adapters\system\mysql_5_5, TDV may still throw an error similar to this popping up in Studio, during a connection attempt to the Mysql database.
Cause: The server time zone value 'PDT' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
Root Cause: The Mysql Connector/J version 8.0 is now requiring a valid and specific timezone to be specified.