Thread

PostgreSQL BugTool Submission

PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2000-08-23T16:59:55Z

Gregg Wonderly (gregg@c2-tech.com) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
JDBC driver broken for ResultSet.getTimeStamp()

Long Description
The JDBC driver in 7.0.2 uses Timestamp.toString() to create the string representation of the timestamp to store into postgresql.
It should use Timestamp.valueOf(String) to go back to the native
Timestamp value.  However, it uses SimpleDateFormat.parse() instead
and this will not work correctly.  Parse Exceptions occur and the data can not be retrieved from the database as a Timestamp.

Sample Code


No file was uploaded with this report