Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[eclipselink-dev] Fix for bug 249500 - Daylight savings time is not printed in native SQL run against Oracle 9i and above


The following fix has been checked in, and was previously reviewed.

Bug 249500 - Daylight savings time is not printed in native SQL run against Oracle 9i and above

https://bugs.eclipse.org/bugs/show_bug.cgi?id=249500
(a patch file has been uploaded to this bug)

Foundation changes:
- Added TIMESTAMPHelper.shouldAppendDaylightTime() method to return true if a passed Calendar represents Timestamp and TimeZone data which is currently within daylight savings time (DST)
- Modified Oracle9Platform.appendCalendar() and Oracle9Platform.printCalendar() to append a 'TZD' element and short timezone DST information within the generated SQL if the call to TIMESTAMPHelper.shouldAppendDaylightTime() returns true

Testing changes:
- Added regression test CalendarDaylightSavingsTest to OracleTIMESTAMPTypeTestModel to test that generated SQL is correct for a variety of timezones and dates, including timezones that have never used DST and timezones that no longer use DST
- Refactored OracleTIMESTAMPTypeTestModel.getTIMESTAMPUsingNativeSQLTestSuite() specifically to use dates +/- 10 years in the future/past instead of +/- 100
- Typographical error fixes

Code review:
Not required (previously reviewed by James Sutherland)

Testing:
LRG
Oracle tests

--
Oracle Email Signature Logo
David Minsky | Senior Member of Technical Staff | (613) 288-4605
Oracle Server Technologies | Sustaining Engineering
45 O'Connor Street, Suite 400, Ottawa, Ontario, Canada K1P 1A4

Back to the top