Skip to main content

Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.

Jump to: navigation, search

Difference between revisions of "EclipseLink/Development/Incubator/Extensions/MaxDBPlatform"

m (Core LRG)
m
 
(103 intermediate revisions by 2 users not shown)
Line 1: Line 1:
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.
+
'''Note: This page has become obsolete as the database platform for SAP MaxDB has been promoted from incubation to the main EclipseLink repository starting with release 2.2.0.'''
  
== Bug ==
+
Information on the MaxDB database platform is maintained [[EclipseLink/Development/DatabasePlatform/MaxDBPlatform|here]].
 
+
*{{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&<strong>amp;</strong>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.
+
 
+
==Location==
+
 
+
svn+ssh://dev.eclipse.org/svnroot/rt/org.eclipse.persistence/incubator/extensions/trunk/org.eclipse.persistence.platform.database.maxdb
+
 
+
== Level of Testing  ==
+
 
+
=== September 21/2010 ===
+
 
+
* EclipseLink 2.2.0 (trunk) current build (revision: 8220)
+
* 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
+
 
+
{|{{BMTableStyle}}
+
|-{{BMTHStyle}}
+
! Test Name
+
! Tests
+
! Failures
+
! Errors
+
|-
+
| Core SRG || 691 || 0 || 5
+
|-
+
| JPA SRG || 202 || 0 || 7
+
|-
+
| JPA WDF || 815 || 0 || 0
+
|-
+
| Core LRG || 7440 || 0 || 45
+
|-
+
| JPA LRG || 2157 || 6 || 67
+
|-
+
| Server LRG (GlassFish v3)|| ? || ? || ?
+
|}
+
 
+
==== Details on Errors/Failures ====
+
 
+
===== Core SRG =====
+
 
+
Test Case: org.eclipse.persistence.testing.tests.SRGTestModel
+
 
+
{|{{BMTableStyle}}
+
|-{{BMTHStyle}}
+
! 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.
+
|-
+
| 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
+
 
+
{|{{BMTableStyle}}
+
|-{{BMTHStyle}}
+
! 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
+
|-
+
| testLockWithJoinedInheritanceStrategy || {{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
+
|}
+
 
+
===== Core LRG =====
+
 
+
Test Case: org.eclipse.persistence.testing.tests.TestRunModel
+
 
+
{|{{BMTableStyle}}
+
|-{{BMTHStyle}}
+
! Test Name
+
! Bug
+
! Description/Reason
+
|-
+
| MultiPlatformTest5 || {{bug|316774}} || Same as MultiPlatformTest5 in Core SRG
+
|-
+
| ScrollableCursorNavigationAPIConformingTest || {{bug|326646}} || Same as ScrollableCursorNavigationAPIConformingTest in Core SRG
+
|-
+
| PessimisticLockTest(mode=1) || {{bug|325839}}  || Same as PessimisticLockTest(mode=1) in Core SRG
+
|-
+
| PessimisticLockEmptyTransactionTest || {{bug|325839}} || Same as PessimisticLockEmptyTransactionTest in Core SRG
+
|-
+
| QueryTimeoutTest || {{bug|326503}} || Same as QueryTimeoutTest in Core SRG
+
|-
+
| QueryTimeoutConnectionReleasedTest || {{bug|326503}} || Same as QueryTimeoutTest in Core SRG
+
|-
+
| MultiPlatformTest5 || {{bug|316774}} || Same as MultiPlatformTest5 in Core SRG
+
|-
+
| ScrollableCursorNavigationAPIConformingTest || {{bug|326646}} || Same as ScrollableCursorNavigationAPIConformingTest in Core SRG
+
|-
+
| PessimisticLockTest(mode=1) || {{bug|325839}}  || Same as PessimisticLockTest(mode=1) in Core SRG
+
|-
+
| PessimisticLockEmptyTransactionTest || {{bug|325839}} || Same as PessimisticLockEmptyTransactionTest in Core SRG
+
|-
+
| QueryTimeoutTest || {{bug|326503}} || Same as QueryTimeoutTest in Core SRG
+
|-
+
| QueryTimeoutConnectionReleasedTest || {{bug|326503}} || Same as QueryTimeoutTest 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
+
|-
+
| OneToManyJoinOptimizationTest ||  || Exception Description: OneToManyJoinOptimizationTest Verify Failed:null != [Employee: Jill May]
+
|-
+
| UpdateNullOneToOneValueTest (AllFieldsLockingPolicy) ||  || SAP DBTech JDBC: Cannot put ASCII data into this LONG column.
+
|-
+
| UpdateNullOneToOneValueTest (SelectedFieldsLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullOneToOneValueTest (ChangedFieldsLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullOneToOneValueTest (VersionLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullOneToOneValueTest (TimestampLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullAggregateValueTest (AllFieldsLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullAggregateValueTest (SelectedFieldsLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullAggregateValueTest (ChangedFieldsLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullAggregateValueTest (VersionLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullAggregateValueTest (TimestampLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullOneToManyValueTest (AllFieldsLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullOneToManyValueTest (SelectedFieldsLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullOneToManyValueTest (ChangedFieldsLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullOneToManyValueTest (VersionLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullOneToManyValueTest (TimestampLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullTransformationValueTest (AllFieldsLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullTransformationValueTest (SelectedFieldsLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullTransformationValueTest (ChangedFieldsLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullTransformationValueTest (VersionLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullTransformationValueTest (TimestampLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullManyToManyValueTest (AllFieldsLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullManyToManyValueTest (SelectedFieldsLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullManyToManyValueTest (ChangedFieldsLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullManyToManyValueTest (VersionLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| UpdateNullManyToManyValueTest (TimestampLockingPolicy) ||  || Same as UpdateNullOneToOneValueTest (AllFieldsLockingPolicy)
+
|-
+
| TypeTestModelWithAccessors with Accessors ||  || Invalid length for this data type:THECLOB - VARCHAR(25000) UNICODE
+
|-
+
| TypeTestModelWithOutAccessors without Accessors ||  || Same as TypeTestModelWithAccessors with Accessors
+
|-
+
| UnitOfWorkComplexRefreshTest ||  || com.sap.dbtech.jdbc.exceptions.jdbc40.SQLNonTransientConnectionException: [-708] Data receive failed. Error Code: -708
+
|-
+
| UnitOfWorkComplexRefreshTest ||  || com.sap.dbtech.jdbc.exceptions.jdbc40.SQLNonTransientConnectionException: [-708] Data receive failed. Error Code: -708
+
|}
+
 
+
===== JPA LRG =====
+
 
+
Test Case: org.eclipse.persistence.testing.tests.jpa.AllCMP3TestRunModel
+
 
+
{|{{BMTableStyle}}
+
|-{{BMTHStyle}}
+
! 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
+
|-
+
| 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
+
|-
+
| testLockWithJoinedInheritanceStrategy || {{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
+
|-
+
| testFindDeleteAllPersist ||  || Duplicate key Call: INSERT INTO CMP3_FA_SALARY (SALARY, EMP_ID) VALUES (?, ?) bind => [0, 62]  
+
|-
+
| testExtendedPersistenceContext ||  || Duplicate key Call: INSERT INTO CMP3_FA_SALARY (SALARY, EMP_ID) VALUES (?, ?) bind => [0, 63]  
+
|-
+
| testRemoveFlushPersistContains ||  || Duplicate key Call: INSERT INTO CMP3_FA_SALARY (SALARY, EMP_ID) VALUES (?, ?) bind => [0, 68]
+
|-
+
| testPersistRemoved ||  || Duplicate key Call: INSERT INTO CMP3_FA_SALARY (SALARY, EMP_ID) VALUES (?, ?) bind => [11000, 126]
+
|-
+
| testIdentityOutsideTransaction ||  || NullPointerException
+
|-
+
| testIdentityInsideTransaction ||  || NullPointerException
+
|-
+
| testDeleteEmployee ||  || Object not deleted from the database correctly: Employee: 153
+
|-
+
| 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 
+
|-
+
| simpleSerializeAndMerge ||  || Unresolved compilation problem: Type mismatch: cannot convert from Object to Employee 
+
|-
+
| cacheFull_FindWithFetchGroup_Simple ||  || Unresolved compilation problem: Type mismatch: cannot convert from Object to Employee 
+
|-
+
| 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
+
|-
+
| 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
+
|-
+
| 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
+
|-
+
| simpleSerializeAndMerge ||  || Unresolved compilation problem: Type mismatch: cannot convert from Object to Employee 
+
|-
+
| cacheFull_FindWithFetchGroup_Simple ||  || Unresolved compilation problem: Type mismatch: cannot convert from Object to Employee 
+
|}
+
 
+
=== Older Test Runs ===
+
 
+
*July, 16, 2010 WDFd Test suite runs with 3 issues (all to be skipped)
+
** TestSetFunctions.testSum, TestSelectListTypes.testSumBigDecimal - The test calculates sum() of a BigDecimal attribute. The return type should be BigDecimal but Double is returned instead. https://bugs.eclipse.org/bugs/show_bug.cgi?id=320120
+
** TestGroupByOrderByHaving.testSubQueryGroupBy3 - The test assumes that an error is detected in the query but the execution succeeds on MaxDB. The query in question is "SELECT t0.ID, t0.COOL, t0.NAME, t0.TYPE, t0.CITY_ENUM, t0.CITY_TESLA_INT, t0.CITY_TESLA_BLOB FROM TMP_CITY t0 WHERE EXISTS (SELECT 1 FROM TMP_COP t2, TMP_COP t1 WHERE (t2.ID = t1.PARTNER_ID) GROUP BY t1.ID HAVING (t2.ID = 5))". Actually, it should fail on the database as t2.ID is no grouping column. Seems to a MaxDB issue. The test will be skipped on MaxDB.
+
 
+
*June 22, 2010 SRG Test suite runs with MaxDb except 3 problems
+
** MultiPlatformTest5 fails because coalesce is not recognized as function see bug 317286
+
** PessimisticLockTest(EmptyTransactionTest) can not work because MaxDb can not do select for update with more than one table
+
** QueryTimeoutTest does not work because MaxDb does not recognize timeout settings on statement level
+
 
+
*Sept 3, 2009 - Initial check-in from TopLink Essentials Class - compile-only, no database-level testing. Initial development was done on TopLink Essentials, so there may be some changes needed to even make existing functionality work
+
 
+
== Location of tests and examples==
+
 
+
No specific tests or examples have been written
+

Latest revision as of 07:34, 19 October 2010

Note: This page has become obsolete as the database platform for SAP MaxDB has been promoted from incubation to the main EclipseLink repository starting with release 2.2.0.

Information on the MaxDB database platform is maintained here.

Back to the top