Skip to main content
Jump to: navigation, search

Difference between revisions of "EclipseLink/Development/Testing"

Line 49: Line 49:
 
== How to Run tests ==
 
== How to Run tests ==
  
* Generic instructions for running tests: [[/EclipseLink/Building#Testing EclipseLink/Building#Testing]]
+
* Generic instructions for running tests: [[/EclipseLink/Building#Testing | EclipseLink/Building#Testing]]
  
 
More detailed information for specific test suites:
 
More detailed information for specific test suites:

Revision as of 14:01, 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

More detailed information for specific test suites:

Back to the top