Testsuite: oracle.toplink.essentials.testing.tests.FullRegressionTestSuite
Tests run: 470, Failures: 1, Errors: 4, Time elapsed: 181.972 sec
------------- Standard Output ---------------
[null, null, null, null, null, null, null, null, null]
[TopLink Warning]: 2006.06.27 04:09:00.117--ServerSession(7741108)--property toplink.platform.class.name is obsolete, property toplink.target-database should be used instead.
[TopLink Warning]: 2006.06.27 04:09:00.688--ServerSession(9484473)--property toplink.platform.class.name is obsolete, property toplink.target-database should be used instead.
[TopLink Warning]: 2006.06.27 04:09:01.359--ServerSession(15213980)--property toplink.platform.class.name is obsolete, property toplink.target-database should be used instead.
------------- ---------------- ---------------

Testcase: testNamedNativeQuery took 0.042 sec
Testcase: testPersistThenRemoveCalls took 0.246 sec
Testcase: testRemoveUnmanagedNewEntity took 0.053 sec
Testcase: testPersistOnRegisteredObject took 0.054 sec
Testcase: testPreUpdateEvent_UpdateAltered took 0.065 sec
Testcase: testPreUpdateEvent_UpdateReverted took 0.066 sec
Testcase: testRefreshNotManaged took 0.009 sec
Testcase: testRefreshRemoved took 0.112 sec
Testcase: testContainsRemoved took 0.035 sec
Testcase: testFlushModeEmAutoQueryCommit took 0.028 sec
Testcase: testFlushModeEmAuto took 0.026 sec
Testcase: testFlushModeEmAutoQueryAuto took 0.036 sec
Testcase: testFlushModeEmCommitQueryCommit took 0.014 sec
Testcase: testFlushModeEmCommit took 0.015 sec
Testcase: testFlushModeEmCommitQueryAuto took 0.025 sec
Testcase: testFlushModeOnUpdateQuery took 0.084 sec
Testcase: testSetRollbackOnly took 0.072 sec
Testcase: testSubString took 0.048 sec
Testcase: testDatabaseSyncNewObject took 0.012 sec
Testcase: testTransactionRequired took 0.006 sec
Testcase: testIgnoreRemovedObjectsOnDatabaseSync took 0.151 sec
Testcase: testREADLock took 0.046 sec
Testcase: testPersistRemoved took 0.966 sec
Testcase: testPersistManagedException took 0.029 sec
Testcase: testPersistManagedNoException took 0.037 sec
Testcase: testRemoveFlushPersistContains took 0.06 sec
Testcase: testRemoveFlushFind took 0.063 sec
Testcase: testFindWithWrongTypePk took 0.001 sec
Testcase: testCheckVersionOnMerge took 0.025 sec
Testcase: testClear took 0.029 sec
Testcase: testClearWithFlush took 0.065 sec
Testcase: testClearInTransaction took 0.027 sec
Testcase: testExtendedPersistenceContext took 0.248 sec
Testcase: testReadTransactionIsolation_CustomUpdate took 0.06 sec
Testcase: testReadTransactionIsolation_CustomUpdate_Flush took 0.066 sec
Testcase: testReadTransactionIsolation_CustomUpdate_Refresh took 0.072 sec
Testcase: testReadTransactionIsolation_CustomUpdate_Refresh_Flush took 0.065 sec
Testcase: testReadTransactionIsolation_UpdateAll took 0.074 sec
Testcase: testReadTransactionIsolation_UpdateAll_Flush took 0.077 sec
Testcase: testReadTransactionIsolation_UpdateAll_Refresh took 0.078 sec
Testcase: testReadTransactionIsolation_UpdateAll_Refresh_Flush took 0.09 sec
Testcase: testReadTransactionIsolation_OriginalInCache_CustomUpdate took 0.06 sec
Testcase: testReadTransactionIsolation_OriginalInCache_CustomUpdate_Flush took 0.072 sec
Testcase: testReadTransactionIsolation_OriginalInCache_CustomUpdate_Refresh took 0.078 sec
Testcase: testReadTransactionIsolation_OriginalInCache_CustomUpdate_Refresh_Flush took 0.083 sec
Testcase: testReadTransactionIsolation_OriginalInCache_UpdateAll took 0.059 sec
Testcase: testReadTransactionIsolation_OriginalInCache_UpdateAll_Flush took 0.06 sec
Testcase: testReadTransactionIsolation_OriginalInCache_UpdateAll_Refresh took 0.077 sec
Testcase: testReadTransactionIsolation_OriginalInCache_UpdateAll_Refresh_Flush took 0.09 sec
Testcase: testFindDeleteAllPersist took 0.132 sec
Testcase: testWRITELock took 0.042 sec
Testcase: testEMFWrapValidationException took 0.02 sec
Testcase: testEMDefaultTxType took 0.368 sec
	FAILED
Exception caught while creating EM with no "transaction-type" specified in persistence.xml
junit.framework.AssertionFailedError: Exception caught while creating EM with no "transaction-type" specified in persistence.xml
	at oracle.toplink.essentials.testing.tests.cmp3.advanced.EntityManagerJUnitTestSuite.testEMDefaultTxType(EntityManagerJUnitTestSuite.java:1715)
	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
	at junit.extensions.TestSetup.run(TestSetup.java:23)

Testcase: testPersistOnNonEntity took 0.001 sec
Testcase: testClose took 0 sec
Testcase: testBeginTransactionClose took 0 sec
Testcase: testBeginTransactionCloseCommitTransaction took 0.227 sec
Testcase: testPersistenceProperties took 0.001 sec
Testcase: testMultipleFactories took 3.145 sec
Testcase: testParallelMultipleFactories took 0.001 sec
Testcase: testQueryHints took 0.001 sec
Testcase: testNullifyAddressIn took 0.015 sec
Testcase: testLeftJoinOneToOneQuery took 0.012 sec
Testcase: testInheritanceNoDiscriminatorColumn took 0.017 sec
Testcase: testComplicateResultWithInheritance took 0.095 sec
Testcase: testRefresh took 0.103 sec
Testcase: testBindParameters took 0.012 sec
Testcase: testBindParametersWithPostitional took 0.01 sec
Testcase: testSimpleInheritance took 0.037 sec
Testcase: testPessimisticLocking took 0.03 sec
Testcase: testComplicateResults took 0.022 sec
Testcase: testProjectJoinTeamMembers took 0.737 sec
Testcase: testProjectJoinTeamLeaderJoinAddressWhereTeamLeaderNotNull took 0.872 sec
Testcase: testProjectJoinTeamMembersJoinAddress took 0.716 sec
Testcase: testProjectOuterJoinTeamMembersJoinAddress took 0.575 sec
Testcase: testProjectOuterJoinTeamMembersOuterJoinAddress took 0.586 sec
Testcase: testProjectJoinTeamMembersOuterJoinAddress took 0.591 sec
Testcase: testProblemReporterProjectJoinTeamMembersJoinAddress took 0.464 sec
Testcase: testEmployeeJoinProjects took 0.585 sec
Testcase: testEmployeeJoinProjectsJoinTeamLeaderJoinAddressWhereManagerIsNull took 0.515 sec
Testcase: testProjectOuterJoinTeamLeaderAddressTeamMembersAddressPhonesWhereProjectName took 0.497 sec
Testcase: testEmployeeOuterJoinAddressPhoneProjectsTeamLeaderAddressTeamMembersPhones took 0.875 sec
Testcase: testEmployeeJoinManagerAddressOuterJoinManagerAddress took 0.459 sec
Testcase: testTwoUnrelatedResultWithOneToManyJoins took 0.554 sec
Testcase: testMultipleUnrelatedResultWithOneToManyJoins took 0.794 sec
Testcase: testTwoUnrelatedResultWithOneToOneJoins took 0.692 sec
Testcase: testTwoUnrelatedResultWithOneToOneJoinsWithExtraItem took 0.584 sec
Testcase: testSimpleReturnDirectToField took 0.007 sec
Testcase: testSimpleReturnObject took 0.01 sec
Testcase: testReturnObjectAndDirectToField took 0.012 sec
Testcase: testReturnUnrelatedObjectAndDirectToField took 0.035 sec
Testcase: testInheritanceMultiTableException took 0.008 sec
Testcase: testReturnRootObject took 0.018 sec
Testcase: testExtendedPersistenceContext took 0.015 sec
Testcase: testSimpleConstructorExpression took 0.012 sec
Testcase: testSimpleConstructorExpressionWithNamedQuery took 0.01 sec
Testcase: testMultipleTypeConstructorExpression took 0.012 sec
Testcase: testNonExistantConstructorConstructorExpression took 0.006 sec
Testcase: testPrimitiveConstructorExpression took 0.01 sec
Testcase: testConstructorEJBQLWithInheritance took 0.006 sec
Testcase: testConstructorExpressionWithOtherAttributes took 0.011 sec
Testcase: testCreateProjects took 0.042 sec
Testcase: testCreateEmployeeWithFlush took 0.054 sec
Testcase: testVersionUpdateWithCorrectValue took 0.013 sec
Testcase: testVersionUpdateWithIncorrectValue took 0.017 sec
Testcase: testVersionUpdateWithNullValue took 0.014 sec
Testcase: testCreateDepartment took 0.019 sec
Testcase: testCreateScientists took 0.11 sec
Testcase: testReadDepartment took 0.042 sec
Testcase: testReadJuniorScientist took 0.049 sec
Testcase: testCreateWrapperTypes took 0.036 sec
Testcase: testNullifyBigDecimal took 0.019 sec
Testcase: testNullifyBigInteger took 0.015 sec
Testcase: testNullifyBoolean took 0.025 sec
Testcase: testNullifyByte took 0.171 sec
Testcase: testNullifyCharacter took 0.015 sec
Testcase: testNullifyShort took 0.017 sec
Testcase: testNullifyInteger took 0.012 sec
Testcase: testNullifyLong took 0.018 sec
Testcase: testNullifyFloat took 0.013 sec
Testcase: testNullifyDouble took 0.016 sec
Testcase: testNullifyString took 0.017 sec
Testcase: testCreateByteArrayType took 0.045 sec
Testcase: testCreatePrimitiveByteArrayType took 0.04 sec
Testcase: testCreateCharacterArrayType took 0.042 sec
Testcase: testCreateCharArrayType took 0.048 sec
Testcase: testCreateDateTime took 0.042 sec
Testcase: testNullifySqlDate took 0.018 sec
Testcase: testNullifyTime took 0.016 sec
Testcase: testNullifyTimestamp took 0.018 sec
Testcase: testNullifyUtilDate took 0.018 sec
Testcase: testNullifyCalendar took 0.024 sec
Testcase: testPrePersistBusOverrideAndAbstractInheritAndDefault took 0.046 sec
Testcase: testPostPersistBusInheritAndDefault took 0.029 sec
Testcase: testPostLoadBusInheritAndDefault took 0.001 sec
Testcase: testPrePersistSportsCarInheritAndExcludeDefault took 0.027 sec
Testcase: testPostPersistSportsCarInheritAndExcludeDefault took 0.014 sec
Testcase: testPrePersistSportsCarOverride took 0.012 sec
Testcase: test_null took 1.485 sec
Testcase: test_nullNonDeferred took 1.207 sec
Testcase: test_ownerTOP took 1.127 sec
Testcase: test_fuelTypePetrol took 0.467 sec
Testcase: test_schoolBusNullDriver took 0.108 sec
Testcase: test_ownerOwnsNonFueledVehicle took 0.647 sec
Testcase: testInitialize took 0.132 sec
Testcase: test1 took 0.064 sec
Testcase: testInitialize took 0.042 sec
Testcase: test2 took 0.031 sec
Testcase: testInitialize took 0.042 sec
Testcase: test3 took 0.053 sec
Testcase: testCreateBlue took 0.024 sec
Testcase: testReadBlue took 0.006 sec
Testcase: testPreAndPostPersistAlpine took 0.027 sec
Testcase: testPreAndPostPersistBeerConsumer took 0.042 sec
Testcase: testPostLoadOnFind took 0.001 sec
Testcase: testPostLoadOnRefresh took 0.015 sec
Testcase: testPreAndPostUpdate took 0.008 sec
Testcase: testPreAndPostRemove took 0.047 sec
Testcase: testCreateBeerConsumer took 0.051 sec
Testcase: testCreateAlpine took 0.054 sec
Testcase: testCreateCanadian took 0.042 sec
Testcase: testCreateCertifications took 0.043 sec
Testcase: testCreateTelephoneNumbers took 0.092 sec
Testcase: testReadBeerConsumer took 0.014 sec
Testcase: testReadAlpine took 0.01 sec
Testcase: testReadCanadian took 0.006 sec
Testcase: testInsertNewAlpine took 0.063 sec
Testcase: testInsertNewAlpineAndModifyOrderOfExistingAlpines took 0.059 sec
Testcase: testUpdateAlpine took 0.018 sec
Testcase: testUpdateAlpineThroughBeerConsumer took 0.036 sec
Testcase: testUpdateBeerConsumer took 0.03 sec
Testcase: testUpdateCanadian took 0.018 sec
Testcase: testUpdateCanadianThroughBeerConsumer took 0.03 sec
Testcase: testUpdateCertifications took 0.066 sec
Testcase: testUpdateTelephoneNumberThroughBeerConsumer took 0.03 sec
Testcase: testShuffleTelephoneNumbersOnBeerConsumers took 0.077 sec
Testcase: testDeleteAlpine took 0.027 sec
Testcase: testDeleteCanadian took 0.025 sec
Testcase: testDeleteBeerConsumer took 0.059 sec
Testcase: testgetReference took 1.638 sec
Testcase: testcreateNativeQuery took 1.565 sec
Testcase: testcreateNativeQueryWithSelectSQL took 1.647 sec
Testcase: testNativeNamedQuery took 1.665 sec
Testcase: testSetParameterUsingNull took 1.603 sec
Testcase: testLeftTrimWithTrimChar took 1.669 sec
Testcase: testTrimWithTrimChar took 1.76 sec
Testcase: testTrimWithoutTrimChar took 1.607 sec
Testcase: testLocateWithSingleArgument took 1.576 sec
Testcase: testLocateWithDoubleArgument took 1.528 sec
Testcase: testInsertVirtualAttribute took 0.049 sec
Testcase: testReadVirtualAttribute took 0.011 sec
Testcase: testUpdateVirtualAttribute took 0.031 sec
Testcase: testDeleteVirtualAttribute took 0.036 sec
Testcase: testPKClassTypeValidation took 0 sec
Testcase: testParameterNameValidation took 0.001 sec
Testcase: testParameterPositionValidation took 0.001 sec
Testcase: testParameterPositionValidation2 took 0.001 sec
Testcase: testSelectPhoneNumberAreaCode took 0.013 sec
Testcase: testSelectPhoneNumberAreaCodeWithEmployee took 0.03 sec
Testcase: testSelectPhoneNumberNumberWithEmployeeWithExplicitJoin took 0.022 sec
Testcase: testSelectPhoneNumberNumberWithEmployeeWithFirstNameFirst took 0.021 sec
Testcase: testSelectEmployeeWithSameParameterUsedMultipleTimes took 0.012 sec
Testcase: testOuterJoinOnOneToOne took 0.047 sec
Testcase: testOuterJoinPolymorphic took 0.024 sec
Testcase: testFirstResultOnNamedQuery took 0.032 sec
Testcase: simpleJoinFetchTest took 0.414 sec
Testcase: baseTestCase took 0.267 sec
Testcase: simpleABSTest took 0.032 sec
Testcase: simpleBetweenAndTest took 0.234 sec
Testcase: simpleBetweenTest took 0.223 sec
Testcase: simpleConcatTest took 0.03 sec
Testcase: simpleConcatTestWithParameters took 0.031 sec
Testcase: simpleConcatTestWithConstants1 took 0.04 sec
Testcase: simpleDistinctTest took 0.026 sec
Testcase: simpleDistinctNullTest took 0.053 sec
Testcase: simpleDistinctMultipleResultTest took 0.035 sec
Testcase: simpleDoubleOrTest took 0.078 sec
Testcase: simpleEqualsBracketsTest took 0.033 sec
Testcase: simpleEqualsTest took 0.026 sec
Testcase: simpleEqualsTestWithJoin took 0.038 sec
Testcase: simpleEqualsWithAs took 0.03 sec
Testcase: collectionMemberIdentifierEqualsTest took 0.046 sec
Testcase: abstractSchemaIdentifierEqualsTest took 0.031 sec
Testcase: abstractSchemaIdentifierNotEqualsTest took 0.251 sec
Testcase: simpleInOneDotTest took 0.04 sec
Testcase: simpleInTest took 0.031 sec
Testcase: simpleLengthTest took 0.029 sec
Testcase: simpleLikeTest took 0.03 sec
Testcase: simpleLikeTestWithParameter took 0.031 sec
Testcase: simpleLikeEscapeTestWithParameter took 0.018 sec
Testcase: simpleNotBetweenTest took 0.283 sec
Testcase: simpleNotEqualsVariablesInteger took 0.253 sec
Testcase: simpleNotInTest took 0.261 sec
Testcase: simpleNotLikeTest took 0.259 sec
Testcase: simpleOrFollowedByAndTest took 0.041 sec
Testcase: simpleOrFollowedByAndTestWithStaticNames took 0.057 sec
Testcase: simpleOrTest took 0.059 sec
Testcase: simpleParameterTest took 0.031 sec
Testcase: simpleParameterTestChangingParameters took 0.077 sec
Testcase: simpleReverseAbsTest took 0.03 sec
Testcase: simpleReverseConcatTest took 0.03 sec
Testcase: simpleReverseEqualsTest took 0.029 sec
Testcase: simpleReverseLengthTest took 0.033 sec
Testcase: simpleReverseParameterTest took 0.043 sec
Testcase: simpleReverseSqrtTest took 0.026 sec
Testcase: simpleReverseSubstringTest took 0.029 sec
Testcase: simpleSqrtTest took 0.025 sec
Testcase: simpleSubstringTest took 0.031 sec
Testcase: simpleNullTest took 0.046 sec
Testcase: simpleNotNullTest took 0.282 sec
Testcase: distinctTest took 0.049 sec
Testcase: conformResultsInUnitOfWorkTest took 0.325 sec
	Caused an ERROR

Internal Exception: java.sql.SQLException: ORA-04031: unable to allocate 25784 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values")
Error Code: 4031
Local Exception Stack: 
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.6 (Build 060627)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-04031: unable to allocate 25784 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values")
Error Code: 4031
	at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:289)
	at oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:87)
	at oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:170)
	at oracle.toplink.essentials.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:218)
	at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.connect(DatabaseAccessor.java:227)
	at oracle.toplink.essentials.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:294)
	at oracle.toplink.essentials.threetier.ConnectionPool.buildConnection(ConnectionPool.java:102)
	at oracle.toplink.essentials.threetier.ConnectionPool.startUp(ConnectionPool.java:324)
	at oracle.toplink.essentials.threetier.ServerSession.connect(ServerSession.java:443)
	at oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:571)
	at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLSimpleTestSuite.conformResultsInUnitOfWorkTest(JUnitEJBQLSimpleTestSuite.java:1430)
	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
	at junit.extensions.TestSetup.run(TestSetup.java:23)
Caused by: java.sql.SQLException: ORA-04031: unable to allocate 25784 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values")

	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
	at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)
	at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:260)
	at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:360)
	at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
	at java.sql.DriverManager.getConnection(DriverManager.java:525)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:85)
	... 30 more

Testcase: simpleModTest took 0.174 sec
Testcase: simpleIsEmptyTest took 0.031 sec
Testcase: simpleIsNotEmptyTest took 0.277 sec
Testcase: simpleApostrohpeTest took 0.02 sec
Testcase: simpleEscapeUnderscoreTest took 0.049 sec
Testcase: smallProjectMemberOfProjectsTest took 0.111 sec
Testcase: smallProjectNOTMemberOfProjectsTest took 0.251 sec
Testcase: selectCountOneToOneTest took 0.011 sec
Testcase: selectOneToOneTest took 0.013 sec
Testcase: selectPhonenumberDeclaredInINClauseTest took 0.132 sec
Testcase: selectSimpleMemberOfWithParameterTest took 0.067 sec
Testcase: selectSimpleNotMemberOfWithParameterTest took 0.275 sec
Testcase: selectSimpleBetweenWithParameterTest took 0.216 sec
Testcase: selectSimpleInWithParameterTest took 0.031 sec
Testcase: selectAverageQueryForByteColumnTest took 0.007 sec
Testcase: selectUsingLockModeQueryHintTest took 0.012 sec
Testcase: multipleExecutionOfNamedQueryTest took 0.023 sec
Testcase: complexABSTest took 0.025 sec
Testcase: complexABSWithParameterTest took 0.015 sec
Testcase: compexInTest took 0.095 sec
Testcase: complexLengthTest took 0.028 sec
Testcase: complexLikeTest took 0.035 sec
Testcase: complexNotInTest took 0.238 sec
Testcase: complexNotLikeTest took 0.256 sec
Testcase: complexParameterTest took 0.032 sec
Testcase: complexReverseAbsTest took 0.053 sec
Testcase: complexReverseLengthTest took 0.029 sec
Testcase: complexReverseParameterTest took 0.036 sec
Testcase: complexReverseSqrtTest took 0.041 sec
Testcase: complexSqrtTest took 0.04 sec
Testcase: complexStringInTest took 0.089 sec
Testcase: complexStringNotInTest took 0.442 sec
Testcase: complexSubstringTest took 0.03 sec
Testcase: complexLocateTest took 0.02 sec
Testcase: complexNestedOneToManyUsingInClause took 0.08 sec
Testcase: complexUnusedVariableTest took 0.456 sec
Testcase: complexJoinTest took 0.037 sec
Testcase: complexFetchJoinTest took 0.425 sec
Testcase: complexSelectRelationshipTest took 0.019 sec
Testcase: complexConstructorTest took 0.015 sec
Testcase: complexConstructorRelationshipTest took 0.02 sec
Testcase: complexConstructorAggregatesTest took 0.022 sec
Testcase: complexResultPropertiesTest took 0.086 sec
Testcase: complexInSubqueryTest took 0.019 sec
Testcase: complexExistsTest took 0.103 sec
Testcase: complexNotExistsTest took 0.099 sec
Testcase: testStraightReadSuperClass took 0.02 sec
Testcase: testStraightReadSubClass took 0.021 sec
Testcase: testJoinSuperClass took 0.062 sec
Testcase: testJoinSubClass took 0.044 sec
Testcase: testJoinFetchSuperClass took 0.044 sec
Testcase: testJoinFetchSubClass took 0.025 sec
Testcase: generalExceptionTest took 0.014 sec
Testcase: recognitionExceptionTest took 0.001 sec
Testcase: missingSelectExceptionTest took 0 sec
Testcase: malformedEjbqlExceptionTest1 took 0.004 sec
Testcase: malformedEjbqlExceptionTest2 took 0.001 sec
Testcase: malformedEjbqlExceptionTest3 took 0 sec
Testcase: malformedEjbqlExceptionTest4 took 0.001 sec
Testcase: badAliasExceptionTest took 0 sec
Testcase: noAliasWithWHEREAndParameterExceptionTest took 0 sec
Testcase: missingDescriptorExceptionTest took 0.001 sec
Testcase: multipleDeclarationOfIdentificationVariable took 0.002 sec
Testcase: aliasResolutionException took 0 sec
Testcase: illegalArgumentExceptionTest took 0.001 sec
Testcase: createNamedQueryThrowsIllegalArgumentExceptionTest took 0 sec
Testcase: flushTxExceptionTest took 0.006 sec
Testcase: noResultExceptionTest took 0.007 sec
Testcase: testGetSingleResultOnUpdate took 0.002 sec
Testcase: testGetSingleResultOnDelete took 0.001 sec
Testcase: testExecuteUpdateOnSelect took 0.001 sec
Testcase: flushOptimisticLockExceptionTest took 0.59 sec
	Caused an ERROR

Internal Exception: java.sql.SQLException: ORA-04031: unable to allocate 25784 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values")
Error Code: 4031
Local Exception Stack: 
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.6 (Build 060627)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-04031: unable to allocate 25784 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values")
Error Code: 4031
	at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:289)
	at oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:87)
	at oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:170)
	at oracle.toplink.essentials.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:218)
	at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.connect(DatabaseAccessor.java:227)
	at oracle.toplink.essentials.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:294)
	at oracle.toplink.essentials.threetier.ConnectionPool.buildConnection(ConnectionPool.java:102)
	at oracle.toplink.essentials.threetier.ConnectionPool.startUp(ConnectionPool.java:324)
	at oracle.toplink.essentials.threetier.ServerSession.connect(ServerSession.java:443)
	at oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:571)
	at oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:182)
	at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:226)
	at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:84)
	at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:127)
	at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:121)
	at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
	at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLValidationTestSuite.createAlternateEntityManager(JUnitEJBQLValidationTestSuite.java:857)
	at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLValidationTestSuite.flushOptimisticLockExceptionTest(JUnitEJBQLValidationTestSuite.java:575)
	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
	at junit.extensions.TestSetup.run(TestSetup.java:23)
Caused by: java.sql.SQLException: ORA-04031: unable to allocate 25784 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values")

	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
	at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)
	at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:260)
	at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:360)
	at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
	at java.sql.DriverManager.getConnection(DriverManager.java:525)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:85)
	... 37 more

Testcase: commitOptimisticLockExceptionTest took 0.466 sec
	Caused an ERROR

Internal Exception: java.sql.SQLException: ORA-04031: unable to allocate 25784 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values")
Error Code: 4031
Local Exception Stack: 
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.6 (Build 060627)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-04031: unable to allocate 25784 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values")
Error Code: 4031
	at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:289)
	at oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:87)
	at oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:170)
	at oracle.toplink.essentials.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:218)
	at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.connect(DatabaseAccessor.java:227)
	at oracle.toplink.essentials.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:294)
	at oracle.toplink.essentials.threetier.ConnectionPool.buildConnection(ConnectionPool.java:102)
	at oracle.toplink.essentials.threetier.ConnectionPool.startUp(ConnectionPool.java:324)
	at oracle.toplink.essentials.threetier.ServerSession.connect(ServerSession.java:443)
	at oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:571)
	at oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:182)
	at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:226)
	at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:84)
	at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:127)
	at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:121)
	at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
	at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLValidationTestSuite.createAlternateEntityManager(JUnitEJBQLValidationTestSuite.java:857)
	at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLValidationTestSuite.commitOptimisticLockExceptionTest(JUnitEJBQLValidationTestSuite.java:615)
	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
	at junit.extensions.TestSetup.run(TestSetup.java:23)
Caused by: java.sql.SQLException: ORA-04031: unable to allocate 25784 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values")

	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
	at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)
	at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:260)
	at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:360)
	at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
	at java.sql.DriverManager.getConnection(DriverManager.java:525)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:85)
	... 37 more

Testcase: JTAOptimisticLockExceptionTest took 0.617 sec
	Caused an ERROR

Internal Exception: java.sql.SQLException: ORA-04031: unable to allocate 25784 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values")
Error Code: 4031
Local Exception Stack: 
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2006.6 (Build 060627)): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-04031: unable to allocate 25784 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values")
Error Code: 4031
	at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:289)
	at oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:87)
	at oracle.toplink.essentials.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:170)
	at oracle.toplink.essentials.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:218)
	at oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.connect(DatabaseAccessor.java:227)
	at oracle.toplink.essentials.internal.databaseaccess.DatasourceAccessor.connect(DatasourceAccessor.java:294)
	at oracle.toplink.essentials.threetier.ConnectionPool.buildConnection(ConnectionPool.java:102)
	at oracle.toplink.essentials.threetier.ConnectionPool.startUp(ConnectionPool.java:324)
	at oracle.toplink.essentials.threetier.ServerSession.connect(ServerSession.java:443)
	at oracle.toplink.essentials.internal.sessions.DatabaseSessionImpl.login(DatabaseSessionImpl.java:571)
	at oracle.toplink.essentials.ejb.cmp3.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:182)
	at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:226)
	at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.getServerSession(EntityManagerFactoryImpl.java:84)
	at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:127)
	at oracle.toplink.essentials.internal.ejb.cmp3.base.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:121)
	at oracle.toplink.essentials.internal.ejb.cmp3.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:76)
	at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLValidationTestSuite.createAlternateEntityManager(JUnitEJBQLValidationTestSuite.java:857)
	at oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLValidationTestSuite.JTAOptimisticLockExceptionTest(JUnitEJBQLValidationTestSuite.java:655)
	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
	at junit.extensions.TestSetup.run(TestSetup.java:23)
Caused by: java.sql.SQLException: ORA-04031: unable to allocate 25784 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values")

	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
	at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)
	at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:260)
	at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:360)
	at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
	at java.sql.DriverManager.getConnection(DriverManager.java:525)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at oracle.toplink.essentials.sessions.DefaultConnector.connect(DefaultConnector.java:85)
	... 37 more

Testcase: testParameterNameValidation took 0.001 sec
Testcase: testModArgumentValidation took 0.001 sec
Testcase: testInExpressionValidation took 0.001 sec
Testcase: testOrderableTypeInOrderByItem took 0.001 sec
Testcase: testInvalidNavigation took 0.001 sec
Testcase: testUnknownAttribute took 0.001 sec
Testcase: testCommitRollbackException took 0.058 sec
Testcase: testParameterPositionValidation took 0.001 sec
Testcase: testParameterPositionValidation2 took 0 sec
Testcase: testParameterTypeValidation took 0.001 sec
Testcase: testEjbqlCaseSensitivity took 0.009 sec
Testcase: complexAVGTest took 0.013 sec
Testcase: complexCountTest took 0.01 sec
Testcase: complexDistinctCountTest took 0.014 sec
Testcase: complexMaxTest took 0.013 sec
Testcase: complexMinTest took 0.013 sec
Testcase: complexSumTest took 0.014 sec
Testcase: testSqlDate took 0.006 sec
Testcase: testSqlDateToTS took 0.005 sec
Testcase: testTime took 0.006 sec
Testcase: testTimeToTS took 0.005 sec
Testcase: testTimestamp took 0.007 sec
Testcase: testTimestampToDate took 0.004 sec
Testcase: testTimestampToTime took 0.004 sec
Testcase: testUtilDate took 0.005 sec
Testcase: testCalenderWithUtilDate took 0.006 sec
Testcase: testSqlDateWithCal took 0.004 sec
Testcase: testTimeWithCal took 0.005 sec
Testcase: testTimestampWithCal took 0.005 sec
Testcase: testUtilDateWithCal took 0.006 sec
Testcase: testCalendar took 0.005 sec
Testcase: testTimestampGreaterThan took 0.008 sec
Testcase: testTimestampLessThan took 0.008 sec
Testcase: testTimestampIn took 0.01 sec
Testcase: testTimestampBetween took 0.007 sec
Testcase: multipleParameterTest took 0.016 sec
Testcase: findAllOrders took 0.013 sec
Testcase: findEmployeesInOntario took 0.189 sec
Testcase: findAllProvinceWithEmployees took 0.012 sec
Testcase: findAllEmployeesWithPhoneNumbers took 0.259 sec
Testcase: findAllEmployeesWithOutPhoneNumbers took 0.027 sec
Testcase: findAllEmployeesWithCellPhones took 0.083 sec
Testcase: findOrdersWithDifferentBilledCustomer took 0.018 sec
Testcase: findEmployeeWithWorkPhone2258812 took 0.152 sec
Testcase: parameterTest took 0.159 sec
Testcase: getOrderLargerThan took 0.013 sec
Testcase: getSalesPersonForOrders took 0.011 sec
Testcase: getOrderForCustomer took 0.028 sec
Testcase: testOuterJoin took 0.085 sec
Testcase: testExistsExpression took 0.021 sec
Testcase: testAllExpressions took 0.046 sec
Testcase: testCountInSubQuery took 0.014 sec
Testcase: testGroupByHavingExpression took 0.044 sec
Testcase: testGroupByHavingCount took 0.015 sec
Testcase: testConstructorQuery took 0.007 sec
Testcase: testSumExpression took 0.015 sec
Testcase: testAvgExpression took 0.008 sec
Testcase: testOrderByExpression took 0.05 sec
Testcase: testCountInSubQuery took 0.01 sec
Testcase: testOrderByExpressionWithSelect took 0.018 sec
Testcase: testDeleteExpression took 0.02 sec
Testcase: testComplexDeleteExpression took 0.018 sec
Testcase: updateAllTest took 0.044 sec
Testcase: namedQueryCloneTest took 0.015 sec
Testcase: aggregateParameterTest took 0.079 sec
Testcase: simpleUpdate took 3.969 sec
Testcase: updateWithSubquery took 3.773 sec
Testcase: simpleDelete took 3.784 sec
Testcase: testCreateEmployee took 0.08 sec
Testcase: testReadEmployee took 0 sec
Testcase: testNamedNativeQueryOnAddress took 0.027 sec
Testcase: testNamedQueryOnEmployee took 0.008 sec
Testcase: testUpdateEmployee took 0.012 sec
Testcase: testRefreshNotManagedEmployee took 0 sec
Testcase: testRefreshRemovedEmployee took 0.054 sec
Testcase: testDeleteEmployee took 0.063 sec
Testcase: testCreateCustomer took 0.011 sec
Testcase: testCreateItem took 0.012 sec
Testcase: testCreateOrder took 0.018 sec
Testcase: testReadCustomer took 0.001 sec
Testcase: testReadItem took 0.001 sec
Testcase: testReadOrder took 0 sec
Testcase: testNamedQueryOnCustomer took 0.006 sec
Testcase: testNamedQueryOnItem took 0.007 sec
Testcase: testNamedQueryOnOrder took 0.008 sec
Testcase: testUpdateCustomer took 0.024 sec
Testcase: testUpdateItem took 0.02 sec
Testcase: testUpdateOrder took 0.022 sec
Testcase: testDeleteCustomer took 0.027 sec
Testcase: testDeleteItem took 0.025 sec
Testcase: testDeleteOrder took 0.009 sec
Testcase: testCreateFueledVehicle took 0.018 sec
Testcase: testCreateBusFueledVehicle took 0.018 sec
Testcase: testCreateNonFueledVehicle took 0.055 sec
Testcase: testReadFueledVehicle took 0.002 sec
Testcase: testReadNonFueledVehicle took 0 sec
Testcase: testNamedNativeQueryOnSportsCar took 0.005 sec
Testcase: testUpdateBusFueledVehicle took 0.021 sec
Testcase: testUpdateFueledVehicle took 0.018 sec
Testcase: testUpdateNonFueledVehicle took 0.018 sec
Testcase: testDeleteBusFueledVehicle took 0.028 sec
Testcase: testDeleteFueledVehicle took 0.024 sec
Testcase: testDeleteNonFueledVehicle took 0.017 sec
Testcase: testOneToManyRelationships took 0.055 sec
Testcase: testVerifyOneToManyRelationships took 0.003 sec
Testcase: testCreateBeerConsumer took 0.075 sec
Testcase: testReadBeerConsumer took 0.001 sec
Testcase: testNamedNativeQueryBeerConsumers took 0.011 sec
Testcase: testNamedNativeQueryCertifications took 0.009 sec
Testcase: testUpdateBeerConsumer took 0.013 sec
Testcase: testDeleteBeerConsumer took 0.075 sec
Testcase: testInheritanceDiscriminatorFieldValue took 0.001 sec
Testcase: testMappingsTypes took 0 sec
Testcase: testCreateCustomer took 0.009 sec
Testcase: testCreateItem took 0.061 sec
Testcase: testCreateOrder took 0.016 sec
Testcase: testReadCustomer took 0.001 sec
Testcase: testReadItem took 0.001 sec
Testcase: testReadOrder took 0.003 sec
Testcase: testNamedQueryOnCustomer took 0.006 sec
Testcase: testNamedQueryOnItem took 0.009 sec
Testcase: testNamedQueryOnOrder took 0.007 sec
Testcase: testUpdateCustomer took 0.023 sec
Testcase: testUpdateItem took 0.054 sec
Testcase: testUpdateOrder took 0.037 sec
Testcase: testDeleteCustomer took 0.023 sec
Testcase: testDeleteItem took 0.018 sec
Testcase: testDeleteOrder took 0.011 sec
Testcase: testCreateCustomer took 0.015 sec
Testcase: testCreateItem took 0.042 sec
Testcase: testCreateOrder took 0.018 sec
Testcase: testReadCustomer took 0.001 sec
Testcase: testReadItem took 0.001 sec
Testcase: testReadOrder took 0.001 sec
Testcase: testUpdateCustomer took 0.016 sec
Testcase: testUpdateItem took 0.042 sec
Testcase: testUpdateOrder took 0.032 sec
Testcase: testDeleteCustomer took 0.017 sec
Testcase: testDeleteItem took 0.025 sec
Testcase: testDeleteOrder took 0.008 sec
Testcase: testCreateEmployee took 0.172 sec
Testcase: testReadEmployee took 0.001 sec
Testcase: testUpdateEmployee took 0.022 sec
Testcase: testDeleteEmployee took 0.069 sec
