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"

m (References)
 
(26 intermediate revisions by 2 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/downloads/nightly.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]]
Line 12: Line 59:
 
* [[EclipseLink/Development/Performance|Performance testing]]
 
* [[EclipseLink/Development/Performance|Performance testing]]
 
* [[/CacheCoordination|CacheCoordination testing]]
 
* [[/CacheCoordination|CacheCoordination testing]]
 
===Links:===
 
* [[EclipseLink/Building| Building EclipseLink]]
 
* [[EclipseLink/Source|Source]]
 
* [[EclipseLink/Development/Testing/Prereq| Prerequisites for building & running EclipseLink tests]]
 
* [[EclipseLink/Development/Testing/Frameworks|Testing Frameworks]]
 
* [[EclipseLink/Debugging| Debugging EclipseLink]]
 
* [[EclipseLink/Development/Testing/DatabaseCertification | Certifying a new DatabasePlatform]]
 
 
==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=RT&product=EclipseLink&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= Report of open bugs by severity by component]
 
* [https://bugs.eclipse.org/bugs/report.cgi?x_axis_field=component&y_axis_field=bug_status&z_axis_field=&query_format=report-table&short_desc_type=allwordssubstr&short_desc=&classification=RT&product=EclipseLink&long_desc_type=allwordssubstr&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&keywords_type=allwords&keywords=&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= Report of all bugs by status by component]
 
* [https://bugs.eclipse.org/bugs/buglist.cgi?query_format=advanced&short_desc_type=allwordssubstr&short_desc=&classification=RT&product=EclipseLink&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=&cmdtype=doit&order=Reuse+same+sort+as+last+time&field0-0-0=noop&type0-0-0=noop&value0-0-0= All open bugs]
 
* [https://bugs.eclipse.org/bugs/buglist.cgi?query_format=advanced&short_desc_type=allwordssubstr&short_desc=&classification=RT&product=EclipseLink&component=Foundation&component=JPA&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=&cmdtype=doit&order=Reuse+same+sort+as+last+time&field0-0-0=noop&type0-0-0=noop&value0-0-0= Open ORM bugs]
 
* [https://bugs.eclipse.org/bugs/buglist.cgi?query_format=advanced&short_desc_type=allwordssubstr&short_desc=&classification=RT&product=EclipseLink&long_desc_type=allwordssubstr&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&keywords_type=allwords&keywords=&emailtype1=substring&email1=&emailtype2=substring&email2=&bugidtype=include&bug_id=&votes=&chfieldfrom=-2w&chfieldto=Now&chfieldvalue=&cmdtype=doit&order=Reuse+same+sort+as+last+time&field0-0-0=noop&type0-0-0=noop&value0-0-0= Recent entered, changed bugs]
 
* [https://bugs.eclipse.org/bugs/buglist.cgi?query_format=advanced&short_desc_type=allwordssubstr&short_desc=&classification=RT&product=EclipseLink&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=1&chfieldfrom=&chfieldto=Now&chfieldvalue=&cmdtype=doit&order=Reuse+same+sort+as+last+time&field0-0-0=noop&type0-0-0=noop&value0-0-0= Open bugs with votes]
 
* [https://bugs.eclipse.org/bugs/buglist.cgi?query_format=advanced&short_desc_type=allwordssubstr&short_desc=&classification=RT&product=EclipseLink&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=&cmdtype=doit&order=Reuse+same+sort+as+last+time&negate0=1&field0-0-0=reporter&type0-0-0=substring&value0-0-0=oracle Open bugs from users]
 
 
== Meeting Minutes ==
 
* [http://dev.eclipse.org/mhonarc/lists/eclipselink-dev/msg00368.html Test strategy discussion 2007-12-06]
 
 
==References==
 
* [[EclipseLink/Building| Building EclipseLink including Orbit projects ]]
 
* [[EclipseLink/Building/64bit| EclipseLink 64 Bit Development]]
 
 
[[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