BUG #2997: parse error: setObject("2004-August-15", java.sql.Types.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. +

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. +