1

To connect MySQL, I added the mysql-connector jar to the classpath of the program. But when I tried to run and add the server database I'm having the following error:

sql exception: server shows more than one timezone, do specific timezone to utilize the server using server timezone configuration.

To remove this error and to use the MySQL server what should i do???

Kulasangar
  • 9,046
  • 5
  • 51
  • 82
Seet Mansura
  • 11
  • 2

1 Answers1

0

You are facing JDBC Timezone issues. Add following parametre in your DB Connection URL to solve Timezone related issues.

jdbc:mysql://localhost/db?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
Onkar Musale
  • 909
  • 10
  • 25