Re: ResultSet#xxxTimestamp for DATE column unexpected behavior - Mailing list pgsql-jdbc

From dircha
Subject Re: ResultSet#xxxTimestamp for DATE column unexpected behavior
Date
Msg-id 1127426809.877.243552739@webmail.messagingengine.com
Whole thread Raw
In response to Re: ResultSet#xxxTimestamp for DATE column unexpected behavior  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: ResultSet#xxxTimestamp for DATE column unexpected behavior
List pgsql-jdbc
On Thu, 22 Sep 2005 09:50:58 +1200, "Oliver Jowett"
<oliver@opencloud.com> said:
> dircha wrote:
>
> > pgsql-jdbc version: postgres80-312-jdbc2.jar
>
> Please try the current CVS driver -- I made a number of fixes to
> timestamp handling in CVS recently.

I built the latest pgsql-jdbc from cvs HEAD and ran the previously
described tests again.

Both issues I mentioned appear to have been fixed; the behavior is
as expected.

Great.

Is there any word yet on which official build these changes might be
expected to be present in, in terms of the labeling used on the pgsql-
jdbc downloads page? Will there be another 8.0-xxx.jdbc3.jar, or would
these changes go into a forthcoming stable 8.1-xxx.jdbc3.jar?

For reference, the updated results of the previously described test
are below.

Thanks!

--dircha


-------BEGIN TEST DATE AS TIMESTAMP-----------
- Creating test.

- Inserting '2000-1-1' into test.

Retrieving date from test: 2000-01-01

Retrieving timestamp from test: 2000-01-01 00:00:00.0

Updating test with retrieved timestamp

Retrieving date from test: 2000-01-01

-------END TEST DATE AS TIMESTAMP------------------BEGIN TEST DATE AS
TIMESTAMP-----------
- Creating test.

- Inserting '3000-1-1' into test.

Retrieving date from test: 3000-01-01

Retrieving timestamp from test: 3000-01-01 00:00:00.0

Updating test with retrieved timestamp

Retrieving date from test: 3000-01-01

-------END TEST DATE AS TIMESTAMP----------- DONE

pgsql-jdbc by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: [Fwd: Re: JDBC driver bug?]
Next
From: "Karl von Randow"
Date:
Subject: getColumnClassName() and getObject() types differ for smallint