View source for EclipseLink/Development/DatabasePlatform/SymfowarePlatform/TestResults2.4.2

The following are the test results for [[EclipseLink/Development/DatabasePlatform/SymfowarePlatform|SymfowarePlatform]]. 

== Test Results(July 9/2013) ==

=== EclipseLink 2.4.2 and Symfoware Server v 10.0.0 ===

*EclipseLink 2.4.2
*DB: Symfoware Server V10.0.0 
*JDBC driver: Symfoware JDBC 4.0 driver (RDB2_TCP) 
*JDK: Sun JDK6(jdk1.6.0_32-b05) 
*OS: Windows 7(64bit)

{| cellspacing="0" cellpadding="5" border="1"
|-
! Test Name 
! Tests 
! Failures 
! Errors
|-
| Core SRG 
| 693 
| 0 
| 0
|-
| JPA SRG 
| 243 
| 0 
| 0
|-
| Core LRG 
| 7995 
| 0
| 0
|-
| JPA LRG 
| 2859 
| 0 
| 0
|-
| Server LRG (GlassFish v3)
| - 
| - 
| -
|}

''Testing durations (SRG tests are included in LRG tests)'' 

*Core LRG: 49min. 
*JPA LRG: 53min.


=== EclipseLink 2.4.2 and Symfoware Server v 10.1.0 ===

*EclipseLink 2.4.2 
*DB: Symfoware Server V10.1.0 
*JDBC driver: Symfoware JDBC 4.0 driver (RDB2_TCP) 
*JDK: Sun JDK6(jdk1.6.0_32-b05) 
*OS: Windows 7(64bit) 

{| cellspacing="0" cellpadding="5" border="1"
|-
! Test Name 
! Tests 
! Failures 
! Errors
|-
| Core SRG 
| 693 
| 0 
| 0
|-
| JPA SRG 
| 243 
| 0 
| 0
|-
| Core LRG 
| 7995 
| 0
| 0
|-
| JPA LRG 
| 2859 
| 0 
| 0
|-
| Server LRG (GlassFish v3)
| - 
| - 
| -
|}

''Testing durations (SRG tests are included in LRG tests)'' 

*Core LRG: 49min.
*JPA LRG: 61min.

== The Details of Test Suites ==

{| cellspacing="0" cellpadding="5" border="1"
|-
! Test Suite 
! Ant Target 
! Test Location 
! Test Class 
! Wiki
|-
| Core SRG 
| test-srg 
| foundation/eclipselink.core.test 
| org.eclipse.persistence.testing.tests.SRGTestModel 
| [[EclipseLink/Development/Testing/foundation]]
|-
| Core LRG 
| test-lrg 
| foundation/eclipselink.core.test 
| org.eclipse.persistence.testing.tests.TestRunModel 
| [[EclipseLink/Development/Testing/foundation]]
|-
| JPA SRG 
| test-srg 
| jpa/eclipselink.jpa.test 
| org.eclipse.persistence.testing.tests.jpa.advanced.EntityManagerJUnitTestSuite 
| [[EclipseLink/Development/Testing/JPA]]
|-
| JPA LRG 
| test-lrg 
| jpa/eclipselink.jpa.test 
| org.eclipse.persistence.testing.tests.jpa.AllCMP3TestRunModel<br>
org.eclipse.persistence.testing.tests.jpa.xml.EntityMappingsJUnitTestSuite 
| [[EclipseLink/Development/Testing/JPA]]
|-
|}


For JPA LRG, build.xml of jpa/eclipselink.jpa.test was edited to avoid table locking issues on Symfoware.<br>
Sleep 1 minute was inserted between AllCMP3TestRunModel and EntityMappingsJUnitTestSuite.

== Test Configuration Notes  ==

*Install Symfoware Server Client on the machine that EclipseLink is installed on. 
*For the JPA and Foundation Test Suites, update the respective test.properties files with your JDBC connection settings.<br>

For example: 

 jdbc.driver.jar=c:/SFWCLNT/JDBC/fjjdbc/lib/fjsymjdbc4.jar
 db.driver=com.fujitsu.symfoware.jdbc.SYMDriver
 db.url=jdbc:symford://symfodb:56005/TESTDB;javaconverter=UTF-8
 db.user=symfouser
 db.pwd=symfopwd
 db.platform=org.eclipse.persistence.platform.database.SymfowarePlatform
 db.platform.jvmargs=-Declipselink.test.toggle-fast-table-creator=true

Note the following: 

;jdbc.driver.jar 
:Should include the path to the JDBC driver libraries. Refer to the Symfoware Server Client manual for details, and use the correct driver for your JDK version. 
:Should include the path to the Symfoware Platform class. 
;db.platform 
:The platform name is ''org.eclipse.persistence.platform.database.SymfowarePlatform''. 
;db.url 
:javaconverter=UTF-8 was added to handle special characters.
;db.platform.jvmargs 
:This JVM argument is read by EclipseLink's test suite. It will prevent tests that reuse tables to try to drop and recreate tables (as this can lead to table lock errors if the original connection is still open). Instead, it will force them to just delete the rows in the tables.

*Also, include the JDBC driver native libraries in your PATH (Windows) or LD_LIBRARY_PATH (Unix). 
*If you face the lack of database space while executing tests, configure DEFAULT_TABLE_SIZE and DEFAULT_INDEX_SIZE.<br>

For example: 

 DEFAULT_TABLE_SIZE=8,500,300,50
 DEFAULT_INDEX_SIZE=8,8,500,100,100,100