Re: Bug in TimestampUtils.java? - Mailing list pgsql-jdbc

From Richard Cook
Subject Re: Bug in TimestampUtils.java?
Date
Msg-id 20061109223752.62560.qmail@web60221.mail.yahoo.com
Whole thread Raw
In response to Bug in TimestampUtils.java?  (Richard Cook <awhig@yahoo.com>)
Responses Re: Bug in TimestampUtils.java?
Re: Bug in TimestampUtils.java?
List pgsql-jdbc
Imad,

If you look at the source code for the postgres jdbc driver, it retrieves the column as a string, then uses the TimeStampUtils class to create a date or timestamp out of it. I think the driver is incorrectly setting the timezone when it creates the Date object.


From AbstractJdbc2ResultSet.java....

 public java.sql.Date getDate(int columnIndex) throws SQLException
    {
        return getDate(columnIndex, null);
    }


 public java.sql.Date getDate(int i, java.util.Calendar cal) throws SQLException
    {
        this.checkResultSet(i);

        if (cal != null)
            cal = (Calendar)cal.clone();

        return connection.getTimestampUtils().toDate(cal, getString(i));
    }




----- Original Message ----
From: imad <immaad@gmail.com>
To: Richard Cook <awhig@yahoo.com>
Cc: pgsql-jdbc@postgresql.org
Sent: Thursday, November 9, 2006 4:54:15 PM
Subject: Re: [JDBC] Bug in TimestampUtils.java?

On 11/10/06, Richard Cook <awhig@yahoo.com> wrote:
>
> Hi All,
>
> I recently ran into a problem that was partially caused by some behaviour I
> found in TimestampUtils.java.  To me it does not seem right...
>
> I retrieved a Timestamp Column from Postgres as a Date. The data in the
> database had a timezone of GMT -0500, the current time was also in GMT
> -0500. If you look at the date that is returned from resultSet.getDate() on
> a Timestamp column, the timezone for the Date object is -0400. I would think
> that it should be -0500.

I suggest you to confirm it with your database server. Try developing the same
scenario without JDBC and see what you get because connectors are not
supposed to play with the data they get. It is the server who formats everything
before sending it to the client.

--Imad
www.EnterpriseDB.com

pgsql-jdbc by date:

Previous
From: "ludovic orban"
Date:
Subject: Re: XA end then join fix for WebLogic
Next
From: Oliver Jowett
Date:
Subject: Re: Bug in TimestampUtils.java?