Re: [JDBC] Timestamps without time zone

Óôéò 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.

Thanx a lot,i'll try that right away.

>
> -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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings