Re: Bug in JDBC-Driver?

From: Kris Jurka <books(at)ejurka(dot)com>
To: Barry Lind <blind(at)xythos(dot)com>
Cc: Antje(dot)Stejskal(at)ppi(dot)de, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Bug in JDBC-Driver?
Date: 2004-12-22 11:26:44
Message-ID: Pine.BSO.4.56.0412220622250.11565@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2004-12-22 11:31:49 Re: [BUGS] BUG #1347: Bulk Import stopps after a while (
Previous Message Kris Jurka 2004-12-21 21:35:25 Re: CallableStatement: java.sql.Types=12 however type