Dbeaver: KST Timezone not supported

Created on 5 Jul 2016  ยท  3Comments  ยท  Source: dbeaver/dbeaver

If the database server has KST (Korean Standard Time) timezone, it will complain that the timezone is unrecognized, despite the fact that the timezone is well-established and is used by more than 50 million people from South Korea. KST is technically the same as JST, so I can just workaround it by manually setting serverTimezone to JST, but it is quite annoying to do that for every server connection. And plus, it might deter some Korean friends from using this wonderful tool.
image

question

Most helpful comment

I assume that you are using MySQL.
It is a bug in MySQL driver 6.x+.
There are two workarounds:

  • Use 5.x version:
  • Set serverTmezone property explicitly in connection settings (driver properties tab)

maven-driver-version

All 3 comments

I assume that you are using MySQL.
It is a bug in MySQL driver 6.x+.
There are two workarounds:

  • Use 5.x version:
  • Set serverTmezone property explicitly in connection settings (driver properties tab)

maven-driver-version

๋‹˜ ์ €๋„ ๋ผ์ฆˆ๋ฒ ๋ฆฌ์—๋‹ค๊ฐ€ ํƒ์บฃ์œผ๋กœ ์›น ๋ฐฐํฌํ›„ mysql ๊ธฐ๋Šฅ์ด ์žˆ๋Š”๊ฒƒ์€ KST ๋ผ๋Š” ๊ฒƒ์„ ์ธ์‹ ๋ชปํ•ด์„œ ์˜ค๋ฅ˜๊ฐ€ ๋‚˜๋„ค์š” ใ… ใ… ใ…  ํ˜น์‹œ ์ด๊ฑฐ ํ•ด๊ฒฐ๋ฐฉ๋ฒ• ํ•˜์…จ์œผ๋ฉด ์•Œ๋ ค์ฃผ์‹ค์ˆ˜ ์žˆ๋‚˜์š”?
[email protected] ์ œ ๋ฉ”์ผ ์ฃผ์†Œ์ž…๋‹ˆ๋‹ค ใ… ใ… ใ…  ์ด๊ฒƒ ๋–”์— ์—„์ฒญ ๊ณ ์ƒํ•˜๊ณ  ์žˆ์–ด์š” ใ… ใ… ใ… 

For DBeaver:
right-click on connection - edit connection.
Under connection settings set 'Server time zone' to your zone.Click OK

Was this page helpful?
0 / 5 - 0 ratings

Related issues

codetrash picture codetrash  ยท  3Comments

Lakston picture Lakston  ยท  3Comments

NidhinRV1984 picture NidhinRV1984  ยท  3Comments

gabrieltomio picture gabrieltomio  ยท  3Comments

Otiel picture Otiel  ยท  3Comments