Postgres Pro
Downloads
Home   >   mailing lists

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

From Floyd Shackelford
Subject BUG #2997: parse error: setObject("2004-August-15",java.sql.Types.DATE)
Date
Msg-id 200702130353.l1D3rqQc015537@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #2997: parse error: setObject("2004-August-15",java.sql.Types.DATE)  (Bruce Momjian <bruce@momjian.us>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      2997
Logged by:          Floyd Shackelford
Email address:      java2@fwshackelford.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.

pgsql-bugs by date:

Previous
From: "Anthony Taylor"
Date:
Subject: BUG #2996: to_char( timestamp, 'DD-Mon-YYYY HH24:MI:SS.MS' ) reports .1000 ms
Next
From: "laurent faillie"
Date:
Subject: BUG #3000: Linking problem