conversion between postgres timestamp and Java instant

[sraturi]

Hello,

I am using a field like this

@Column(name = "services_heartbeat_timestamp", nullable = false, columnDefinition = "timestamptz default now()")
open lateinit var servicesHeartbeatTimeStamp: Instant

This works fine when doing a get/set. However, when I run a query like

UPDATE RandomClass r SET r.servicesHeartbeat=:heartbeat WHERE r.heartbeatTimeStamp <:instant

the where comparison doesn't work for me. variable instant is of type Java.Time.Instant , replacing instant with now() does not work either.

I tried setting

quarkus.hibernate-orm.jdbc.timezone=UTC
TimeZone.setDefault(TimeZone.getTimeZone("UTC"))
System.setProperty("user.timezone","UTC")

to make sure I am in same timezone.

Currently, I am failing the test case

val instant = Instant.now().minusSeconds(5)
val random = RandomClass().apply {this.heartbeatTimeStamp = instant }
random.persistAndFlush()
// run the named query
random.updateheartBeat(Instant.now())
// failing assert regarding the above changes

Quarkus version : 2.7.5

[sraturi]

Sorry False alarm found out the issue was more of transactional nesting.