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
Views: Raw Message | Whole Thread | Download mbox
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

Browse pgsql-bugs by date

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