EclipseLink/Development/Testing
< EclipseLink | Development
Revision as of 14:03, 18 April 2015 by Martin.grebac.oracle.com (Talk | contribs)
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: