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

Re: ResultSet.getDate failure with timestamp column

From: "Daniel Germain" <daniel(dot)germain(at)gipsynet(dot)com>
To: "Barry Lind" <barry(at)xythos(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: ResultSet.getDate failure with timestamp column
Date: 2001-11-09 13:50:43
Message-ID: CBEDKGKJPKEBDJECDAGLIEOICDAA.daniel.germain@gipsynet.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,

diff -c "c:/postgresql/ResultSet.java.orig" "c:/postgresql/ResultSet.java"
*** c:/postgresql/ResultSet.java.orig	Wed Nov 07 14:37:52 2001
--- c:/postgresql/ResultSet.java	Fri Nov 09 08:46:30 2001
***************
*** 1554,1560 ****
  	{
  		if (s == null)
  			return null;
! 		return java.sql.Date.valueOf(s);
  	}

  	public static Time toTime(String s) throws SQLException
--- 1554,1566 ----
  	{
  		if (s == null)
  			return null;
! 		// length == 10: SQL Date
! 		// length >  10: SQL Timestamp, assumes PGDATESTYLE=ISO
! 		try {
! 		   return java.sql.Date.valueOf((s.length() == 10) ? s :
s.substring(0,10));
! 		} catch (NumberFormatException e) {
! 		   throw new PSQLException("postgresql.res.baddate", s);
! 		}
  	}

  	public static Time toTime(String s) throws SQLException

Diff finished at Fri Nov 09 08:47:03

Daniel

> -----Original Message-----
> From: Barry Lind [mailto:barry(at)xythos(dot)com]
> Sent: November 8, 2001 10:50 PM
> To: Daniel Germain
> Cc: pgsql-jdbc(at)postgresql(dot)org
> Subject: Re: ResultSet.getDate failure with timestamp column
>
>
> Daniel,
>
> You are correct.  Version 1.29 backed out the previous fix.  I will fix
> this when I get a chance (unless you want to submit a patch and save me
> some time?).
>
> thanks,
> --Barry
>
> Daniel Germain wrote:
>
> > 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
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> >
> >
>
>



In response to

Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2001-11-09 14:18:56
Subject: Re: Constant "JTable" update
Previous:From: Per-Olof NorénDate: 2001-11-09 13:05:21
Subject: Re: Constant "JTable" update

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