Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-1480

time zone info lost when using timestamp field

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Won't Fix
    • 1.2.3, 1.3.0, 2.0.0-M3, 2.0.0-beta
    • None
    • jdbc
    • None
    • at least DB2, Derby, Sybase

    Description

      Looks like OpenJPA always gets the time stamp out at the time zone of the machine, not the time zone that was used originally.

      The test case is putting in 2 TimeStamps
      TTimestamp = 4-3-2004 21:0:0.0 (America/New_York)
      TTimestampUTC = 4-4-2004 2:0:0.0 (UTC)

      When OpenJPA gets those 2 timesamps back out of the database, they are
      TTimestamp = 4-3-2004 21:0:0.0 (America/New_York)
      TTimestampUTC = 4-3-2004 21:0:0.0 (America/New_York)

      Attachments

        1. OPENJPA-1480-TestCalendarField.patch
          1 kB
          Barrett Jay Reed
        2. 1280-1.2.x.patch
          0.7 kB
          Barrett Jay Reed
        3. TZDataModel.java
          1 kB
          Barrett Jay Reed
        4. TestTimeZone.java
          11 kB
          Barrett Jay Reed

        Issue Links

          Activity

            People

              mikedd Michael Dick
              bjreed Barrett Jay Reed
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: