Hi!
I will very grateful for your consultation. Faced exception, tied with
TemporalAccessor.
I see, that my TRANSACTIONS table generated using LocalDateTime type field
for transaction_date column.
During writing the tests I wanted to set transaction_date for several
transactions I interested in. But there always throw exception.
Details below:
Generated table field:
----------------------------------------------------------------
public final TableField<Record, LocalDateTime> TRANSACTION_DATE =
createField(DSL.name("TRANSACTION_DATE"), SQLDataType.LOCALDATETIME(6),
this, "");
----------------------------------------------------------
QUERY I want to use in tests:
----------------------------------------------------------
jooq.update(TRANSACTIONS)
.set(TRANSACTIONS.TRANSACTION_DATE, LocalDateTime.from(Instant.now()))
.where(TRANSACTIONS.ID.in(uuid("fe44ac34-df26-d847-d013-6cc71b1e8193"
)).execute();
---------------------------------------------------------------
Exception:
---------------------------------------------------------------
java.time.DateTimeException: Unable to obtain LocalDateTime from
TemporalAccessor: 2024-02-18T15:20:55.286412600Z of type java.time.Instant
Thanks in advance!
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/b319e710-ffcc-4bf4-879d-2c924169589bn%40googlegroups.com.
