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.

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.
• The maximum width of an index is 1024 bytes on MaxDB. This also limits the size of a primary key. Moreover the primary key of join tables must not exceed this limit either. As it is composed of the primary key of the two tables that are joined, the combined width of the PKs of these two tables must not exceed this limit. See bug bug 326968.

Location

svn+ssh://dev.eclipse.org/svnroot/rt/org.eclipse.persistence/incubator/extensions/trunk/org.eclipse.persistence.platform.database.maxdb

Level of Testing

October 5th 2010

• EclipseLink + MaxDB platform (incubator) 2.2.0 (trunk) current build (revision: 8312) + patches from the following bugs
  • bug 326962
  • bug 326968 (attachement 180245)
  • bug 326991

• 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	2269	5	14
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

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

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

JUnitJPQLModifyTestSuite

Test Name	Bug	Description/Reason
updateDateTimeFields		Unknown column name:CURRENT_DATE Call: UPDATE CMP3_DATE_TIME SET SQL_DATE = CURRENT_DATE

JUnitCriteriaSimpleTestSuite

Test Name	Bug	Description/Reason
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