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) |
(→October 11th, 2010) |
||
Line 54: | Line 54: | ||
|- bgcolor="#ffffe0" | |- bgcolor="#ffffe0" | ||
| Core LRG || 7508 || 0 || 2 (*) | | Core LRG || 7508 || 0 || 2 (*) | ||
− | |- bgcolor="# | + | |- bgcolor="#ffffe0" |
− | | JPA LRG || 2271 || | + | | JPA LRG || 2271 || 0 || 1 (**) |
|- | |- | ||
| Server LRG (GlassFish v3)|| ? || ? || ? | | Server LRG (GlassFish v3)|| ? || ? || ? | ||
Line 61: | Line 61: | ||
(*) Reported as MaxDB JDBC Driver Bug | (*) Reported as MaxDB JDBC Driver Bug | ||
+ | (**) Reported as MaxDB Bug, investigation pending | ||
==== Details on Errors/Failures ==== | ==== Details on Errors/Failures ==== |
Revision as of 16:55, 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.
Contents
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.
- VARCHAR [UNICODE] columns do not preserve trailing spaces - see bug 327435 .
- The hint "javax.persistence.lock.timeout=0" (NOWAIT) has no effect when atempting to pessimistically lock an entity with inheritance type JOINED - see bug 326799 .
Location
Level of Testing
October 11th, 2010
- EclipseLink + MaxDB platform (incubator) 2.2.0 (trunk) current build (revision: 8352)
- 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 | 0 |
JPA WDF | 816 | 0 | 0 |
Core LRG | 7508 | 0 | 2 (*) |
JPA LRG | 2271 | 0 | 1 (**) |
Server LRG (GlassFish v3) | ? | ? | ? |
(*) Reported as MaxDB JDBC Driver Bug (**) Reported as MaxDB Bug, investigation pending
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 |
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
PessimisticLockingExtendedScopeTestSuite
Test Name | Bug | Description/Reason |
---|---|---|
testPESSMISTIC_ES5 | bug 327472 | SQLTransactionRollbackException: [600]: Work rolled back,DEADLOCK DETECTED (Filed as MaxDB issue 3138792 2010) |
Location of tests and examples
No specific tests or examples have been written