Product: TIBCO Spotfire®
Unable to create a MySQL datasource via Spotfire Information designer.
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.
----------
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
https://stackoverflow.com/questions/26515700/mysql-jdbc-driver-5-1-33-time-zone-issue
Comments
0 comments
Article is closed for comments.