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/Testing"

(Testing)
 
(39 intermediate revisions by 7 users not shown)
Line 1: Line 1:
=Testing=
+
== Automated Test Runs ==
  
This is the main testing page for EclipseLink.
+
* [http://www.eclipse.org/eclipselink/downloads/nightly.php Nightly test results]
  
* [http://www.eclipse.org/eclipselink/testing/index.php Nightly runs results]
+
== Required Libraries ==
* [[EclipseLink/Development/Testing/Status|Current Test Status]]
+
=== Oracle 11g/12c ===
 +
JDBC Driver for Java SE >= 7:
 +
[http://www.oracle.com/technetwork/database/features/instant-client/index.html Oracle database instant client download]
 +
[http://www.oracle.com/technetwork/database/features/jdbc/index.html Oracle 12c JDBC and UCP]
 +
* '''ojdbc7.jar''' is available on [http://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html JDBC driver download page]
 +
* '''orai18n.jar''' is available on [http://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html JDBC driver download page]
 +
* '''orai18n-mapping.jar''' could be found in
 +
** Oracle database as ${ORACLE_HOME}/jlib/orai18n-mapping.jar
 +
** WebLogic as oracle_common/modules/oracle.nlsrtl/orai18n-mapping.jar
 +
* '''aqapi.jar''' could be found in WebLogic as oracle_common/modules/oracle.jdbc/aqapi.jar
 +
* '''dms.jar''' could be found in WebLogic as oracle_common/modules/oracle.dms/dms.jar
 +
* '''xmlparserv2.jar''' could be found in WebLogic as oracle_common/modules/oracle.xdk/xmlparserv2_sans_jaxp_services.jar
 +
* '''kvclient.jar''' is available on [http://www.oracle.com/technetwork/database/database-technologies/nosqldb/downloads/index.html Oracle NoSQL database download page]
 +
* '''sdoapi.jar''' could be found in Oracle database as ${ORACLE_HOME}md/jlib (part of Oracle Spatial extension).
 +
* '''xdb.jar''' is available on [http://www.oracle.com/technetwork/database/features/jdbc/default-2280470.html JDBC driver download page]. Rename xdb6.jar to xdb.jar after download.
 +
* '''ucp.jar''' is available on [http://www.oracle.com/technetwork/database/enterprise-edition/downloads/ucp-112010-099129.html UCP download page]
 +
 
 +
== Test Database Setup ==
 +
=== Oracle 11g/12c ===
 +
 
 +
Default EE standalone database installation should work fine.
 +
* User needs rights to execute DBMS_RLS, DBMS_FLASHBACK and DBMS_SESSION packages.
 +
* Database character set should be AL32UTF8.
 +
 
 +
  CREATE USER user_name IDENTIFIED BY user_password;
 +
  GRANT CONNECT, RESOURCE TO user_name;
 +
  GRANT ALL PRIVILEGES TO user_name IDENTIFIED BY user_password;
 +
  GRANT EXECUTE ON DBMS_RLS TO user_name;
 +
  GRANT EXECUTE ON DBMS_FLASHBACK TO user_name;
 +
  GRANT EXECUTE ON DBMS_SESSION TO user_name;
 +
 
 +
Sample test properties for Oracle 11g database:
 +
 
 +
  jdbc.driver.jar=/some/path/ojdbc7.jar
 +
  db.driver=oracle.jdbc.OracleDriver
 +
  db.url=jdbc:oracle:thin:@//myhost.domain.tld:1521/my.service.name
 +
  db.oci.url=jdbc:oracle:oci:@//myhost.domain.tld:1521/my.service.name
 +
  db.user=ORA_USER
 +
  db.pwd=Or4Us3rP4ssw0rd
 +
  db.platform=org.eclipse.persistence.platform.database.oracle.Oracle11Platform
 +
  db.sys.pwd=Or4Adm1nP4ssw0rd
 +
Use ''db.oci.url'' only if you have OCI driver available including all dependencies.
 +
 
 +
== How to Run tests ==
 +
 
 +
Generic instructions for running tests: [[EclipseLink/Building#Testing | EclipseLink/Building#Testing]]
 +
 
 +
More detailed information for specific test suites:
 
* [[/foundation|Foundation testing]]
 
* [[/foundation|Foundation testing]]
 
* [[/JPA|JPA testing]]
 
* [[/JPA|JPA testing]]
* [[/MOXy|Moxy testing]]
+
* [[/MOXy|MOXy testing]]
 
* [[/SDO|SDO testing]]
 
* [[/SDO|SDO testing]]
 
* [[/DBWS|DBWS testing]]
 
* [[/DBWS|DBWS testing]]
 
* [[EclipseLink/Development/Performance|Performance testing]]
 
* [[EclipseLink/Development/Performance|Performance testing]]
 
+
* [[/CacheCoordination|CacheCoordination testing]]
===Links:===
+
* [[EclipseLink/Building| Building EclipseLink]]
+
* [[EclipseLink/Test/Prereq| Prerequisites for building & running EclipseLink tests]]
+
* [[EclipseLink/Development/Testing/Frameworks|Testing Frameworks]]
+
 
+
==Bugzilla==
+
* [https://bugs.eclipse.org/bugs/report.cgi?x_axis_field=component&y_axis_field=bug_severity&z_axis_field=&query_format=report-table&short_desc_type=allwordssubstr&short_desc=&classification=Technology&product=EPS%28EclipseLink%29&long_desc_type=allwordssubstr&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&keywords_type=allwords&keywords=&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&emailtype1=substring&email1=&emailtype2=substring&email2=&bugidtype=include&bug_id=&votes=&chfieldfrom=&chfieldto=Now&chfieldvalue=&format=table&action=wrap&field0-0-0=noop&type0-0-0=noop&value0-0-0= Open bugs report]
+
 
+
== Meeting Minutes ==
+
* [http://dev.eclipse.org/mhonarc/lists/eclipselink-dev/msg00368.html Test strategy discussion 2007-12-06]
+
 
+
[[Category:EclipseLink|Testing]]
+

Latest revision as of 14:03, 18 April 2015

Automated Test Runs

Required Libraries

Oracle 11g/12c

JDBC Driver for Java SE >= 7: Oracle database instant client download Oracle 12c JDBC and UCP

  • ojdbc7.jar is available on JDBC driver download page
  • orai18n.jar is available on JDBC driver download page
  • orai18n-mapping.jar could be found in
    • Oracle database as ${ORACLE_HOME}/jlib/orai18n-mapping.jar
    • WebLogic as oracle_common/modules/oracle.nlsrtl/orai18n-mapping.jar
  • aqapi.jar could be found in WebLogic as oracle_common/modules/oracle.jdbc/aqapi.jar
  • dms.jar could be found in WebLogic as oracle_common/modules/oracle.dms/dms.jar
  • xmlparserv2.jar could be found in WebLogic as oracle_common/modules/oracle.xdk/xmlparserv2_sans_jaxp_services.jar
  • kvclient.jar is available on Oracle NoSQL database download page
  • sdoapi.jar could be found in Oracle database as ${ORACLE_HOME}md/jlib (part of Oracle Spatial extension).
  • xdb.jar is available on JDBC driver download page. Rename xdb6.jar to xdb.jar after download.
  • ucp.jar is available on UCP download page

Test Database Setup

Oracle 11g/12c

Default EE standalone database installation should work fine.

  • User needs rights to execute DBMS_RLS, DBMS_FLASHBACK and DBMS_SESSION packages.
  • Database character set should be AL32UTF8.
 CREATE USER user_name IDENTIFIED BY user_password;
 GRANT CONNECT, RESOURCE TO user_name;
 GRANT ALL PRIVILEGES TO user_name IDENTIFIED BY user_password;
 GRANT EXECUTE ON DBMS_RLS TO user_name;
 GRANT EXECUTE ON DBMS_FLASHBACK TO user_name;
 GRANT EXECUTE ON DBMS_SESSION TO user_name;

Sample test properties for Oracle 11g database:

 jdbc.driver.jar=/some/path/ojdbc7.jar
 db.driver=oracle.jdbc.OracleDriver
 db.url=jdbc:oracle:thin:@//myhost.domain.tld:1521/my.service.name
 db.oci.url=jdbc:oracle:oci:@//myhost.domain.tld:1521/my.service.name
 db.user=ORA_USER
 db.pwd=Or4Us3rP4ssw0rd
 db.platform=org.eclipse.persistence.platform.database.oracle.Oracle11Platform
 db.sys.pwd=Or4Adm1nP4ssw0rd

Use db.oci.url only if you have OCI driver available including all dependencies.

How to Run tests

Generic instructions for running tests: EclipseLink/Building#Testing

More detailed information for specific test suites:

Back to the top