db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michelle Caisse (JIRA)" <j...@apache.org>
Subject [jira] Created: (JDO-480) Change SQL datatype of Date fields from VARCHAR to TIMESTAMP
Date Mon, 09 Apr 2007 20:24:32 GMT
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, employees, 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/conf/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.


Mime
View raw message