Showing posts with label time zone. Show all posts
Showing posts with label time zone. Show all posts

Wednesday, April 15, 2020

MySQL JDBC Driver - Time Zone Issue

MySQL JDBC Driver - timezone issue or the server timezone value 'unknown' is unrecognized or represents more than one value, etc. occurred then following step would help to resolve: 

Just add the following line end of JDBC connection string,
?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
Complete connection string below,
jdbc:mysql://hostname_or_ip:port/db_name?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC