Thread: BUG #2997: parse error: setObject("2004-August-15",java.sql.Types.DATE)
BUG #2997: parse error: setObject("2004-August-15",java.sql.Types.DATE)
From
"Floyd Shackelford"
Date:
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.
Re: BUG #2997: parse error: setObject("2004-August-15",java.sql.Types.DATE)
From
Bruce Momjian
Date:
Floyd Shackelford wrote:
>
> 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.
OK, but we only support the later.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Re: BUG #2997: parse error: setObject("2004-August-15",java.sql.Types.DATE)
From
Bruce Momjian
Date:
Bruce Momjian wrote:
> Floyd Shackelford wrote:
> >
> > 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.
>
> OK, but we only support the later.
Well to be specific, PostgreSQL supports both:
test=> select '2004-August-15'::date;
date
------------
2004-08-15
(1 row)
but jdbc only supports the later, so I suggest you contact the jdbc
maintaners.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +