Thread: bug?: java won't read timestamps

Hi there,

I have a table containing "timestamp with time zone" and I observed
a strange problem:

THE ENVIRONMENT:
    Linux 2.4.0
    Postgres 7.1.2
    JDK 1.3.1 (same with JDK 1.3.0)
    postgresql.jar from $PGHOME/share/java

THE TABLE:
                        Table "hits"
      Attribute   |           Type           | Modifier
    --------------+--------------------------+----------
     id           | integer                  |
     zeit         | timestamp with time zone |

THE PROGRAM:

    stmt = toDB.createStatement();
    ResultSet rs = stmt.executeQuery( "SELECT max(zeit) FROM hits" );
    rs.next();
    ts = rs.getTimestamp(1); // <-- breaks here
    stmt.close();

THE ERROR:

    Bad Timestamp Format at 19 in 2001-03-05 17:17:13.24+01

The second fraction seems not to be supported by the jdbc timestamp
reader. BTW: there is no format specifier for them as well (at least
in the docs).

I am helping myself by forcing a different output
    to_char(max(zeit),"YYYY-MM-DD HH24:MI:SS+01")
Is there a better solution?

(Is the relevant code in java.sql or is it in org.postgresql?)

With kind regards / Mit freundlichem Gruß
    Holger Klawitter
--
Holger Klawitter
holger@klawitter.de                             http://www.klawitter.de

Hi Dave,

Thanks for your hint. It was indeed a problem with an older postgresql.jar
sneaking into my classpath.

With kind regards / Mit freundlichem Gruß
    Holger Klawitter
--
Holger Klawitter
holger@klawitter.de                             http://www.klawitter.de

Which version of the driver are you using? This has historically been a
problem

The relevant code is in java.sql

Dave
----- Original Message -----
From: "Holger Klawitter" <holger@klawitter.de>
To: <pgsql-general@postgreSQL.org>
Sent: Wednesday, June 06, 2001 12:24 PM
Subject: [GENERAL] bug?: java won't read timestamps


> Hi there,
>
> I have a table containing "timestamp with time zone" and I observed
> a strange problem:
>
> THE ENVIRONMENT:
> Linux 2.4.0
> Postgres 7.1.2
> JDK 1.3.1 (same with JDK 1.3.0)
> postgresql.jar from $PGHOME/share/java
>
> THE TABLE:
>                     Table "hits"
>   Attribute   |           Type           | Modifier
> --------------+--------------------------+----------
> id           | integer                  |
> zeit         | timestamp with time zone |
>
> THE PROGRAM:
>
> stmt = toDB.createStatement();
> ResultSet rs = stmt.executeQuery( "SELECT max(zeit) FROM hits" );
> rs.next();
> ts = rs.getTimestamp(1); // <-- breaks here
> stmt.close();
>
> THE ERROR:
>
> Bad Timestamp Format at 19 in 2001-03-05 17:17:13.24+01
>
> The second fraction seems not to be supported by the jdbc timestamp
> reader. BTW: there is no format specifier for them as well (at least
> in the docs).
>
> I am helping myself by forcing a different output
> to_char(max(zeit),"YYYY-MM-DD HH24:MI:SS+01")
> Is there a better solution?
>
> (Is the relevant code in java.sql or is it in org.postgresql?)
>
> With kind regards / Mit freundlichem Gruß
>     Holger Klawitter
> --
> Holger Klawitter
> holger@klawitter.de                             http://www.klawitter.de
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>