Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

mysql driver issue (v 8.0.11) - timezone error

Description

I upgraded mysql driver to version 8.0.11 and the following error occurred
==============
The server time zone value 'WAT' 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.
==============

Environment

Mac OS X (10.12.6) 64bit
mysql 5.6.39 Homebrew

Attachments

2
  • 26 Jul 2018, 01:28 pm
  • 26 Jul 2018, 01:28 pm

Activity

Show:

Michael Offner 7 August 2018 at 18:59

problem is the timezone set with the jdbc client is not supported by the db server.

workaround:
set a different timezone with the datasource for example "Africa/Niamey", also updateing the JVM could solve the issue.

Won't Fix

Details

Assignee

Reporter

Priority

Labels

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Affects versions

Created 26 July 2018 at 13:35
Updated 17 May 2023 at 14:24
Resolved 17 May 2023 at 14:24

Flag notifications