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

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 (view raw or flat)
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

pgsql-jdbc by date

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

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