Re: Bug in TimestampUtils.java?

Поиск
Список
Период
Сортировка
От Richard Cook
Тема Re: Bug in TimestampUtils.java?
Дата
Msg-id 20061109223752.62560.qmail@web60221.mail.yahoo.com
обсуждение исходный текст
Ответ на Bug in TimestampUtils.java?  (Richard Cook <awhig@yahoo.com>)
Ответы Re: Bug in TimestampUtils.java?  (Oliver Jowett <oliver@opencloud.com>)
Re: Bug in TimestampUtils.java?  (imad <immaad@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "ludovic orban"
Дата:
Сообщение: Re: XA end then join fix for WebLogic
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: Bug in TimestampUtils.java?