jdbc – Page 27 – Tarik Billa

MySQL JDBC Driver 5.1.33 – Time Zone Issue

September 16, 2022 by Tarik

Apparently, to get version 5.1.33 of MySQL JDBC driver to work with UTC time zone, one has to specify the serverTimezone explicitly in the connection string. jdbc:mysql://localhost/db?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

java.util.Date vs java.sql.Date

September 12, 2022 by Tarik

Congratulations, you’ve hit my favorite pet peeve with JDBC: Date class handling. Basically databases usually support at least three forms of datetime fields which are date, time and timestamp. Each of these have a corresponding class in JDBC and each of them extend java.util.Date. Quick semantics of each of these three are the following: java.sql.Date … Read more