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

Re: BUG #2997: parse error: setObject("2004-August-15",java.sql.Types.DATE)

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Floyd Shackelford <java2(at)fwshackelford(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2997: parse error: setObject("2004-August-15",java.sql.Types.DATE)
Date: 2007-02-14 18:57:18
Message-ID: 200702141857.l1EIvIC15935@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Bruce Momjian wrote:
> Floyd Shackelford wrote:
> > 
> > The following bug has been logged online:
> > 
> > Bug reference:      2997
> > Logged by:          Floyd Shackelford
> > Email address:      java2(at)fwshackelford(dot)com
> > PostgreSQL version: 8.2.0
> > Operating system:   windows xp
> > Description:        parse error:
> > setObject("2004-August-15",java.sql.Types.DATE)
> > Details: 
> > 
> > jdbc: postgresql-8.2-504.jdbc3.jar
> > 
> > this generates a number format exception:
> > preparedStatement.setObject(indx,"2004-August-15",java.sql.Types.DATE) 
> > 
> > this works: 
> > preparedStatement.setObject(indx,"2004-08-15",java.sql.Types.DATE)
> > 
> > i prefer to use the former.
> 
> OK, but we only support the later.

Well to be specific, PostgreSQL supports both:
	
	test=> select '2004-August-15'::date;
	    date
	------------
	 2004-08-15
	(1 row)

but jdbc only supports the later, so I suggest you contact the jdbc
maintaners.

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

pgsql-bugs by date

Next:From: Phil FrostDate: 2007-02-14 22:18:44
Subject: Segfaults and assertion failures with not too extraordinary views and queries
Previous:From: Magnus HaganderDate: 2007-02-14 18:06:06
Subject: Re: BUG #2993: The program "postgres" is needed by initdb but was not found ...

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