Re: Error when setting useTimezone=true

[Paul Darling]

I've tried populating the mysql time_zone* tables, and setting GLOBAL time_zone = 'America/Los_Angeles', but now see this error:-

java.sql.SQLException: Can't map timezone 'America/Los_Angeles' to canonical timezone.
at com.mysql.jdbc.Connection.configureTimezone(Connection.java:3121)
at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3252)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1780)
at com.mysql.jdbc.Connection.<init>(Connection.java:430)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)

Any idea what type of time zone values needs to be used. When the server was using PDT, the JDBC error message gave 'America/Los_Angeles' as an example of a time zone to use instead.

Paul