Postgres Pro
Downloads
Home   >   mailing lists

Re: TIMESTAMP value binary transfer problem - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: TIMESTAMP value binary transfer problem
Date
Msg-id CADK3HHLSgLhmCuPE1BMS6v=YE5A27Vc=S2EPdw78pfYQda9TyQ@mail.gmail.com
Whole thread Raw
In response to TIMESTAMP value binary transfer problem  (Vladimir Crnčić (Infoart d.o.o.)<vcrncic@infoart.hr>)
Responses Re: TIMESTAMP value binary transfer problem  (John Lister <john.lister@kickstone.com>)
List pgsql-jdbc
Tree view
This is the same as https://github.com/pgjdbc/pgjdbc/pull/133

So what I am wondering is why a small number of people see this and the rest are fine ???

What is unique about your environment. Are the server and the client on the same timezone ?

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On 22 October 2014 14:03, Vladimir Crnčić (Infoart d.o.o.) <vcrncic@infoart.hr> wrote:

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 by date:

Previous
From: Dave Cramer
Date:
Subject: Re: JDBC regression tests broken by latest timezone changes
Next
From: John Lister
Date:
Subject: Re: TIMESTAMP value binary transfer problem