embulk / embulk/embulk-input-jdbc

[MySQL] Investigate timezone parameter setting for update Connector/J

Open
#115 0 comments 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.