Bug 353037

Description Kevin Yuan 2011-07-25 15:38:32 EDT

SQLServer: 2008
JDK: 1.6.0_24

There are the following two JPA tests failed on SQL Server 2008 DB:

1. jpa.advanced.PessimisticLockingExtendedScopeTestSuite.testPESSMISTIC_ES6:
   ========================================================================

other transaction modified row concurrently

junit.framework.AssertionFailedError: other transaction modified row concurrently
at org.eclipse.persistence.testing.tests.jpa.advanced.PessimisticLockingExtendedScopeTestSuite$6.check(PessimisticLockingExtendedScopeTestSuite.java:307)
at org.eclipse.persistence.testing.tests.jpa.advanced.PessimisticLockingExtendedScopeTestSuite$6.check(PessimisticLockingExtendedScopeTestSuite.java:283)
at org.eclipse.persistence.testing.tests.jpa.advanced.PessimisticLockingExtendedScopeTestSuite.testNonrepeatableRead(PessimisticLockingExtendedScopeTestSuite.java:379)
at org.eclipse.persistence.testing.tests.jpa.advanced.PessimisticLockingExtendedScopeTestSuite.testPESSMISTIC_ES6(PessimisticLockingExtendedScopeTestSuite.java:312)
at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:555)

2. jpa.composite.advanced.EntityManagerJUnitTestSuite.testEMCloseAndOpen:
   =====================================================================

Exception Description: Error preallocating sequence numbers. The sequence table information is not complete.

Local Exception Stack:
Exception [EclipseLink-4011] (Eclipse Persistence Services - 2.4.0.qualifier): org.eclipse.persistence.exceptions.DatabaseException
Exception Description: Error preallocating sequence numbers. The sequence table information is not complete.
at org.eclipse.persistence.exceptions.DatabaseException.errorPreallocatingSequenceNumbers(DatabaseException.java:143)
at org.eclipse.persistence.sequencing.StandardSequence.getGeneratedValue(StandardSequence.java:63)
at org.eclipse.persistence.sequencing.Sequence.getGeneratedValue(Sequence.java:225)
at org.eclipse.persistence.internal.sequencing.SequencingManager$NoPreallocation_State.getNextValue(SequencingManager.java:677)
at org.eclipse.persistence.internal.sequencing.SequencingManager.getNextValue(SequencingManager.java:1067)
at org.eclipse.persistence.internal.sequencing.SequencingManager.getNextValue(SequencingManager.java:266)
at org.eclipse.persistence.internal.sessions.AbstractSession.getNextSequenceNumberValue(AbstractSession.java:2358)
at org.eclipse.persistence.testing.tests.jpa.composite.advanced.EntityManagerJUnitTestSuite.testEMCloseAndOpen(EntityManagerJUnitTestSuite.java:8479)
at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:555)