Unable to create a MySQL datasource via Spotfire Information designer.
Article ID: KB0079891
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All Supported Versions |
Description
When you try to create and save the MySQL datasource via Spotfire Information services it may fail with the following error message:
------------
java.sql.SQLException: The server timezone value 'EDT' is unrecognized or represents more than one timezone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc timezone value if you want to utilize timezone support.
----------
------------
java.sql.SQLException: The server timezone value 'EDT' is unrecognized or represents more than one timezone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc timezone value if you want to utilize timezone support.
----------
Issue/Introduction
Unable to create a MySQL datasource via Spotfire Information designer.
Environment
All Supported Environments
Resolution
Add the following code to the JDBC url and try resaving it.
----------------
?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
-----------------
Eg:jdbc:mysql://<host>:<port>/<database>?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
----------------
?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
-----------------
Eg:jdbc:mysql://<host>:<port>/<database>?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
Additional Information
https://stackoverflow.com/questions/26515700/mysql-jdbc-driver-5-1-33-time-zone-issue
Feedback
Yes
No
Powered by
