DbNow() cast now()->::timestamp (TIMESTAMPTZ->Instant broke LocalDateTime)

Ya

7 Julai 2026, 00:27 UTC

Mwandishi

Kamo

Ahadi ya

800fb5a

SELECT now() returns TIMESTAMPTZ, which Hibernate materializes as java.time.Instant and cannot cast to the declared LocalDateTime return type — throwing ClassCastException on every lock acquire/heartbeat/sweep and every task create/update. Casting to now()::timestamp yields a TIMESTAMP (UTC wall-clock) that maps cleanly to LocalDateTime.