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 (October 5th 2010)
m
 
(48 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.
+
 
+
=== 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
+
 
+
{|{{BMTableStyle}}
+
|-{{BMTHStyle}}
+
! 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
+
 
+
{|{{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.
+
|}
+
 
+
===== JPA SRG =====
+
 
+
Test Case: org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite
+
 
+
{|{{BMTableStyle}}
+
|-{{BMTHStyle}}
+
! 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
+
 
+
{|{{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
+
|-
+
| 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 ======
+
 
+
{|{{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 
+
|}
+
 
+
====== 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
+
|-
+
| 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
+
|}
+
 
+
====== JUnitCriteriaSimpleTestSuite ======
+
 
+
{|{{BMTableStyle}}
+
|-{{BMTHStyle}}
+
! 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
+

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