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

RE: [INTERFACES] JDBC6.5-1.2 bug wrt timestamp

From: Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk>
To: "'Rachel Greenham'" <rachel(at)enlarion(dot)demon(dot)co(dot)uk>, pgsql-interfaces(at)postgresql(dot)org
Subject: RE: [INTERFACES] JDBC6.5-1.2 bug wrt timestamp
Date: 1999-06-24 14:41:41
Message-ID: (view raw or whole thread)
Lists: pgsql-interfaces
The getTimestamp() method is broken - it gets confused for any time zone
outside of GMT/BST. I've been given a patch for it, which I'm looking at
and should have committed by the weekend.


Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.

-----Original Message-----
From: Rachel Greenham [mailto:rachel(at)enlarion(dot)demon(dot)co(dot)uk]
Sent: Thursday, June 24, 1999 2:05 PM
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: [INTERFACES] JDBC6.5-1.2 bug wrt timestamp

I've just come across a bug in the latest JDBC driver for JDK1.2.

Given a field in the database which is of type timestamp, I've been
retrieving the value using ResultSet.getTimestamp("col") eg:

Date d = rs.getTimeStamp("col");

This has been fine under JDBC6.4

The error I get is: 

Could not execute query (Bad Timestamp Format at 1999-06-09
15:34:05Africa/Algiers in {2}) 

The value in the database as seen by getString() is:

1999-06-29 00:00:00+01

The system timezone is set to "Europe/London".

OK, the first thing is that the Africa/Algiers bit seem to be a JVM
problem - ie: TimeZone.getDefault() returns timezone id "Africa/Algiers"
on my system, which is configured for "Europe/London". I'll be chasing
that separately.

Unfortunately, I couldn't override because
ResultSet.getTimestamp(String, TimeZone) hasn't been implemented yet
(that's the error I get anyway) but I also suspect from the above error
that it wouldn't work anyway.

For the time being I'm just getting the value as a String and parsing it
by hand.



pgsql-interfaces by date

Next:From: Tom LaneDate: 1999-06-24 15:00:28
Subject: Re: [INTERFACES] Peculiar behaviour in libpq
Previous:From: Peter MountDate: 1999-06-24 14:38:39
Subject: RE: [INTERFACES] JDBC6.5-1.2 other possible problems

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