JDBC Timezone Error connection to Azure
Answered
Greetings,
- I have an Azure db for MySql up and running.
- Workbench connects properly, remotely, from my desktop.
- When I set up the PyCharm connection I get an timezone error:
The server time zone value 'Coordinated Universal Time' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration.
Amazon says you can't change the UTC time so how do I change the JDBC setting as I can't find where to do this.
Thanks in advance,
Rick
Please sign in to leave a comment.
As an update to others that have this problem, there is a workaround.
You can go into the data source properties and set the serverTIMEZONE attribute (under advanced) to 'UTC'
All is good in newbie land.
Rick
I think it is safe to close this case. I found a setting under 'advanced' that was set to CST. I removed that and all seems to be working now.
Thanks,
jim