Обсуждение: date problem with postgres JDBC 7.1 driver

    (I'm not subscribed to the list, please cc directly in replies)

    We have an application using the jdbc driver from postgres
    7.0.x, compiled under java1. We have migrated the database
    to 7.1.2, and would like to update the jdbc driver to match.

    The application selects() a timestamp as a date, which
    works fine under the earlier JDBC, and other databases such
    as MS SQLserver, but fails with a NumberFormatException under
    the new driver.

    Can anyone confirm if this is correct JDBC behaviour (in which
    case I have to persuade our developers to update their code :)

    Sample code appended.

    Thanks


--
        David/absolute        abs@formula1.com

import java.math.*;
import java.sql.*;
import java.util.*;

/*
CREATE TABLE Race
( RaceId        int           NOT NULL,
  RaceDate      timestamp     NOT NULL,
  CONSTRAINT PK_Race PRIMARY KEY (RaceId)
);

INSERT INTO Race VALUES (195001, '1950-05-13');

Output after running with earlier class files:
Race Id = 195001
Race Date as Timestamp = 1950-05-13 00:00:00.0
Race Date as Date = 1950-05-13


Output after running with newest class files:
Race Id = 195001
Race Date as Timestamp = 1950-05-13 00:00:00.0
java.lang.NumberFormatException: 13 00:00:00+01
        at java.lang.Integer.parseInt(Unknown Source)
        at java.lang.Integer.parseInt(Unknown Source)
        at java.sql.Date.valueOf(Unknown Source)
        at org.postgresql.jdbc2.ResultSet.getDate(ResultSet.java:427)
        at org.postgresql.jdbc2.ResultSet.getDate(ResultSet.java:665)
        at Remote.main(Remote.java:33)

*/

public class Remote
{
    public static void main(String args[])
    {
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;

        try
        {
            Class.forName("org.postgresql.Driver");
            conn = DriverManager.getConnection("jdbc:postgresql://wopr:5432/f1archive", "tom", "");
            ps = conn.prepareStatement("SELECT RaceId, RaceDate FROM Race WHERE RaceId = 195001;");
            rs = ps.executeQuery();
            while (rs.next())
            {
                System.out.println("Race Id = " + rs.getInt("RaceId"));
                System.out.println("Race Date as Timestamp = " + rs.getTimestamp("RaceDate"));
                System.out.println("Race Date as Date = " + rs.getDate("RaceDate"));
            }
        }

        catch(Exception e)
        {
            e.printStackTrace();
        }
        finally
        {
            try
            {
                if (rs != null)
                    rs.close();
                if (ps != null)
                    ps.close();
                if (conn != null)
                    conn.close();
            }
            catch(SQLException e) {}
        }
    }

}

David,

This is a problem in the driver.  I believe it is fixed in current
sources.  Can you download the latest development build from
jdbc.postgresql.org and see if that works for you?

thanks,
--Barry

David Brownlee wrote:

>     (I'm not subscribed to the list, please cc directly in replies)
>
>     We have an application using the jdbc driver from postgres
>     7.0.x, compiled under java1. We have migrated the database
>     to 7.1.2, and would like to update the jdbc driver to match.
>
>     The application selects() a timestamp as a date, which
>     works fine under the earlier JDBC, and other databases such
>     as MS SQLserver, but fails with a NumberFormatException under
>     the new driver.
>
>     Can anyone confirm if this is correct JDBC behaviour (in which
>     case I have to persuade our developers to update their code :)
>
>     Sample code appended.
>
>     Thanks
>
>
>

    Sorry for the delay in responding. Can confirm this is fixed in
    7.2dev (2001-12-10).

    Is there an expected release date for the next version yet?

    Thanks

--
        David/absolute        abs@formula1.com

On Thu, 11 Oct 2001, Barry Lind wrote:

> David,
>
> This is a problem in the driver.  I believe it is fixed in current
> sources.  Can you download the latest development build from
> jdbc.postgresql.org and see if that works for you?
>
> thanks,
> --Barry
>
> David Brownlee wrote:
>
> >     (I'm not subscribed to the list, please cc directly in replies)
> >
> >     We have an application using the jdbc driver from postgres
> >     7.0.x, compiled under java1. We have migrated the database
> >     to 7.1.2, and would like to update the jdbc driver to match.
> >
> >     The application selects() a timestamp as a date, which
> >     works fine under the earlier JDBC, and other databases such
> >     as MS SQLserver, but fails with a NumberFormatException under
> >     the new driver.
> >
> >     Can anyone confirm if this is correct JDBC behaviour (in which
> >     case I have to persuade our developers to update their code :)
> >
> >     Sample code appended.
> >
> >     Thanks
> >
> >
> >
>
>
>

On Wed, 19 Dec 2001 12:14:39 +0000 (GMT), you wrote:
>Can confirm this is fixed in 7.2dev (2001-12-10).
>Is there an expected release date for the next version yet?

7.2 is currently in the final beta stage, so it should be
released Real Soon Now.

Regards,
René Pijlman <rene@lab.applinet.nl>