Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "EclipseLink/Development/Testing"
< EclipseLink | Development
m (→Testing) |
|||
(28 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | = | + | == Automated Test Runs == |
− | + | * [http://www.eclipse.org/eclipselink/downloads/nightly.php Nightly test results] | |
− | * [http://www. | + | == Required Libraries == |
− | * [[ | + | === 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|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]] | * [[/CacheCoordination|CacheCoordination testing]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |
Latest revision as of 14:03, 18 April 2015
Contents
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: