Anyone had luck getting H2 timestamp with time zone
columns to read into a useful datatype with next.jdbc? By default these are being read as org.h2.api.TimestampWithTimeZone
. The H2 docs claim that they can be mapped to java.time
objects but haven't found anything that explains how to make that happen
https://gist.github.com/olieidel/a3806430622642c51160e7576ee8e394
Ah, thanks. Sort of the hammer approach there. I'll try it 😄
@michael.gaare Did you try requiring next.jdbc.date-time
?
(I'm curious whether that ns provides any automation for that particular case)
@seancorfield yes, I did, and it does not
Unfortunately, org.h2.api.TimestampWithTimeZone
is not in the class hierarchy of anything that next.jdbc.date-time
touches
it's something of a bizarre data type to be honest
honestly thats fine
points to the design of next.jdbc for making that transparent
@michael.gaare Yeah, some of the JDBC drivers have the weirdest custom classes 😞