ResultSet.getTimestamp() Exception - Mailing list pgsql-bugs

From Bill Bunting
Subject ResultSet.getTimestamp() Exception
Date
Msg-id 5.0.0.25.2.20001219145246.00a42910@pop.valueweb.net
Whole thread Raw
List pgsql-bugs
Version: Postgresql 7.0.3-2 (RPM for RedHat6.2)
JDBC Version: 7.0.3-2 (RPM for RedHat6.2)
Java Version: Sun build 1.3.0

Calls to ResultSet.getTimestamp(...) throw an exception and report the
following error:

"Bad Timestamp Format at 19 in 2000-12-18 12:31:15.77-05"

To reproduce:
1. Create a table using the TIMESTAMP SQL type.
2. Insert a row with a timestamp (using psql)
3. Use JDBC getTimestamp()

For use, this bug is severe since it prevents us from using the timestamps
in our EJB entity beans.

pgsql-bugs by date:

Previous
From: "Robert B. Easter"
Date:
Subject: Re: Backend dies when overloading + operator for bool
Next
From: Bill Bunting
Date:
Subject: ResultSet.getTimestamp() Exception (UPDATE)