| Michelle Caisse (JIRA) 2007-04-10, 1:11 am |
|
[ https://issues.apache.org/jira/brow...ls:all-tabpanel ]
Michelle Caisse resolved JDO-480.
---------------------------------
Resolution: Fixed
Fixed with revision: 526905
> Change SQL datatype of Date fields from VARCHAR to TIMESTAMP
> ------------------------------------------------------------
>
> Key: JDO-480
> URL: https://issues.apache.org/jira/browse/JDO-480
> Project: JDO
> Issue Type: Improvement
> Components: tck2
> Reporter: Michelle Caisse
> Assigned To: Michelle Caisse
> Priority: Minor
> Fix For: JDO 2 maintenance release 1
>
>
> The Date fields in the company model are currently mapped to columns of type VARCHAR(32). It is better practice to use a TIMESTAMP column for these fields. The affected columns are companies.FOUNDEDDATE, and BIRTHDATE, and HIREDATE in persons, employe
es, parttimeemployees, and/of fulltimeemployees tables.
> Note that there is a regression in the current JPOX SNAPSHOT that causes all of the company model CompletenessTest tests to fail with a 12 hour difference between actual and expected Dates in these fields. The affected tests are invoked with the src/co
nf/company*.conf configuration files. These tests pass with the current schema (VARCHAR(32) columns) on JPOX 1.1.7. After this change is checked in, these tests will pass on the JPOX SNAPSHOT.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
|