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.

View raw message