Thread: PostgreSQL BugTool Submission

PostgreSQL BugTool Submission

From
pgsql-bugs@postgresql.org
Date:
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