TIMESTAMP value binary transfer problem

Поиск
Список
Период
Сортировка
От Vladimir Crnčić (Infoart d.o.o.)
Тема TIMESTAMP value binary transfer problem
Дата
Msg-id 001401cfedf0$2d861690$889243b0$@infoart.hr
обсуждение исходный текст
Ответы Re: TIMESTAMP value binary transfer problem  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-jdbc

There is a problem with JDBS driver interpretation of "timestamp without time zone" values when binary transfer is on. When binary transfer is disabled for TIMESTAMP columns (binaryTransferDisable=TIMESTAMP or binaryTransfer=false) problem does not occur.

 

database version: 9.1.1

driver version: 9.2, 9.3

 

BINARY TRANSFER:

----------------

database value (TIMESTAMP):                 2014-10-26 01:00:04

bytes (AbstractJdbc2Resultset):              [0, 1, -87, 71, -77, -6, 45, 0]

long value (TimestampUtils):                    467600404000000

java timestamp (TimestampUtils):          2014-10-26 02:00:04.0                   (not OK)

 

TEXT TRANSFER:

--------------

database value (TIMESTAMP):                                 2014-10-26 01:00:04

string value (AbstractJdbc2Resultset):                 2014-10-26 01:00:04

java timestamp (TimestampUtils):                         2014-10-26 01:00:04.0    (OK)

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

Предыдущее
От: Vitalii Tymchyshyn
Дата:
Сообщение: Re: Disk buffering of resultsets
Следующее
От: Tom Lane
Дата:
Сообщение: JDBC regression tests broken by latest timezone changes