Re: [ODBC] JDBC ZonedDateTime problem

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: [ODBC] JDBC ZonedDateTime problem
Дата
Msg-id CADK3HH+CHZajdFu62jyhmWTxQv1uFyYgJFLaGDeoLHiyqwSnhw@mail.gmail.com
обсуждение исходный текст
Ответ на [ODBC] JDBC ZonedDateTime problem  (Blake McBride <blake@mcbride.name>)
Список pgsql-odbc
Hi Blake,

You'd have a lot better luck sending it to the pgsql-jdbc list. That being said. setObject can be told what type to use, although we should be able to infer the type from the object passed in. Can you file a bug on github https://github.com/pgjdbc/pgjdbc

Thanks


On 4 October 2017 at 20:19, Blake McBride <blake@mcbride.name> wrote:
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


В списке pgsql-odbc по дате отправления:

Предыдущее
От: Blake McBride
Дата:
Сообщение: [ODBC] JDBC ZonedDateTime problem
Следующее
От: "Nagumalli, Raghu"
Дата:
Сообщение: [ODBC] ODBC driver for Postgres Installation error