java.sql.SQLException: The server timezone value ‘UTC’ is unrecognized

Date: 2023-07-10
The Java JDBC error "The server timezone value ‘UTC’ is unrecognized" arises from a mismatch between the database server's timezone setting and the JDBC driver's capabilities. This usually occurs when using an outdated JDBC driver or an incorrectly configured database server. Solutions involve updating the JDBC driver to a version supporting UTC, explicitly setting the timezone in the PostgreSQL postgresql.conf
file (e.g., timezone = 'UTC'
), or specifying the timezone within the JDBC connection URL. Restarting the PostgreSQL server after making configuration changes is crucial.
Read more: https://examples.javacodegeeks.com/server-timezone-value-utc-is-unrecognized
Subscribe to my newsletter
Read articles from Yatin B. directly inside your inbox. Subscribe to the newsletter, and don't miss out.
Written by
