Skip site navigation (1) Skip section navigation (2)

ResultSet.getDate failure with timestamp column

From: "Daniel Germain" <daniel(dot)germain(at)gipsynet(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: ResultSet.getDate failure with timestamp column
Date: 2001-11-07 19:00:32
Message-ID: CBEDKGKJPKEBDJECDAGLAEOBCDAA.daniel.germain@gipsynet.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,

I'm trying to migrate an existing application to postgresql
that uses generated code for accessing the database layer.

I search the mailing list and found other references to that problem
which seems to have been fixed in Revision 1.26 of ResultSet.java
and seems to be removed in Revision 1.29

Here is the stack trace with the DevelopmentDriver 7.2dev (built 2001-10-31)

java.lang.NumberFormatException: 04 00:00:00-04
	at java.lang.Integer.parseInt(Integer.java:414)
	at java.lang.Integer.parseInt(Integer.java:454)
	at java.sql.Date.valueOf(Date.java:91)
	at org.postgresql.jdbc2.ResultSet.toDate(ResultSet.java:1557)
	at org.postgresql.jdbc2.ResultSet.getDate(ResultSet.java:372)
	at org.postgresql.jdbc2.ResultSet.getDate(ResultSet.java:607)


Any good reason why it was removed? It seems to be contrary to the
spec from what I read in this mailing list.

Thanks

Daniel



Responses

pgsql-jdbc by date

Next:From: Bruce MomjianDate: 2001-11-07 19:14:54
Subject: Re: MD5-based passwords
Previous:From: Barry LindDate: 2001-11-07 18:39:39
Subject: Re: Memory exeception

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group