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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Floyd Shackelford <java2(at)fwshackelford(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2997: parse error: setObject("2004-August-15",java.sql.Types.DATE)
Date: 2007-02-14 17:16:25
Message-ID: 200702141716.l1EHGPd02210@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Floyd Shackelford wrote:
>
> 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.

OK, but we only support the later.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Magnus Hagander 2007-02-14 18:06:06 Re: BUG #2993: The program "postgres" is needed by initdb but was not found ...
Previous Message Ashwini 2007-02-14 16:43:46 BUG #3008: Unable to compile this for 32-bit