bug report: preparedStatement.setObject(indx, "2004-August-15", java.sql.Types.DATE) generates number format exception

From: Floyd Shackelford <shackman(at)fwshackelford(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: bug report: preparedStatement.setObject(indx, "2004-August-15", java.sql.Types.DATE) generates number format exception
Date: 2007-02-14 19:03:28
Message-ID: 45D35D00.6020000@fwshackelford.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

bug report:

postgresql: 8.2.0
jdbc: postgresql-8.2-504.jdbc3.jar

the following generates a number format exception:
preparedStatement.setObject(indx,"2004-August-15",java.sql.Types.DATE)

the following works:
preparedStatement.setObject(indx,"2004-08-15",java.sql.Types.DATE)

i prefer to use the former.

--

Soli Deo gloria,

Floyd Shackelford

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Chris Gamache 2007-02-14 19:29:06 Re: stringtype=unspecified problem
Previous Message Kris Jurka 2007-02-14 17:57:17 Re: Synthesize support for Statement.getGeneratedKeys()?