Community
Participate
Working Groups
Lots of jpa oracle specific tests failed on oracle 10.2.0.4 since revision 8074, I have verified that the tests passed with previous revision 8072, it seems that the changes Andrei made on Aug 23rd as fix of bug 323420 caused the regression. The typical failed test and error: org.eclipse.persistence.testing.tests.types.WriteTypeObjectTest.WriteTypeObjectTest(class org.eclipse.persistence.testing.tests.types.TIMESTAMPDirectToFieldTester) Exception Description: calToTSTZ.compareTo(fromDatabase.getCalToTSTZ()) == -1 original calToTSTZ = 1900-01-01 00:00:00.0 GMT fromDatabase.calToTSTZ = java.util.GregorianCalendar[time=-2208970800000,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=3600000,useDaylight=true,transitions=149,lastRule=java.util.SimpleTimeZone[id=GMT,offset=0,dstSavings=3600000,useDaylight=true,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTime=7200000,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,endTime=7200000,endTimeMode=0]],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=1900,MONTH=0,WEEK_OF_YEAR=1,WEEK_OF_MONTH=1,DAY_OF_MONTH=1,DAY_OF_YEAR=1,DAY_OF_WEEK=2,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=-18000000,DST_OFFSET=0] Internal Exception: Exception [EclipseLink-0] (Eclipse Persistence Services - 2.2.0.qualifier): org.eclipse.persistence.testing.framework.TestErrorException Exception Description: The object inserted into the database, 'ZERO 1 -> 1900-01-01 00:00:00.0 GMT' does not match the original, 'ZERO 1 -> 1900-01-01 00:00:00.0 GMT'. Local Exception Stack: Exception [EclipseLink-0] (Eclipse Persistence Services - 2.2.0.qualifier): org.eclipse.persistence.testing.framework.TestErrorException Exception Description: calToTSTZ.compareTo(fromDatabase.getCalToTSTZ()) == -1 original calToTSTZ = 1900-01-01 00:00:00.0 GMT fromDatabase.calToTSTZ = java.util.GregorianCalendar[time=-2208970800000,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=3600000,useDaylight=true,transitions=149,lastRule=java.util.SimpleTimeZone[id=GMT,offset=0,dstSavings=3600000,useDaylight=true,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTime=7200000,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,endTime=7200000,endTimeMode=0]],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=1900,MONTH=0,WEEK_OF_YEAR=1,WEEK_OF_MONTH=1,DAY_OF_MONTH=1,DAY_OF_YEAR=1,DAY_OF_WEEK=2,DAY_OF_WEEK_IN_MONTH=1,AM_PM=0,HOUR=0,HOUR_OF_DAY=0,MINUTE=0,SECOND=0,MILLISECOND=0,ZONE_OFFSET=-18000000,DST_OFFSET=0] Internal Exception: Exception [EclipseLink-0] (Eclipse Persistence Services - 2.2.0.qualifier): org.eclipse.persistence.testing.framework.TestErrorException Exception Description: The object inserted into the database, 'ZERO 1 -> 1900-01-01 00:00:00.0 GMT' does not match the original, 'ZERO 1 -> 1900-01-01 00:00:00.0 GMT'. at org.eclipse.persistence.testing.tests.types.TIMESTAMPTester.verify(TIMESTAMPTester.java:502) at org.eclipse.persistence.testing.tests.types.WriteTypeObjectTest.verify(WriteTypeObjectTest.java:80) at org.eclipse.persistence.testing.framework.TestCase.execute(TestCase.java:157) at org.eclipse.persistence.testing.framework.TestCase.runBare(TestCase.java:265) at org.eclipse.persistence.testing.framework.TestExecutor.execute(TestExecutor.java:248) at org.eclipse.persistence.testing.framework.TestSuite.execute(TestSuite.java:75) at org.eclipse.persistence.testing.framework.TestCollection.run(TestCollection.java:313) at org.eclipse.persistence.testing.framework.TestExecutor.execute(TestExecutor.java:248) at org.eclipse.persistence.testing.framework.TestModel.execute(TestModel.java:208) at org.eclipse.persistence.testing.framework.TestCollection.run(TestCollection.java:313) at org.eclipse.persistence.testing.framework.TestExecutor.execute(TestExecutor.java:248) at org.eclipse.persistence.testing.framework.TestModel.execute(TestModel.java:208) at org.eclipse.persistence.testing.framework.TestCollection.run(TestCollection.java:313) Caused by: Exception [EclipseLink-0] (Eclipse Persistence Services - 2.2.0.qualifier): org.eclipse.persistence.testing.framework.TestErrorException Exception Description: The object inserted into the database, 'ZERO 1 -> 1900-01-01 00:00:00.0 GMT' does not match the original, 'ZERO 1 -> 1900-01-01 00:00:00.0 GMT'. at org.eclipse.persistence.testing.framework.WriteObjectTest.verify(WriteObjectTest.java:268) at org.eclipse.persistence.testing.tests.types.WriteTypeObjectTest.superVerify(WriteTypeObjectTest.java:64) at org.eclipse.persistence.testing.tests.types.TypeTester.verify(TypeTester.java:79) at org.eclipse.persistence.testing.tests.types.TIMESTAMPTester.verify(TIMESTAMPTester.java:377)
Created attachment 177961 [details] suggested patch. This is a test issue. In bug 323420 I simplified in TIMESTAMPTester verification check for calToTSLTZ (calendar written into TIMESTAMPTZ, then read back should be the same). That worked when Timestamp obtained from TIMESTAMPTZ is in GMT (11.1.0.7 and later); but didn't work otherwise. Now the test checks isTimestampInGmt and uses the new approach if it is, and the old approach otherwise.
Checked the patch into trunk, 2.1.2 is pending.
Checked the patch into 2.1.2.
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink
