JDBC ZonedDateTime problem

Blake McBride <[email protected]>
Newsgroups gmane.comp.db.postgresql.odbc
Message-ID <CABwHSOvcM3zM3WW4e+BBKYNxhHcEcBUXxbBc_t1aje3oxVri+w@mail.gmail.com>
Greeings,

I am using PostgreSQL 9.3.19 on a 64 bit Linux box with
postgresql-42.1.4.jar and 64 bit Java 8.

I am doing setObject with ZonedDateTime.now(ZoneOffset.UTC) and I get:

org.postgresql.util.PSQLException: Can't infer the SQL type to use for an
instance of java.time.ZonedDateTime. Use setObject() with an explicit Types
value to specify the type to use.

What I am trying to do is set the column to the current datetime UTC.

Any help would sure be appreciated!

Blake McBride
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.