embulk / embulk/embulk-input-jdbc
[MySQL] Investigate timezone parameter setting for update Connector/J
- Dominant language
- Java
- Stars
- 106
- Forks
- 76
- PR merge metrics
- No merged PRs in 30d
Description
I posted a question to [MySQL Forums Connector/JDBC and Java](https://forums.mysql.com/list.php?39) about timezone parameters. It's moderated forum. It does not show yet on listing page.
### contents.
Hello, members.
I would like to know the best practice.
Could you tell me what parameters I should set?
Parameters
* useLegacyDatetimeCode
* serverTimeZone
* noTimezoneConversionForDateType
* cacheDefaultTimezone
Environment.
* Client and server time zones differ. (ex. Server: UTC, Client Asia/Tokyo)
* Client and server time zones are the same. (ex. Server and Client is Asia/Tokyo).
It worked as I expected in the Connector/J version 5.1.34.
* Client and server time zones differ.
- useLegacyDatetimeCode: false
- serverTimeZone: UTC
* Client and server time zones are the same.
- no options
The noTimezoneConversionForDateType and cacheDefaultTimezone introduced in the 5.1.35.
But I can't find those parameters combination settings.
https://dev.mysql.com/doc/relnotes/connector-j/5.1/en/news-5-1-35.html
> noTimezoneConversionForDateType and cacheDefaultTimezone:
> For improving Connector/J's time zone support;
> see the changelog entry for Bug #18028319/Bug #71084 below for details
Best regards
--
Hiroyuki Sato.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.