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.
Difference between revisions of "EclipseLink/Development/Testing/Databases"
< EclipseLink | Development | Testing
Line 21: | Line 21: | ||
db.pwd=Or4Us3rP4ssw0rd | db.pwd=Or4Us3rP4ssw0rd | ||
db.platform=org.eclipse.persistence.platform.database.oracle.Oracle11Platform | 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. | Use ''db.oci.url'' only if you have OCI driver available including all dependencies. |
Latest revision as of 09:03, 25 November 2014
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.