Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
EclipseLink/Development/Incubator/Extensions/MaxDBPlatform
Note: This page describes an extension of EclipseLink that is part of the EclipseLink incubator. Incubator projects are published so the community can use them either to progress towards having them included in the main product, or to use in their own implementations. They have been tested to varying levels and as such, we recommend doing your own testing before including any of this code in a production-level product.
Contents
Bug
- bug 284657 Support for MaxDB / SAPDB
Description
This is a subclass of DatabasePlatform that can be used by customers using the MaxDB database.
Documentation
MaxDB uses URL that may contain the ampersand (&) character, e.g.
jdbc:sapdb://localhost/E32?spaceoption=true&unicode=yes
Please make sure that this character is escaped properly in XML files.
In order to execute the eclipselink tests, the ampersand must also escaped in an URL contained in a test.properties file.
Limitations of the Platform
- setQueryTimeout or the hint "javax.persistence.query.timeout" do not work on MaxDB - see bug 326503
- the hint "javax.persistence.lock.timeout" has no effect with a positive value; a value of 0 is translated to NOWAIT
Location
Level of Testing
October 1st 2010
- EclipseLink + MaxDB platform (incubator) 2.2.0 (trunk) current build (revision: 8286)
- DB: MaxDB, kernel 7.8.01 build 004-123-218-928
- JDBC driver: MaxDB JDBC Driver, Make-Version: 7.8.01 Build 004-123-218-928
Test Name | Tests | Failures | Errors |
---|---|---|---|
Core SRG | 690 | 0 | 2 |
JPA SRG | 202 | 0 | 1 |
JPA WDF | 816 | 0 | 0 |
Core LRG | 7442 | 0 | 34 |
JPA LRG | 2161 | 5 | 46 |
Server LRG (GlassFish v3) | ? | ? | ? |
Details on Errors/Failures
Core SRG
Test Case: org.eclipse.persistence.testing.tests.SRGTestModel
Test Name | Bug | Description/Reason |
---|---|---|
MultiPlatformTest5 | bug 316774 | coalesce is not recognized as function |
ScrollableCursorNavigationAPIConformingTest | bug 326646 | Cursor Navigation produced incorrect results. cursor.last() does not result in cursor.isLast() returning true. |
JPA SRG
Test Case: org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite
Test Name | Bug | Description/Reason |
---|---|---|
testLockWithJoinedInheritanceStrategy | bug 326799 | atemting to lock a locked entity with joined inheritance causes concurrent thread to wait even if nowait is applied |
Core LRG
Test Case: org.eclipse.persistence.testing.tests.TestRunModel
Test Name | Bug | Description/Reason |
---|---|---|
MultiPlatformTest5 | bug 316774 | Same as MultiPlatformTest5 in Core SRG |
ScrollableCursorNavigationAPIConformingTest | bug 326646 | Same as ScrollableCursorNavigationAPIConformingTest in Core SRG |
MultiPlatformTest5 | bug 316774 | Same as MultiPlatformTest5 in Core SRG |
ScrollableCursorNavigationAPIConformingTest | bug 326646 | Same as ScrollableCursorNavigationAPIConformingTest in Core SRG |
MultiPlatformTest5 | bug 316774 | Same as MultiPlatformTest5 in Core SRG |
MultiPlatformTest5 | bug 316774 | Same as MultiPlatformTest5 in Core SRG |
MultiPlatformTest5 | bug 316774 | Same as MultiPlatformTest5 in Core SRG |
UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) | bug 326883 | SAP DBTech JDBC: Cannot put ASCII data into this LONG column. |
UpdateNullOneToOneValueTest (SelectedFieldsLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullOneToOneValueTest (ChangedFieldsLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullOneToOneValueTest (VersionLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullOneToOneValueTest (TimestampLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullAggregateValueTest (AllFieldsLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullAggregateValueTest (SelectedFieldsLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullAggregateValueTest (ChangedFieldsLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullAggregateValueTest (VersionLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullAggregateValueTest (TimestampLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullOneToManyValueTest (AllFieldsLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullOneToManyValueTest (SelectedFieldsLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullOneToManyValueTest (ChangedFieldsLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullOneToManyValueTest (VersionLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullOneToManyValueTest (TimestampLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullTransformationValueTest (AllFieldsLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullTransformationValueTest (SelectedFieldsLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullTransformationValueTest (ChangedFieldsLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullTransformationValueTest (VersionLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullTransformationValueTest (TimestampLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullManyToManyValueTest (AllFieldsLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullManyToManyValueTest (SelectedFieldsLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullManyToManyValueTest (ChangedFieldsLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullManyToManyValueTest (VersionLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
UpdateNullManyToManyValueTest (TimestampLockingPolicy) | bug 326883 | Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) |
TypeTestModelWithAccessors with Accessors | bug 326884 | Invalid length for this data type:THECLOB - VARCHAR(25000) UNICODE |
TypeTestModelWithOutAccessors without Accessors | bug 326884 | Same as TypeTestModelWithAccessors with Accessors |
JPA LRG
Test Case: org.eclipse.persistence.testing.tests.jpa.AllCMP3TestRunModel
Test Name | Bug | Description/Reason |
---|---|---|
JPAAdvancedTestModel | Exception Description: XML_MERGE_PROJECT_SEQ: platform DatabasePlatform does not support NativeSequence | |
CMP3InheritanceTestModel | Same as JPAAdvancedTestModel | |
CMP3ComplexAggregateTestModel | Same as JPAAdvancedTestModel | |
testLockWithJoinedInheritanceStrategy | Same as testLockWithJoinedInheritanceStrategy in JPA SRG | |
testFindDeleteAllPersist | Duplicate key Call: INSERT INTO CMP3_FA_SALARY (SALARY, EMP_ID) VALUES (?, ?) bind => [0, 962] | |
testExtendedPersistenceContext | Duplicate key Call: INSERT INTO CMP3_FA_SALARY (SALARY, EMP_ID) VALUES (?, ?) bind => [0, 963] | |
testRemoveFlushPersistContains | Duplicate key Call: INSERT INTO CMP3_FA_SALARY (SALARY, EMP_ID) VALUES (?, ?) bind => [0, 968] | |
testPersistRemoved | Duplicate key Call: INSERT INTO CMP3_FA_SALARY (SALARY, EMP_ID) VALUES (?, ?) bind => [11000, 1026] | |
testIdentityOutsideTransaction | NullPointerException | |
testIdentityInsideTransaction | NullPointerException | |
testDeleteEmployee | Object not deleted from the database correctly: Employee: 1053 | |
testDeleteMan | Object not deleted from the database correctly: org.eclipse.persistence.testing.models.jpa.fieldaccess.advanced.Man@162808e | |
testRemoveJillWithPrivateOwnedPhoneNumbers | Jill's phone numbers were not deleted. | |
testRightTrimWithoutTrimChar | Test error: No Customers found | |
testOneEqualsOne | SQLSyntaxErrorException: [-7016] (at 465): Parameter spec not allowed in this context | |
complexCoalesceInWhereTest | bug 316774 | Same as MultiPlatformTest5 in Core SRG |
complexCoalesceInSelectTest | bug 316774 | Same as MultiPlatformTest5 in Core SRG |
complexCountOnJoinedVariableOverManyToManySelfRefRelationship | Order column must be output column | |
testDeleteExpression | Missing non-NULL value:QUANTITY | |
testComplexDeleteExpression | Same as testDeleteExpression | |
updateDateTimeFields | Unknown column name:CURRENT_DATE Call: UPDATE CMP3_DATE_TIME SET SQL_DATE = CURRENT_DATE | |
testOneToManyRelationships | Unknown table name or unknown schema:CMP3_MERGE_TELEPHONE | |
testVerifyOneToManyRelationships | NullPointerException | |
testMappedSuperclassTransientField | Same as testOneToManyRelationships | |
testTransientField | Same as testOneToManyRelationships | |
testDeleteBeerConsumer | Same as testOneToManyRelationships | |
testDDLUniqueKeysAsJoinColumns | Unknown table name or unknown schema:DDL_CKENTA | |
testDDLUnidirectionalOneToMany | Unknown table name or unknown schema:DDL_CKENT_C_B | |
testManyToManyWithMultipleJoinColumns | Same as testDDLUnidirectionalOneToMany | |
testCreateWrapperTypes | Cannot put ASCII data into this LONG column | |
testNullifyBigDecimal | NullPointerException | |
testNullifyBigInteger | NullPointerException | |
testNullifyBoolean | NullPointerException | |
testNullifyByte | NullPointerException | |
testNullifyCharacter | NullPointerException | |
testNullifyShort | NullPointerException | |
testNullifyInteger | NullPointerException | |
testNullifyLong | NullPointerException | |
testNullifyFloat | NullPointerException | |
testNullifyDouble | NullPointerException | |
testNullifyString | NullPointerException | |
testSetup | Invalid length for this data type:COMMENTARY - COMMENTARY VARCHAR(4500) UNICODE | |
testMerge | Unknown table name or unknown schema:CMP3_IMAGE (caused by failing testSetup?) | |
testCreate | Same as testMerge | |
testRead | An instance of a null PK has been incorrectly provided for this find operation. | |
testUpdate | Same as testRead | |
testDelete | Same as testRead | |
testMerge | Same as testMerge | |
testOneEqualsOne | Same as testOneEqualsOne | |
simpleCoalesceInWhereTest | bug 316774 | Same as MultiPlatformTest5 in Core SRG |
simpleCoalesceInSelectTest | bug 316774 | Same as MultiPlatformTest5 in Core SRG |
Older Test Runs
Solved Issues from Former Test Runs
Core SRG
Test Case: org.eclipse.persistence.testing.tests.SRGTestModel
Test Name | Bug | Description/Reason |
---|---|---|
PessimisticLockTest(mode=1) | bug 325839 | MaxDB can not do select for update with more than one table |
PessimisticLockEmptyTransactionTest | bug 325839 | Same as PessimisticLockTest(mode=1) |
QueryTimeoutTest | bug 326503 | Query timeout doesn't work on MaxDB |
JPA SRG
Test Case: org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite
Test Name | Bug | Description/Reason |
---|---|---|
testPESSIMISTIC_READLockWithNoChanges | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testPESSIMISTIC_WRITELockWithNoChanges | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testPESSIMISTIC_ExtendedScope | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testPessimisticLockHintStartsTransaction | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testPESSIMISTIC_FORCE_INCREMENTLock | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testGetLockModeType | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
JPA LRG
Test Case: org.eclipse.persistence.testing.tests.jpa.AllCMP3TestRunModel
Test Name | Bug | Description/Reason |
---|---|---|
testPESSIMISTIC_READLockWithNoChanges | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testPESSIMISTIC_WRITELockWithNoChanges | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testPESSIMISTIC_ExtendedScope | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testPessimisticLockHintStartsTransaction | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testPESSIMISTIC_FORCE_INCREMENTLock | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testGetLockModeType | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testPESSMISTIC_ES1 | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testPESSMISTIC_ES2 | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testPESSMISTIC_ES3 | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testPESSMISTIC_ES4 | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testPESSMISTIC_ES5 | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testPESSMISTIC_ES6 | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testPESSMISTIC_ES8 | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testPESSMISTIC_ES9 | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testQueryPESSIMISTIC_READLock | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testQueryPESSIMISTIC_WRITELock | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testLockWithSecondaryTable | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testQueryPESSIMISTIC_FORCE_INCREMENTLock | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
testQueryPESSIMISTIC_FORCE_INCREMENTLock | bug 325839 | Same as PessimisticLockTest(mode=1) in Core SRG |
Location of tests and examples
No specific tests or examples have been written