Skip site navigation (1) Skip section navigation (2)

Re: Timestamps without time zone

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Cc: Oliver Jowett <oliver(at)opencloud(dot)com>
Subject: Re: Timestamps without time zone
Date: 2008-01-09 13:42:46
Message-ID: 200801091544.56199.achill@matrix.gatewaynet.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Στις Wednesday 09 January 2008 15:05:24 ο/η Oliver Jowett έγραψε:
> Achilleas Mantzios wrote:
> >> Which driver version are you using?
> >
> > Its the 7.4.19 built from source.
>
> Ah, there is your problem then. That is a very old driver and had
> problems with exactly the case you're trying to use (setTimestamp() with
> a Calendar), amongst many other bugs.
>
> Can you try a recent driver and see if it fixes your problem? Looking at
> CVS history it looks like 8.1 is the earliest driver with
> timezone-related fixes, but I'd suggest you try the most recent stable
> driver.
>
> Newer drivers will still talk to older servers, so you shouldn't need to
> upgrade your server to test this.

I tried with postgresql-8.2-507.jdbc3.jar, and it works like a charm!
Not only that, but the getTimestamp() too! I was starting to question my night 
sleep quality, read old lenghty articles about java dates/timezones etc!!
Thank you a lot! I didnt know jdbc newer versions were backward compatible 
with older servers.

Just a comment:
Why not merge from current changes/bugfixes to the JDBC?
I mean 7.4 is old ok, but *officially supported* also!

>
> -O
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match



-- 
Achilleas Mantzios

In response to

Responses

pgsql-jdbc by date

Next:From: Leonel NunezDate: 2008-01-09 14:06:51
Subject: Re: How to Install PostgerSQL_Driver ( in tomcat ) ?
Previous:From: Achilleas MantziosDate: 2008-01-09 13:12:25
Subject: Re: Timestamps without time zone

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group