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.
Difference between revisions of "EclipseLink/Development/Incubator/Extensions/HANAPlatform"
< EclipseLink | Development | Incubator | Extensions
(→12. September 2012) |
(→JPA LRG) |
||
| Line 133: | Line 133: | ||
|- bgcolor="#ffe0e0" | |- bgcolor="#ffe0e0" | ||
| org.eclipse.persistence.testing.tests.jpa.advanced.JPAAdvancedTestModel.JPAAdvancedTestModel || n/a || platform DatabasePlatform does not support NativeSequence | | org.eclipse.persistence.testing.tests.jpa.advanced.JPAAdvancedTestModel.JPAAdvancedTestModel || n/a || platform DatabasePlatform does not support NativeSequence | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- bgcolor="#ffe0e0" | |- bgcolor="#ffe0e0" | ||
| org.eclipse.persistence.testing.tests.jpa.advanced.UpdateAllQueryAdvancedJunitTest.testFirstNamePrefixBLADoubleSalaryForSalaryForFirstName || n/a || Query requires temporary storage, but HANAPlatform doesn't support temporary tables | | org.eclipse.persistence.testing.tests.jpa.advanced.UpdateAllQueryAdvancedJunitTest.testFirstNamePrefixBLADoubleSalaryForSalaryForFirstName || n/a || Query requires temporary storage, but HANAPlatform doesn't support temporary tables | ||
|- bgcolor="#ffe0e0" | |- bgcolor="#ffe0e0" | ||
| − | | org.eclipse.persistence.testing.tests.jpa. | + | | org.eclipse.persistence.testing.tests.jpa.cascadedeletes.CascadeDeletesJUnitTestSuite.testDeletePrivateOwned || n/a || java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0 |
|- bgcolor="#ffe0e0" | |- bgcolor="#ffe0e0" | ||
| − | | org.eclipse.persistence.testing.tests.jpa.composite.advanced.EntityManagerJUnitTestSuite. | + | | org.eclipse.persistence.testing.tests.jpa.composite.advanced.EntityManagerJUnitTestSuite.testSequenceObjectDefinition || n/a || cannot use duplicate sequence name: TESTCOMPSEQOBJECTDEFINITION |
|- bgcolor="#ffe0e0" | |- bgcolor="#ffe0e0" | ||
| − | | org.eclipse.persistence.testing.tests.jpa. | + | | org.eclipse.persistence.testing.tests.jpa.criteria.AdvancedCriteriaQueryTestSuite.testCursors || n/a || Invalid argument resultSetType, use TYPE_FORWARD_ONLY. |
|- bgcolor="#ffe0e0" | |- bgcolor="#ffe0e0" | ||
| − | | org.eclipse.persistence.testing.tests.jpa. | + | | org.eclipse.persistence.testing.tests.jpa.criteria.AdvancedQueryTestSuite.testCursors || n/a || Invalid argument resultSetType, use TYPE_FORWARD_ONLY. |
|- bgcolor="#ffe0e0" | |- bgcolor="#ffe0e0" | ||
| − | | org.eclipse.persistence.testing.tests.jpa. | + | | org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testAssociationOverrideToEmbeddedManyToMany || n/a || invalid column name: invalid column name: JUSTTOTEST |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
|- bgcolor="#ffe0e0" | |- bgcolor="#ffe0e0" | ||
| org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testAssociationOverrideToEmbeddedManyToMany || n/a || invalid column name: invalid column name: JUSTTOTEST | | org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testAssociationOverrideToEmbeddedManyToMany || n/a || invalid column name: invalid column name: JUSTTOTEST | ||
| + | |- bgcolor="#ffe0e0" | ||
| + | | org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testDDLUniqueKeysAsJoinColumns || n/a || invalid column name: B_CODE | ||
|- bgcolor="#ffe0e0" | |- bgcolor="#ffe0e0" | ||
| org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testDDLUniqueKeysAsJoinColumns || n/a || invalid column name: B_CODE | | org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testDDLUniqueKeysAsJoinColumns || n/a || invalid column name: B_CODE | ||
|- bgcolor="#ffe0e0" | |- bgcolor="#ffe0e0" | ||
| org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testDeleteObjectWithEmbeddedManyToMany || n/a || invalid column name: JUSTTOTEST | | org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testDeleteObjectWithEmbeddedManyToMany || n/a || invalid column name: JUSTTOTEST | ||
| + | |- bgcolor="#ffe0e0" | ||
| + | | org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testDeleteObjectWithEmbeddedManyToMany || n/a || invalid column name: JUSTTOTEST | ||
| + | |- bgcolor="#ffe0e0" | ||
| + | | org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testManyToManyWithMultipleJoinColumns || n/a || invalid column name: B_CODE | ||
|- bgcolor="#ffe0e0" | |- bgcolor="#ffe0e0" | ||
| org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testManyToManyWithMultipleJoinColumns || n/a || invalid column name: B_CODE | | org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testManyToManyWithMultipleJoinColumns || n/a || invalid column name: B_CODE | ||
| + | |- bgcolor="#ffe0e0" | ||
| + | | org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testPrimaryKeyJoinColumns || n/a || invalid column name: NAME | ||
|- bgcolor="#ffe0e0" | |- bgcolor="#ffe0e0" | ||
| org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testPrimaryKeyJoinColumns || n/a || invalid column name: NAME | | org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testPrimaryKeyJoinColumns || n/a || invalid column name: NAME | ||
| Line 175: | Line 171: | ||
|- bgcolor="#ffe0e0" | |- bgcolor="#ffe0e0" | ||
| org.eclipse.persistence.testing.tests.jpa.fieldaccess.advanced.UpdateAllQueryAdvancedJunitTest.testFirstNamePrefixBLADoubleSalaryForSalaryForFirstName || n/a || Query requires temporary storage, but HANAPlatform doesn't support temporary tables | | org.eclipse.persistence.testing.tests.jpa.fieldaccess.advanced.UpdateAllQueryAdvancedJunitTest.testFirstNamePrefixBLADoubleSalaryForSalaryForFirstName || n/a || Query requires temporary storage, but HANAPlatform doesn't support temporary tables | ||
| − | |||
| − | |||
|- bgcolor="#ffe0e0" | |- bgcolor="#ffe0e0" | ||
| org.eclipse.persistence.testing.tests.jpa.jpql.AdvancedQueryTestSuite.testCursors || n/a || Invalid argument resultSetType, use TYPE_FORWARD_ONLY | | org.eclipse.persistence.testing.tests.jpa.jpql.AdvancedQueryTestSuite.testCursors || n/a || Invalid argument resultSetType, use TYPE_FORWARD_ONLY | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
Revision as of 14:58, 12 September 2012
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
Bugs
-
bug 380226(Database Platform for SAP HANA Database) - Initial bug for taking HANAPlatform to the incubator (resolved) - bug 383862 (Preparing Database Platform for SAP HANA Database for Promotion into trunk) - Bug for collecting/tracking test issues
Description
This is a subclass of DatabasePlatform that can be used by customers using the SAP HANA database.
Documentation
TBD
Limitations of the Platform
- Reserved SQL keywords cannot be used as table, column or sequence names. Use a different name, or enclose the name in double quotes. For example:
@Column(name="\"LANGUAGE\"") - Pessimistic locking adds 'FOR UPDATE' to the SELECT statement, and cannot be used with queries that use DISTINCT.
- Pessimistic locking cannot be used with queries that select from multiple tables - see bug 384129
- The LockNoWait option of Pessimistic Locking cannot be used; it is ignored when specified (i.e. only 'FOR UPDATE' is added to the SELECT statement).
- Bulk update and delete operations that require multiple tables to be accessed cannot be used (e.g. bulk operation on an entity that is part of an inheritance hierarchy, UpdateAll and DeleteAll queries).
- '= NULL' and '<> NULL' cannot be used for null comparisons in the WHERE clause. Use 'IS (NOT) NULL' instead.
- Scrollable cursors are not supported - see bug 384116.
- Query timeouts are not supported - see bug 384135.
Location
TBD
Level of Testing
12. September 2012
- EclipseLink master (commit 67decf461b874f1f690d09a93939a36fd33433a2, 11. September 2012) + HANA Platform (commit b6a28b9ce554168d9061bf647026edf2802a7d4d, 4. September 2012) + patches from the following bugs: bug 384237, TODO (select for update-bug)
- DB: SAP HANA 1.00.31.362930
- JDBC Driver: SAP In-Memory Database JDBC Driver 1.00.31 Build 0362930-1510
| Test Name | Tests | Failures/Errors |
|---|---|---|
| Core SRG | 693 | 0 |
| Core LRG | 7997 | 3 |
| JPA SRG | 238 | 8 |
| JPA WDF | 852 | 1 |
| JPA LRG | 2759 | 29 |
| Server LRG (GlassFish v3) | ? | ? |
Details on Errors/Failures
Core LRG
| Test Name | Bug | Description/Reason |
|---|---|---|
| org.eclipse.persistence.testing.tests.feature.CacheStatementBatchWritingTest.CacheStatementBatchWritingTest | n/a | Statements were not cached correctly |
| org.eclipse.persistence.testing.tests.queries.QueryFrameworkTestSuite$5.JoinSubclassesQueryTest | n/a | Invalid argument resultSetType, use TYPE_FORWARD_ONLY |
| org.eclipse.persistence.testing.tests.queries.QueryFrameworkTestSuite$5.JoinSubclassesQueryTest | n/a | Invalid argument resultSetType, use TYPE_FORWARD_ONLY |
JPA SRG
| Test Name | Bug | Description/Reason |
|---|---|---|
| org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testPESSIMISTIC_ExtendedScope | n/a | FOR UPDATE clause is not allowed here because of subquery or join in FROM clause |
| org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testPESSIMISTIC_FORCE_INCREMENTLock | n/a | FOR UPDATE clause is not allowed here because of subquery or join in FROM clause |
| org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testPESSIMISTIC_READLockWithNoChanges | n/a | FOR UPDATE clause is not allowed here because of subquery or join in FROM clause |
| org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testPESSIMISTIC_WRITELockWithNoChanges | n/a | FOR UPDATE clause is not allowed here because of subquery or join in FROM clause |
| org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testPessimisticLockHintStartsTransaction | n/a | FOR UPDATE clause is not allowed here because of subquery or join in FROM clause |
| org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testSequenceObjectDefinition | n/a | Transaction is currently active |
| org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testUpdateUsingTempStorage | n/a | Query requires temporary storage, but HANAPlatform doesn't support temporary tables |
| org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testUpdateUsingTempStorageWithParameter | n/a | Query requires temporary storage, but HANAPlatform doesn't support temporary tables |
JPA WDF
| Test Name | Bug | Description/Reason |
|---|---|---|
| org.eclipse.persistence.testing.tests.wdf.jpa1.generator.TestSequence.testAllocSize | n/a | wrong allocation expected:<4> but was:<2> |
JPA LRG
| Test Name | Bug | Description/Reason |
|---|---|---|
| org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testPESSIMISTIC_ExtendedScope | n/a | FOR UPDATE clause is not allowed here because of subquery or join in FROM clause |
| org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testPESSIMISTIC_FORCE_INCREMENTLock | n/a | FOR UPDATE clause is not allowed here because of subquery or join in FROM clause |
| org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testPESSIMISTIC_READLockWithNoChanges | n/a | FOR UPDATE clause is not allowed here because of subquery or join in FROM clause |
| org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testPESSIMISTIC_WRITELockWithNoChanges | n/a | FOR UPDATE clause is not allowed here because of subquery or join in FROM clause |
| org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testPessimisticLockHintStartsTransaction | n/a | FOR UPDATE clause is not allowed here because of subquery or join in FROM clause |
| org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testSequenceObjectDefinition | n/a | Transaction is currently active |
| org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testUpdateUsingTempStorage | n/a | Query requires temporary storage, but HANAPlatform doesn't support temporary tables |
| org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite.testUpdateUsingTempStorageWithParameter | n/a | Query requires temporary storage, but HANAPlatform doesn't support temporary tables |
| org.eclipse.persistence.testing.tests.jpa.advanced.JPAAdvancedTestModel.JPAAdvancedTestModel | n/a | platform DatabasePlatform does not support NativeSequence |
| org.eclipse.persistence.testing.tests.jpa.advanced.UpdateAllQueryAdvancedJunitTest.testFirstNamePrefixBLADoubleSalaryForSalaryForFirstName | n/a | Query requires temporary storage, but HANAPlatform doesn't support temporary tables |
| org.eclipse.persistence.testing.tests.jpa.cascadedeletes.CascadeDeletesJUnitTestSuite.testDeletePrivateOwned | n/a | java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0 |
| org.eclipse.persistence.testing.tests.jpa.composite.advanced.EntityManagerJUnitTestSuite.testSequenceObjectDefinition | n/a | cannot use duplicate sequence name: TESTCOMPSEQOBJECTDEFINITION |
| org.eclipse.persistence.testing.tests.jpa.criteria.AdvancedCriteriaQueryTestSuite.testCursors | n/a | Invalid argument resultSetType, use TYPE_FORWARD_ONLY. |
| org.eclipse.persistence.testing.tests.jpa.criteria.AdvancedQueryTestSuite.testCursors | n/a | Invalid argument resultSetType, use TYPE_FORWARD_ONLY. |
| org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testAssociationOverrideToEmbeddedManyToMany | n/a | invalid column name: invalid column name: JUSTTOTEST |
| org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testAssociationOverrideToEmbeddedManyToMany | n/a | invalid column name: invalid column name: JUSTTOTEST |
| org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testDDLUniqueKeysAsJoinColumns | n/a | invalid column name: B_CODE |
| org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testDDLUniqueKeysAsJoinColumns | n/a | invalid column name: B_CODE |
| org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testDeleteObjectWithEmbeddedManyToMany | n/a | invalid column name: JUSTTOTEST |
| org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testDeleteObjectWithEmbeddedManyToMany | n/a | invalid column name: JUSTTOTEST |
| org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testManyToManyWithMultipleJoinColumns | n/a | invalid column name: B_CODE |
| org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testManyToManyWithMultipleJoinColumns | n/a | invalid column name: B_CODE |
| org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testPrimaryKeyJoinColumns | n/a | invalid column name: NAME |
| org.eclipse.persistence.testing.tests.jpa.ddlgeneration.DDLGenerationExtendTablesJUnitTestSuite.testPrimaryKeyJoinColumns | n/a | invalid column name: NAME |
| org.eclipse.persistence.testing.tests.jpa.fieldaccess.advanced.EntityManagerJUnitTestSuite.testSequenceObjectDefinition | n/a | cannot use duplicate sequence name: TESTFASEQOBJECTSDEFINITION |
| org.eclipse.persistence.testing.tests.jpa.fieldaccess.advanced.EntityManagerJUnitTestSuite.testUpdateUsingTempStorage | n/a | Query requires temporary storage, but HANAPlatform doesn't support temporary tables |
| org.eclipse.persistence.testing.tests.jpa.fieldaccess.advanced.EntityManagerJUnitTestSuite.testUpdateUsingTempStorageWithParameter | n/a | Query requires temporary storage, but HANAPlatform doesn't support temporary tables |
| org.eclipse.persistence.testing.tests.jpa.fieldaccess.advanced.UpdateAllQueryAdvancedJunitTest.testFirstNamePrefixBLADoubleSalaryForSalaryForFirstName | n/a | Query requires temporary storage, but HANAPlatform doesn't support temporary tables |
| org.eclipse.persistence.testing.tests.jpa.jpql.AdvancedQueryTestSuite.testCursors | n/a | Invalid argument resultSetType, use TYPE_FORWARD_ONLY |
Location of tests and examples
No specific tests or examples have been written