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?
[Solved] Can't Connect to Mysql following Java update
[Solved] Can't Connect to Mysql following Java update
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
LibreOffice 7.2.6.2 (x64)
Oracle Report Builder
Windows 10 Home
[Solved]Re: Can't Connect to Mysql following Java update
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
LibreOffice 7.2.6.2 (x64)
Oracle Report Builder
Windows 10 Home
-
- Volunteer
- Posts: 1544
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: [Solved]Can't Connect to Mysql following Java update
Look at this link
https://stackoverflow.com/questions/277 ... ysql-fails
https://stackoverflow.com/questions/277 ... ysql-fails
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
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11