Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Timezone and MySQL Connector #3599

Closed
qantuum opened this issue Jun 8, 2018 · 3 comments

Comments

@qantuum
Copy link

commented Jun 8, 2018

Dear dBeaver team.

Thanks a bunch for allowing us users to get a free solution for databse management.
Nevertheless; this issue about timezone has infuriated me and I have done many research operations, to find the same issue was declared in 2016 (!) :
--#1088

So here are the problems :
(1)your 'submit issue guidelines' located at https://github.com/dbeaver/dbeaver/blob/devel/CONTRIBUTING.md is an empty file
(2)when first using a mySQL database; dBeaver automatically downloads a JDBC version 8.xx that does not support 'CEST' as a correct timeZone; which results in an error !
(3)No field provided to change this 'CEST' to another value in the JDBC driver config menu
(4)Having no skill in Java, I can not find by myself the place where the error is located.
(5)I do not know why is so that the JDBC and dBeaver cannot accept 'CEST' as the correct value. If it comes from the JDBC, that's bad Java coding. If it comes from dBeaver... Maybe it is time for you to adapt to the most recent connection drivers...
(6)I eventually got my problem solved by downgrading my JDBC connector driver manually; as stated in issue 1088.

I want to say it's a pity that this kind of errors keep popping in numerous apps, since the final user does not always have the right skill to solve the problem.

Best of luck in the future;
best regards

@serge-rider

This comment has been minimized.

Copy link
Member

commented Jun 8, 2018

You don't need to know Java or any other programming language.

Anyhow, there is no such standard timezone CEST, it is just CET.
So you can just set driver property serverTimezone to CET.

I understand your problem and I'd wish to make this simpler. But Oracle keep changing MySQL servers/clients so they are not fully backward compatible (e.g. you can't connect to MySQL 8.x with old drivers - that's why we upgraded it to 8.0 driver by default).

@serge-rider serge-rider added the question label Jun 8, 2018
@qantuum

This comment has been minimized.

Copy link
Author

commented Jun 9, 2018

Hey there;

thanks for answering !
Actually I already saw this 'set driver property' solution, but did not find a way how to set it.

At what moment do I have this possibility ? Is it when I choose the driver version for download ?
Or do I have to enter one of the submenus (add file, details,...). Eventually can you show me with a screenshot ?
Thanks.

@serge-rider

This comment has been minimized.

Copy link
Member

commented Jun 11, 2018

This is one of the oldest features in DBeaver:

image

@tati-kru tati-kru closed this Nov 2, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
3 participants
You can’t perform that action at this time.