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 (Level of Testing)
(PessimisticLockingExtendedScopeTestSuite)
Line 127: Line 127:
 
! Description/Reason
 
! Description/Reason
 
|- bgcolor="#ffe0e0"
 
|- bgcolor="#ffe0e0"
| testPESSMISTIC_ES5 || {{bug|327472}} || SQLTransactionRollbackException: [600]: Work rolled back,DEADLOCK DETECTED  
+
| testPESSMISTIC_ES5 || {{bug|327472}} || SQLTransactionRollbackException: [600]: Work rolled back,DEADLOCK DETECTED '''Filed as MaxDB issue 3138792 2010'''
 
|}
 
|}
  

Revision as of 09:41, 12 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.

Bug

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.
  • VARCHAR [UNICODE] columns do not preserve trailing spaces - see bug 327435 .

Location

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

Level of Testing

October 11th, 2010

  • EclipseLink + MaxDB platform (incubator) 2.2.0 (trunk) current build (revision: 8347)
  • DB: MaxDB, kernel 7.8.01 build 004-123-218-928
  • JDBC driver: MaxDB JDBC Driver, SAP AG, 7.6.06 Build 006-000-009-234 (Make-Version: 7.8.01 Build 003-123-215-703)
Test Name Tests Failures Errors
Core SRG 690 0 1 (*)
JPA SRG 202 0 1
JPA WDF 816 0 0
Core LRG 7508 0 2 (*)
JPA LRG 2271 2 1
Server LRG (GlassFish v3)  ?  ?  ?

(*) Reported as MaxDB JDBC Driver Bug

Details on Errors/Failures

Core SRG

Test Case: org.eclipse.persistence.testing.tests.SRGTestModel

Test Name Bug Description/Reason
ScrollableCursorNavigationAPIConformingTest bug 326646 cursor.last() does not result in cursor.isLast() returning true. Filed as MaxDB JDBC driver issue 3124858 2010
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
ScrollableCursorNavigationAPIConformingTest bug 326646 Same as ScrollableCursorNavigationAPIConformingTest in Core SRG (Filed as MaxDB JDBC driver issue 3124858 2010)
ScrollableCursorNavigationAPIConformingTest bug 326646 Same as ScrollableCursorNavigationAPIConformingTest in Core SRG (Filed as MaxDB JDBC driver issue 3124858 2010)
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
PessimisticLockingExtendedScopeTestSuite
Test Name Bug Description/Reason
testPESSMISTIC_ES5 bug 327472 SQLTransactionRollbackException: [600]: Work rolled back,DEADLOCK DETECTED Filed as MaxDB issue 3138792 2010
fieldaccess.relationships.ExpressionJUnitTestSuite
Test Name Bug Description/Reason
testRightTrimWithoutTrimChar bug 327435 Test error: No Customers found

Location of tests and examples

No specific tests or examples have been written

Back to the top