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] Resolved: (JDO-480) Change SQL datatype of Date fields from VARCHAR to TIMESTAMP
Date Mon, 09 Apr 2007 20:45:32 GMT

     [ https://issues.apache.org/jira/browse/JDO-480?page=com.atlassian.jira.plugin.system.issuetabpanels: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, 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