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.
Difference between revisions of "EclipseLink/Development/Incubator/Extensions/MaxDBPlatform"
m (→JPA LRG) |
m (→JPA LRG) |
||
Line 114: | Line 114: | ||
Test Case: org.eclipse.persistence.testing.tests.jpa.AllCMP3TestRunModel | Test Case: org.eclipse.persistence.testing.tests.jpa.AllCMP3TestRunModel | ||
+ | |||
+ | ====== JPAAdvancedTestModel ====== | ||
{|{{BMTableStyle}} | {|{{BMTableStyle}} | ||
|-{{BMTHStyle}} | |-{{BMTHStyle}} | ||
− | |||
! Test Name | ! Test Name | ||
! Bug | ! Bug | ||
! Description/Reason | ! Description/Reason | ||
|- | |- | ||
− | + | | setup || || Exception Description: XML_MERGE_PROJECT_SEQ: platform DatabasePlatform does not support NativeSequence | |
+ | |} | ||
+ | |||
+ | ====== CMP3InheritanceTestModel ====== | ||
+ | |||
+ | {|{{BMTableStyle}} | ||
+ | |-{{BMTHStyle}} | ||
+ | ! Test Name | ||
+ | ! Bug | ||
+ | ! Description/Reason | ||
|- | |- | ||
− | + | | setup || || Same as JPAAdvancedTestModel | |
+ | |} | ||
+ | |||
+ | ====== CMP3ComplexAggregateTestModel ====== | ||
+ | |||
+ | {|{{BMTableStyle}} | ||
+ | |-{{BMTHStyle}} | ||
+ | ! Test Name | ||
+ | ! Bug | ||
+ | ! Description/Reason | ||
|- | |- | ||
− | + | | setup || || Same as JPAAdvancedTestModel | |
+ | |} | ||
+ | |||
+ | ====== advanced.EntityManagerJUnitTestSuite ====== | ||
+ | |||
+ | {|{{BMTableStyle}} | ||
+ | |-{{BMTHStyle}} | ||
+ | ! Test Name | ||
+ | ! Bug | ||
+ | ! Description/Reason | ||
|- | |- | ||
− | + | | testLockWithJoinedInheritanceStrategy || {{bug|326799}} || Same as testLockWithJoinedInheritanceStrategy in JPA SRG | |
+ | |} | ||
+ | |||
+ | ====== fieldaccess.advanced.EntityManagerJUnitTestSuite ====== | ||
+ | |||
+ | {|{{BMTableStyle}} | ||
+ | |-{{BMTHStyle}} | ||
+ | ! Test Name | ||
+ | ! Bug | ||
+ | ! Description/Reason | ||
|- | |- | ||
− | + | | 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. | |
+ | |} | ||
+ | |||
+ | ====== fieldaccess.relationships.ExpressionJUnitTestSuite ====== | ||
+ | |||
+ | {|{{BMTableStyle}} | ||
+ | |-{{BMTHStyle}} | ||
+ | ! Test Name | ||
+ | ! Bug | ||
+ | ! Description/Reason | ||
|- | |- | ||
− | + | | testRightTrimWithoutTrimChar || || Test error: No Customers found | |
+ | |} | ||
+ | |||
+ | ====== JUnitJPQLSimpleTestSuite ====== | ||
+ | |||
+ | {|{{BMTableStyle}} | ||
+ | |-{{BMTHStyle}} | ||
+ | ! Test Name | ||
+ | ! Bug | ||
+ | ! Description/Reason | ||
|- | |- | ||
− | + | | testOneEqualsOne || {{bug|326962}} || SQLSyntaxErrorException: [-7016] (at 465): Parameter spec not allowed in this context | |
+ | |} | ||
+ | |||
+ | ====== JUnitJPQLComplexTestSuite ====== | ||
+ | |||
+ | {|{{BMTableStyle}} | ||
+ | |-{{BMTHStyle}} | ||
+ | ! Test Name | ||
+ | ! Bug | ||
+ | ! Description/Reason | ||
|- | |- | ||
− | + | | complexCoalesceInWhereTest || {{bug|316774}} || Same as MultiPlatformTest5 in Core SRG | |
|- | |- | ||
− | + | | complexCoalesceInSelectTest || {{bug|316774}} || Same as MultiPlatformTest5 in Core SRG | |
+ | |} | ||
+ | |||
+ | ====== JUnitJPQLComplexTestSuite ====== | ||
+ | |||
+ | {|{{BMTableStyle}} | ||
+ | |-{{BMTHStyle}} | ||
+ | ! Test Name | ||
+ | ! Bug | ||
+ | ! Description/Reason | ||
|- | |- | ||
− | | | + | | complexCoalesceInWhereTest || {{bug|316774}} || Same as MultiPlatformTest5 in Core SRG |
|- | |- | ||
− | | | + | | complexCoalesceInSelectTest || {{bug|316774}} || Same as MultiPlatformTest5 in Core SRG |
+ | |} | ||
+ | |||
+ | ====== JUnitJPQLComplexAggregateTestSuite ====== | ||
+ | |||
+ | {|{{BMTableStyle}} | ||
+ | |-{{BMTHStyle}} | ||
+ | ! Test Name | ||
+ | ! Bug | ||
+ | ! Description/Reason | ||
|- | |- | ||
− | | | + | | complexCountOnJoinedVariableOverManyToManySelfRefRelationship || || Order column must be output column |
+ | |} | ||
+ | |||
+ | ====== JUnitJPQLExamplesTestSuite ====== | ||
+ | |||
+ | {|{{BMTableStyle}} | ||
+ | |-{{BMTHStyle}} | ||
+ | ! Test Name | ||
+ | ! Bug | ||
+ | ! Description/Reason | ||
|- | |- | ||
− | | JUnitJPQLModifyTestSuite || updateDateTimeFields || || Unknown column name:CURRENT_DATE Call: UPDATE CMP3_DATE_TIME SET SQL_DATE = CURRENT_DATE | + | | testDeleteExpression || || Missing non-NULL value:QUANTITY |
+ | |- | ||
+ | | testComplexDeleteExpression || || Same as testDeleteExpression | ||
+ | |} | ||
+ | |||
+ | ====== JUnitJPQLExamplesTestSuite ====== | ||
+ | {|{{BMTableStyle}} | ||
+ | |-{{BMTHStyle}} | ||
+ | ! Test Name | ||
+ | ! Bug | ||
+ | ! Description/Reason | ||
+ | |- | ||
+ | | testDeleteExpression || || Missing non-NULL value:QUANTITY | ||
+ | |- | ||
+ | | testComplexDeleteExpression || || Same as testDeleteExpression | ||
+ | |} | ||
+ | |||
+ | ====== JUnitJPQLModifyTestSuite ====== | ||
+ | {|{{BMTableStyle}} | ||
+ | |-{{BMTHStyle}} | ||
+ | ! Test Name | ||
+ | ! Bug | ||
+ | ! Description/Reason | ||
+ | |- | ||
+ | | updateDateTimeFields || || Unknown column name:CURRENT_DATE Call: UPDATE CMP3_DATE_TIME SET SQL_DATE = CURRENT_DATE | ||
+ | |} | ||
+ | |||
+ | ====== EntityMappingsMergeInheritedJUnitTestCase ====== | ||
+ | |||
+ | {|{{BMTableStyle}} | ||
+ | |-{{BMTHStyle}} | ||
+ | ! Test Name | ||
+ | ! Bug | ||
+ | ! Description/Reason | ||
|- | |- | ||
| testOneToManyRelationships || {{bug|326968}} || Unknown table name or unknown schema:CMP3_MERGE_TELEPHONE | | testOneToManyRelationships || {{bug|326968}} || Unknown table name or unknown schema:CMP3_MERGE_TELEPHONE | ||
|- | |- | ||
− | + | | testVerifyOneToManyRelationships || {{bug|326968}} || NullPointerException | |
|- | |- | ||
− | + | | testMappedSuperclassTransientField || {{bug|326968}} || Same as testOneToManyRelationships | |
|- | |- | ||
− | + | | testTransientField || {{bug|326968}} || Same as testOneToManyRelationships | |
|- | |- | ||
− | + | | testDeleteBeerConsumer || {{bug|326968}} || Same as testOneToManyRelationships | |
+ | |} | ||
+ | |||
+ | ====== DDLGenerationJUnitTestSuite ====== | ||
+ | |||
+ | {|{{BMTableStyle}} | ||
+ | |-{{BMTHStyle}} | ||
+ | ! Test Name | ||
+ | ! Bug | ||
+ | ! Description/Reason | ||
|- | |- | ||
− | + | | testDDLUniqueKeysAsJoinColumns || || Unknown table name or unknown schema:DDL_CKENTA | |
|- | |- | ||
− | + | | testDDLUnidirectionalOneToMany || || Unknown table name or unknown schema:DDL_CKENT_C_B | |
|- | |- | ||
− | + | | testManyToManyWithMultipleJoinColumns || || Same as testDDLUnidirectionalOneToMany | |
+ | |} | ||
+ | |||
+ | ====== JUnitCriteriaSimpleTestSuite ====== | ||
+ | |||
+ | {|{{BMTableStyle}} | ||
+ | |-{{BMTHStyle}} | ||
+ | ! Test Name | ||
+ | ! Bug | ||
+ | ! Description/Reason | ||
|- | |- | ||
− | + | | testOneEqualsOne || {{bug|326962}} || Same as testOneEqualsOne | |
|- | |- | ||
− | + | | simpleCoalesceInWhereTest || {{bug|316774}} || Same as MultiPlatformTest5 in Core SRG | |
|- | |- | ||
− | + | | simpleCoalesceInSelectTest || {{bug|316774}} || Same as MultiPlatformTest5 in Core SRG | |
|} | |} | ||
Revision as of 02:42, 5 October 2010
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
- 1 Bug
- 2 Description
- 3 Documentation
- 4 Location
- 5 Level of Testing
- 5.1 October 4th 2010
- 5.1.1 Details on Errors/Failures
- 5.1.1.1 Core SRG
- 5.1.1.2 JPA SRG
- 5.1.1.3 Core LRG
- 5.1.1.4 JPA LRG
- 5.1.1.4.1 JPAAdvancedTestModel
- 5.1.1.4.2 CMP3InheritanceTestModel
- 5.1.1.4.3 CMP3ComplexAggregateTestModel
- 5.1.1.4.4 advanced.EntityManagerJUnitTestSuite
- 5.1.1.4.5 fieldaccess.advanced.EntityManagerJUnitTestSuite
- 5.1.1.4.6 fieldaccess.relationships.ExpressionJUnitTestSuite
- 5.1.1.4.7 JUnitJPQLSimpleTestSuite
- 5.1.1.4.8 JUnitJPQLComplexTestSuite
- 5.1.1.4.9 JUnitJPQLComplexTestSuite
- 5.1.1.4.10 JUnitJPQLComplexAggregateTestSuite
- 5.1.1.4.11 JUnitJPQLExamplesTestSuite
- 5.1.1.4.12 JUnitJPQLExamplesTestSuite
- 5.1.1.4.13 JUnitJPQLModifyTestSuite
- 5.1.1.4.14 EntityMappingsMergeInheritedJUnitTestCase
- 5.1.1.4.15 DDLGenerationJUnitTestSuite
- 5.1.1.4.16 JUnitCriteriaSimpleTestSuite
- 5.1.1 Details on Errors/Failures
- 5.1 October 4th 2010
- 6 Location of tests and examples
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 4th 2010
- EclipseLink + MaxDB platform (incubator) 2.2.0 (trunk) current build (revision: 8296)
- 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 | 7508 | 0 | 7 |
JPA LRG | 2162 | 5 | 27 |
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 |
JPA LRG
Test Case: org.eclipse.persistence.testing.tests.jpa.AllCMP3TestRunModel
JPAAdvancedTestModel
Test Name | Bug | Description/Reason |
---|---|---|
setup | Exception Description: XML_MERGE_PROJECT_SEQ: platform DatabasePlatform does not support NativeSequence |
CMP3InheritanceTestModel
Test Name | Bug | Description/Reason |
---|---|---|
setup | Same as JPAAdvancedTestModel |
CMP3ComplexAggregateTestModel
Test Name | Bug | Description/Reason |
---|---|---|
setup | Same as JPAAdvancedTestModel |
advanced.EntityManagerJUnitTestSuite
Test Name | Bug | Description/Reason |
---|---|---|
testLockWithJoinedInheritanceStrategy | bug 326799 | Same as testLockWithJoinedInheritanceStrategy in JPA SRG |
fieldaccess.advanced.EntityManagerJUnitTestSuite
Test Name | Bug | Description/Reason |
---|---|---|
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. |
fieldaccess.relationships.ExpressionJUnitTestSuite
Test Name | Bug | Description/Reason |
---|---|---|
testRightTrimWithoutTrimChar | Test error: No Customers found |
JUnitJPQLSimpleTestSuite
Test Name | Bug | Description/Reason |
---|---|---|
testOneEqualsOne | bug 326962 | SQLSyntaxErrorException: [-7016] (at 465): Parameter spec not allowed in this context |
JUnitJPQLComplexTestSuite
Test Name | Bug | Description/Reason |
---|---|---|
complexCoalesceInWhereTest | bug 316774 | Same as MultiPlatformTest5 in Core SRG |
complexCoalesceInSelectTest | bug 316774 | Same as MultiPlatformTest5 in Core SRG |
JUnitJPQLComplexTestSuite
Test Name | Bug | Description/Reason |
---|---|---|
complexCoalesceInWhereTest | bug 316774 | Same as MultiPlatformTest5 in Core SRG |
complexCoalesceInSelectTest | bug 316774 | Same as MultiPlatformTest5 in Core SRG |
JUnitJPQLComplexAggregateTestSuite
Test Name | Bug | Description/Reason |
---|---|---|
complexCountOnJoinedVariableOverManyToManySelfRefRelationship | Order column must be output column |
JUnitJPQLExamplesTestSuite
Test Name | Bug | Description/Reason |
---|---|---|
testDeleteExpression | Missing non-NULL value:QUANTITY | |
testComplexDeleteExpression | Same as testDeleteExpression |
JUnitJPQLExamplesTestSuite
Test Name | Bug | Description/Reason |
---|---|---|
testDeleteExpression | Missing non-NULL value:QUANTITY | |
testComplexDeleteExpression | Same as testDeleteExpression |
JUnitJPQLModifyTestSuite
Test Name | Bug | Description/Reason |
---|---|---|
updateDateTimeFields | Unknown column name:CURRENT_DATE Call: UPDATE CMP3_DATE_TIME SET SQL_DATE = CURRENT_DATE |
EntityMappingsMergeInheritedJUnitTestCase
Test Name | Bug | Description/Reason |
---|---|---|
testOneToManyRelationships | bug 326968 | Unknown table name or unknown schema:CMP3_MERGE_TELEPHONE |
testVerifyOneToManyRelationships | bug 326968 | NullPointerException |
testMappedSuperclassTransientField | bug 326968 | Same as testOneToManyRelationships |
testTransientField | bug 326968 | Same as testOneToManyRelationships |
testDeleteBeerConsumer | bug 326968 | Same as testOneToManyRelationships |
DDLGenerationJUnitTestSuite
Test Name | Bug | Description/Reason |
---|---|---|
testDDLUniqueKeysAsJoinColumns | Unknown table name or unknown schema:DDL_CKENTA | |
testDDLUnidirectionalOneToMany | Unknown table name or unknown schema:DDL_CKENT_C_B | |
testManyToManyWithMultipleJoinColumns | Same as testDDLUnidirectionalOneToMany |
JUnitCriteriaSimpleTestSuite
Test Name | Bug | Description/Reason |
---|---|---|
testOneEqualsOne | bug 326962 | Same as testOneEqualsOne |
simpleCoalesceInWhereTest | bug 316774 | Same as MultiPlatformTest5 in Core SRG |
simpleCoalesceInSelectTest | bug 316774 | Same as MultiPlatformTest5 in Core SRG |
Location of tests and examples
No specific tests or examples have been written