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: 1B3D5E532D18D311861A00600865478C9FE3@exchange1.nt.maidstone.gov.uk (view raw or flat)
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

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

-- 
Rachel



Responses

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-2014 The PostgreSQL Global Development Group