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

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

From: "Floyd Shackelford" <java2(at)fwshackelford(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2997: parse error: setObject("2004-August-15",java.sql.Types.DATE)
Date: 2007-02-13 03:53:52
Message-ID: 200702130353.l1D3rqQc015537@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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.

Responses

pgsql-bugs by date

Next:From: MichaelDate: 2007-02-13 05:22:01
Subject: BUG #2998: Installation Failed due to Permissions
Previous:From: Bruce MomjianDate: 2007-02-13 02:01:19
Subject: Re: [BUGS] wrong behavior using to_char()

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