feat: MySQL, MariaDB always store timestamps in UTC

kagkarlsson commented 6 months ago

Update: Breaking change for MySQL and MariaDB users later reverted in #481

BREAKING CHANGE: Since MySQL and MariaDB does not have a datatype for storing timestamps with time zones, start defaulting to storing them in UTC to avoid issues with DST
BREAKING CHANGE: Change Oracle schema to use a datatype that supports time zones
New config-option to override default timestamp persistence behavior for PostgreSQL and Oracle to UTC
mysql-jdbc v12.4.2.jre8
mariadb-java-client v3.3.2
testcontainers v1.19.7

kagkarlsson commented 4 months ago

🎉 This issue has been resolved in v14.0.0 (Release Notes)

rydenius commented 3 months ago

As it is not mentioned in PR description, was it intentional that there was also an API breaking change for PostgreSQL, with the zero argument constructor of PostgreSqlJdbcCustomization removed?

kagkarlsson commented 3 months ago

Not intentional no, more of a slip. Sometimes difficult to remember everything that should make it into a release-note or pr-description

kagkarlsson / db-scheduler

feat: MySQL, MariaDB always store timestamps in UTC #471