[Solved] Can't Connect to Mysql following Java update

Discuss the database features
Post Reply
GowerMick
Posts: 114
Joined: Mon Feb 28, 2011 10:19 am

[Solved] Can't Connect to Mysql following Java update

Post by GowerMick »

I have just updated java to 1.8.0_171, along with the latest Connector/J 8.0.11, (without changing any settings from default)

I now get the following message when I try to access the database:

The connection to the data source 'Mysql Bookings' could not be established.
The server time zone value'GMT Summer Time' is not recognised or represents more than one timezone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specific time zone value if you want to utilize time zone support.

Any idea of how to cure this?
Last edited by GowerMick on Thu Apr 26, 2018 8:42 am, edited 2 times in total.
Mick
LibreOffice 7.2.6.2 (x64)
Oracle Report Builder
Windows 10 Home
GowerMick
Posts: 114
Joined: Mon Feb 28, 2011 10:19 am

[Solved]Re: Can't Connect to Mysql following Java update

Post by GowerMick »

I reverted to previous Connector/J (V 5.1.45) and problem seems to have cleared. I'm beginning to wonder if I had downloaded the wrong version, but WTH, it is working now. For how long though, that's what's worrying me :(
Mick
LibreOffice 7.2.6.2 (x64)
Oracle Report Builder
Windows 10 Home
UnklDonald418
Volunteer
Posts: 1544
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: [Solved]Can't Connect to Mysql following Java update

Post by UnklDonald418 »

If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Post Reply