Shulou(Shulou.com)06/01 Report--

Editor to share with you what to do when there is something wrong with serverTimezone in Hibernate. I believe most people don't know much about it, so share this article for your reference. I hope you will get a lot after reading this article. Let's learn about it together.

Prompt: java.sql.SQLException: The server time zone value 'host ±home' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

You need to add? serverTimezone=UTC after the hibernate.connection.url entry

Pay attention to the case of serverTimezone. I stepped on the hole here twice, first without adding serverTimezone, and then write serverTimezone as serverTimeZone.

The final correct configuration is as follows:

Jdbc:mysql://localhost:3306/testdb?serverTimezone=UTC above is all the content of this article "what to do if there is a problem with serverTimezone in Hibernate". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.