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 4th 2010)
(JPA LRG)
Line 119: Line 119:
 
Test Case: org.eclipse.persistence.testing.tests.jpa.AllCMP3TestRunModel
 
Test Case: org.eclipse.persistence.testing.tests.jpa.AllCMP3TestRunModel
  
====== JPAAdvancedTestModel ======
 
 
{|{{BMTableStyle}}
 
|-{{BMTHStyle}}
 
! Test Name
 
! Bug
 
! Description/Reason
 
|-
 
| setup ||  || Exception Description: XML_MERGE_PROJECT_SEQ: platform DatabasePlatform does not support NativeSequence
 
|}
 
 
====== CMP3InheritanceTestModel ======
 
 
{|{{BMTableStyle}}
 
|-{{BMTHStyle}}
 
! Test Name
 
! Bug
 
! Description/Reason
 
|-
 
| setup ||  || Same as JPAAdvancedTestModel
 
|}
 
 
====== CMP3ComplexAggregateTestModel ======
 
 
{|{{BMTableStyle}}
 
|-{{BMTHStyle}}
 
! Test Name
 
! Bug
 
! Description/Reason
 
|-
 
| setup ||  || Same as JPAAdvancedTestModel
 
|}
 
  
 
====== advanced.EntityManagerJUnitTestSuite ======
 
====== advanced.EntityManagerJUnitTestSuite ======
Line 199: Line 167:
 
|-
 
|-
 
| testRightTrimWithoutTrimChar ||  || Test error: No Customers found   
 
| testRightTrimWithoutTrimChar ||  || Test error: No Customers found   
|}
 
 
====== JUnitJPQLSimpleTestSuite ======
 
 
{|{{BMTableStyle}}
 
|-{{BMTHStyle}}
 
! Test Name
 
! Bug
 
! Description/Reason
 
|-
 
| testOneEqualsOne || {{bug|326962}} || SQLSyntaxErrorException: [-7016] (at 465): Parameter spec not allowed in this context
 
 
|}
 
|}
  
Line 269: Line 226:
 
|-
 
|-
 
| updateDateTimeFields ||  || Unknown column name:CURRENT_DATE Call: UPDATE CMP3_DATE_TIME SET SQL_DATE = CURRENT_DATE
 
| updateDateTimeFields ||  || Unknown column name:CURRENT_DATE Call: UPDATE CMP3_DATE_TIME SET SQL_DATE = CURRENT_DATE
|}
 
 
====== EntityMappingsMergeInheritedJUnitTestCase ======
 
 
{|{{BMTableStyle}}
 
|-{{BMTHStyle}}
 
! Test Name
 
! Bug
 
! Description/Reason
 
|-
 
| testOneToManyRelationships || {{bug|326968}} || Unknown table name or unknown schema:CMP3_MERGE_TELEPHONE
 
|-
 
| testVerifyOneToManyRelationships || {{bug|326968}} || NullPointerException
 
|-
 
| testMappedSuperclassTransientField || {{bug|326968}} || Same as testOneToManyRelationships
 
|-
 
| testTransientField || {{bug|326968}} || Same as testOneToManyRelationships
 
|-
 
| testDeleteBeerConsumer || {{bug|326968}} || Same as testOneToManyRelationships
 
 
|}
 
|}
  
Line 312: Line 250:
 
! Bug
 
! Bug
 
! Description/Reason
 
! Description/Reason
|-
 
| testOneEqualsOne || {{bug|326962}} || Same as testOneEqualsOne
 
 
|-
 
|-
 
| simpleCoalesceInWhereTest || {{bug|316774}} || Same as MultiPlatformTest5 in Core SRG
 
| simpleCoalesceInWhereTest || {{bug|316774}} || Same as MultiPlatformTest5 in Core SRG

Revision as of 07:00, 5 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

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

  • 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 17
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
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
DDLGenerationJUnitTestSuite
Test Name Bug Description/Reason
testDDLUniqueKeysAsJoinColumns Unknown table name or unknown schema:DDL_CKENTA
testDDLUnidirectionalOneToMany Unknown table name or unknown schema:DDL_CKENT_C_B
testManyToManyWithMultipleJoinColumns Same as testDDLUnidirectionalOneToMany
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

Back to the top