Re: Bug in JDBC-Driver? - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Bug in JDBC-Driver?
Date
Msg-id Pine.BSO.4.56.0412220622250.11565@leary.csoft.net
Whole thread Raw
In response to Re: Bug in JDBC-Driver?  ("Barry Lind" <blind@xythos.com>)
Responses Re: Bug in JDBC-Driver?  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc

On Mon, 20 Dec 2004, Barry Lind wrote:

> I haven't been closely following this thread so I may be completely off
> base here.  But wouldn't having both java and the server using the same
> known timezone have the same effect?  So if you were to set the timezone
> to GMT in both the client and server, timestamps could then be passed
> correctly.
>

I initially thought this was a great idea, but it breaks down when they
don't use a PreparedStatement and generate a query directly, then we can't
intervene and adjust things.  The advantage of setting the server to the
client's timezone is that this will work as expected.

Kris Jurka

pgsql-jdbc by date:

Previous
From: "Xavier Poinsard"
Date:
Subject: Re: Patch to reduce the number of messages to translate
Next
From: Kris Jurka
Date:
Subject: Re: [BUGS] BUG #1347: Bulk Import stopps after a while (