JDBC ZonedDateTime problem

From: Blake McBride <blake(at)mcbride(dot)name>
To: pgsql-odbc <pgsql-odbc(at)postgresql(dot)org>
Subject: JDBC ZonedDateTime problem
Date: 2017-10-05 00:19:52
Message-ID: CABwHSOvcM3zM3WW4e+BBKYNxhHcEcBUXxbBc_t1aje3oxVri+w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Cramer 2017-10-05 02:34:13 Re: JDBC ZonedDateTime problem
Previous Message Evan Blackstone 2017-10-02 17:43:53 ODBC binary downloads -- SHA256sums?